EXTERNAL Table, Data_Source, etc.

torsten.strauss

Hi guys,

The syntax "External Table", "External Data_Source", etc. is not considered by the formatting template, instead SQL prompt even convert it to a sigle row.

CREATE EXTERNAL DATA SOURCE mydatasource

WITH (

    TYPE = HADOOP,

    LOCATION = 'hdfs://xxx.xxx.xxx.xxx:8020'

)

CREATE EXTERNAL FILE FORMAT myfileformat

WITH (

    FORMAT_TYPE = DELIMITEDTEXT,

    FORMAT_OPTIONS (FIELD_TERMINATOR ='|')

);

CREATE EXTERNAL TABLE ClickStream (

    url varchar(50),

    event_date date,

    user_IP varchar(50)

)

WITH (

        LOCATION='/webdata/employee.tbl',

        DATA_SOURCE = mydatasource,

        FILE_FORMAT = myfileformat

    )

;

Thank you for fixing it!

Torsten
MVP

Sujay

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

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.

torsten.strauss

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

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 = 

Sujay

Hi Torsten,

Thank you for the update.

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

Sujay

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.