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


무료 계정

Azure 크레딧 $200개 및 12개월의 인기 서비스를 무료로 받아보세요.


Visual Studio

최대 $1800 연간 Azure 서비스를 구독자에게 제공

지금 활성화


BizSpark 프로그램에 가입하고 무료 Azure 서비스를 이용하세요

자세한 정보