EXTERNAL Table, Data_Source, etc.

• 
  Hi Torsten,

  
  

  Thank you for your forum post.

  I have forwarded this to the development team.
  

  I will update here as soon as there are more details available.

  
  

  Best Regards,

  Sujay
  

  Sujay July 07, 2023 05:39

  - 0 +
• 
  Hi Torsten,

  
  

  The feature has been added in the SQL Prompt release 10.14.9

  This can be downloaded from https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.14.9.7331.exe

  
  

  Please let me know if this works for you.
  

  
  

  Sujay March 25, 2024 23:47

  - 0 +
• 
  Hi Sujay,
  
  thank you for fixing this but it is still not working as expected.
  
  

  CREATE EXTERNAL DATA SOURCE [sample-data-files]
  WITH
  	(TYPE=BLOB_STORAGE,
  		LOCATION = 'https://sqlvawrfhaejbb3ibq.blob.core.windows.net/sample-data-files'
  	  , CREDENTIAL = [sqlvawrfhaejbb3ibq-sample-data-files]
  	);
  GO

  
  

  torsten.strauss March 28, 2024 08:23

  - 0 +
• 

  CREATE EXTERNAL DATA SOURCE [sample-data-files]
  WITH
  	(
  	    TYPE = BLOB_STORAGE
  	  , LOCATION = 'https://sqlvawrfhaejbb3ibq.blob.core.windows.net/sample-data-files'
  	  , CREDENTIAL = [sqlvawrfhaejbb3ibq-sample-data-files]
  	);
  GO
  

  It should look like this ...
  There is also a missing space after TYPE and =

  torsten.strauss March 28, 2024 08:31

  - 0 +
• 
  Hi Torsten,

  
  

  Thank you for the update.

  I have forwarded this to the development team to look into further.
  

  Sujay April 04, 2024 07:10

  - 0 +
• 
  Hi Torsten,

  
  

  My apologies for the long delay.

  The issue is fixed and available in the latest version of SQL Prompt (10.15.0) which can be downloaded from https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.15.0.12121.exe

  
  

  Please let us know if this works for you.
  

  
  

  Sujay November 18, 2024 07:05

  - 0 +

Add comment

Please sign in to leave a comment.