Forum Discussion
Polybase for D365 Datalake
I am currently working with getting data out of the cloud for D365 F&O. Currently the data is exported to the Azure Datalake Gen2. All of the files are in a CSV format and there can be multiple in ...
datascientist1 take a detailed look at the error message, you must specify the collation when creating the external table definition, it's not enough to have the names and data types. Just add "collate SQL_Latin1_General_CPI_CS_AS" as indicated, and in the columns specified in the error message, and you'll be good to go.