Loading CSV files from Google Drive to BigQuery

Question

I would like to have my CSV data from Google Drive completely downloaded to Bigquery, like a native table in it. However, the Table type option is not available when I want to upload my data, I have no choice but to use the "external table" option.

This is really unconvenient, as the amount of data I will get in the future will become too important for a Drive Storage.

My question is: is it possible to load a CSV file from Drive to BigQuery as a native table, or do I have to use Google Storage between the two, making the process even more complicated than it already is?

Answer 1

1. Create an external table of the files on Drive.
2. Run a query of the form CREATE TABLE dataset.NewTable AS SELECT * FROM dataset.ExternalTable. Now you have the file contents in a BigQuery-managed table without having to copy to Cloud Storage.