Forum Discussion
DATE_FORMAT is not supported for EXTERNAL FILE FORMAT.
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=azure-sqldw-latest&tabs=delimited#examples) 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.
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.
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/on-demand-workspace-overview
1 Reply
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.
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/on-demand-workspace-overview