ODBC drivers in Polybase: Avoiding issues with NVARCHAR columns

  • 14 August 2023
  • 0 replies
  • 5 views

Userlevel 2
Badge

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