Polybase has a maximum row size of 32 KB in SQL Server (or 1 MB in Azure Synapse Analytics). As a good rule of thumb, when creating NVARCHAR columns with the CREATE EXTERNAL TABLE statement, set the size to 255 unless you need more space. This will also help to make processing times faster and avoid using more resources than necessary.
This topic has been closed for comments
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers