Loading (n)varchar(max) into Azure SQL Data Warehouse with external tables
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.