google-big-queryHow do I upload a CSV file to Google BigQuery?
- First, create a Google Cloud Storage bucket.
- Next, use the
bq
command 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
bq
command 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
- ¿Cuáles son las ventajas y desventajas de usar Google BigQuery?
- How do I start using Google Big Query?
- How can I compare Google BigQuery and Snowflake for software development?
- How do I use the "not in" operator in Google BigQuery?
- How do I use Google Big Query to merge data?
- How do I add the Google Big Query logo to my website?
- How do I use Google Big Query with Zoom?
- How do I use Google Big Query with Excel?
- How can I use Google Big Query to analyze Reddit data?
- How can I use Google Big Query to integrate with Zephyr?
See more codes...