google-big-queryHow do I upload a CSV file to Google BigQuery?
- First, create a Google Cloud Storage bucket.
- Next, use the
bqcommand line tool to upload the CSV file to the bucket.bq load --source_format=CSV <dataset>.<table> <csv file> <schema> - Then, create a BigQuery table in the desired dataset.
- Finally, use the
bqcommand line tool to load the CSV file into the table.bq load --source_format=CSV <dataset>.<table> gs://<bucket>/<csv file> <schema>
The bq command line tool can be used to upload a CSV file to Google BigQuery. The command consists of the following parts:
bq: the command line toolload: the command to load data--source_format=CSV: the source format of the data (in this case, CSV)<dataset>.<table>: the destination dataset and table<csv file>: the CSV file to be uploaded<schema>: the schema of the table
If the CSV file is stored in a Google Cloud Storage bucket, the gs://<bucket>/<csv file> should be used instead of <csv file> in the command.
Helpful links
More of Google Big Query
- How do I use a Google BigQuery URL?
- How can I compare Google BigQuery and Amazon Redshift for software development?
- How do I use Google Big Query with Zoom?
- How do I update data in Google BigQuery?
- How do I use Google Big Query to create a tutorial?
- How much does Google Big Query cost?
- How can I set up high availability for Google BigQuery?
- How can I use Google Big Query to analyze data from the GDELT project?
- How can I use Google Big Query to integrate with Zephyr?
- How do I set up a Google Big Query zone?
See more codes...