CODEWITHSUNDEEP
google-bigquery
Tyler
Tyler

Reputation: 23

Load multiple CSVs from google drive to create one GBQ table

I have 5 CSVs in a google drive folder. I have been able to upload a single csv to create a table, but I would like to upload all 5 files to create a single table.

Is this possible, and if so how would one go about it?

Upvotes: 0

Views: 277

Answers (1)

Max Zolotenko
Max Zolotenko

Reputation: 1132

You can use asterisc "*" to upload multiple files into one table.

enter image description here

Or you can use this bq command:

bq load --source_format=CSV --autodetect YOUR_DATASET_NAME.YOUR_DESTINATION_TABLE_NAME gs://YOUR_BUCKET_NAME/YOUR-FILES-PREFIX-*.csv

Upvotes: 1

Related Questions