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 set up a Google Big Query zone?
- How do I use wildcards in Google BigQuery?
- How can I use Google Big Query with Grafana to visualize data?
- How can I use Google Big Query to integrate with Zephyr?
- How do I use Google Big Query to zip files?
- ¿Cuáles son las ventajas y desventajas de usar Google BigQuery?
- How can I export data from Google Big Query to an XLSX file?
- How can I use Google BigQuery to retrieve data from a specific year?
- How can I use the CASE WHEN statement in Google Big Query?
- How can I use Google BigQuery to wait for a query to complete?
See more codes...