跳过导航

Skip header rows on SQL Data Warehouse PolyBase load

2018年2月22日

Delimited text files are often created with a header row that contains the column names. These rows need to be excluded from the data set during the load. Azure SQL Data Warehouse users can now skip these rows by using the First_Row option in the delimited text file format for PolyBase loads.

The First_Row option defines the first row that is read in every file loaded. By setting the value to 2, you effectively skip the header row for all files.

For more information, see the documentation for the CREATE EXTERNAL FILE FORMAT statement

 

免费帐户

免费获得 $200 点 Azure 信用额度和 12 个月的常见服务使用权

免费开始使用

Visual Studio

订阅者每年可获得高达 $1800 的 Azure 服务

立即激活

初创企业

加入 Microsoft 初创企业用户行列,获得免费的 Azure 服务

了解更多