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

2017年9月21日

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.  

免費帳戶

免費取得 $200 的 Azure 點數與 12 個月的熱門服務

開始免費使用

Visual Studio

訂閱者每年最多可取得價值達 $1800 的 Azure 服務

立即啟用

啟動

加入 BizSpark 方案並取得免費 Azure 服務

深入了解