Forum Discussion
Solved
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...
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
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