Load csv file in BQ - too many positional arguments

Question

I tried loading a sample data file [csv] into BQ. Since the CSV has a header, I wanted to skip the first line, Below is the code

  project_id1> load prodtest.prod_det_test gs://bucketname/Prod_det.csv prodno:integer,prodname:string,instock:integer --skip_leading_rows=1

Problem. Too many positional arguments, still have ['- skip_leading_rows = 1']. Please suggest how to solve this problem?

+3

csv google-bigquery

user4033385 12 Sep 14 at 6:08

source to share

1 answer

Mario · Accepted Answer · 2014-09-12T07:28:24+0000

This should work:

bq load --skip_leading_rows=1 prodtest.prod_det_test gs://bucketname/Prod_det.csv prodno:integer,prodname:string,instock:integer

Arguments are at the beginning.