CODEWITHSUNDEEP
csvgoogle-bigquery
user4033385
user4033385

Reputation: 553

load csv file into BQ - too many positional args

I tried loading a sample data file [csv] in BQ. Since CSV has header I wanted to skip first row, Following 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

Issue: Too many positional args, still have['--skip_leading_rows=1']. Please suggest how to resolve this issue?

Upvotes: 4

Views: 4006

Answers (1)

Mario
Mario

Reputation: 1230

This should work:

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

The -- arguments come at the beginning.

Upvotes: 3

Related Questions