Skip to main content

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.