Loading (n)varchar(max) into Azure SQL Data Warehouse with external tables

Thursday, September 21, 2017

Azure SQL Data Warehouse now supports (n)varchar(max) for external tables.


By using the simplicity and performance of external tables, you can load very wide columns into Azure SQL Data Warehouse. This improvement enables you to use LOB data types to define individual columns within the 1-MB row width limit. This limits the theoretical maximum size of the LOB data type to 1 MB when a single column is defined.


For more information about loading data into SQL Data Warehouse by using external tables, see the tutorial.  

Free account

Get $200 in Azure credits and 12 months of popular services—free

Start free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now


Join the BizSpark program and get free Azure services

Learn more