SOLVED

DATE_FORMAT is not supported for EXTERNAL FILE FORMAT.

Copper Contributor

I have been trying to create an external table from a CSV data set that does not use the default date format that synapse understands. So according to the documentation (https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-file-format-transact-sql?view=...) I should be able to specify a user defined format string as you can see in the picture below. But if I do so I get the following error "DATE_FORMAT is not supported for EXTERNAL FILE FORMAT." and I'm not sure what I'm missing in the documentation. I'm currently running in the Serverless SQL pool so could it be that this is just supported for dedicated pools?
Thank you for your time and any help or insights would be greatly appreciated.

Screenshot 2021-05-20 at 17.03.49.png

1 Reply
best response confirmed by GKanitz (Copper Contributor)
Solution

After reaching out to MS I was told that the Serverless SQL pool has limited TSQL support and this seems to be one of the limitations.

Serverless SQL pool - Azure Synapse Analytics | Microsoft Docs

1 best response

Accepted Solutions
best response confirmed by GKanitz (Copper Contributor)
Solution

After reaching out to MS I was told that the Serverless SQL pool has limited TSQL support and this seems to be one of the limitations.

Serverless SQL pool - Azure Synapse Analytics | Microsoft Docs

View solution in original post