CODEWITHSUNDEEP
csvgoogle-bigquery
Daniel
Daniel

Reputation: 1

Loading CSV file from Google Drive to BigQuery produces zero rows with no errors

A vendor provided me with a set of CSV files over Google Drive. When I load it to a new table in BigQuery using the URL to its location in Google Drive it seems to work without any errors, but there are zero rows in the table. The schema loads correctly. When I download the file to my hard drive and upload the same file it works fine - all of the data is there.

Any thoughts on what the problem might be or how to diagnose it?

Upvotes: 0

Views: 376

Answers (1)

Daniel
Daniel

Reputation: 1

"Loading data into BigQuery from Google Drive is not currently supported, but you can query data in Google Drive by using an external table."

Upvotes: 0

Related Questions