CODEWITHSUNDEEP
google-bigquery
Analytics Pipol
Analytics Pipol

Reputation: 19

Google sheets---->BigQuery migration

I have to do a data migration from google sheets to bigquery.

What is the most optimal way to do it? any advice?

Thanks a lot

Upvotes: 1

Views: 77

Answers (2)

Jin Lee
Jin Lee

Reputation: 3512

You can migrate data from Google Sheets to BigQuery by using an Add-ons in your Google Sheets. The name of add-ons is BigQuery Uploader for Sheets.

enter image description here

  • In Google Sheets, go to Add-ons > Get add-ons in the menu and search BigQuery Uploader for Sheets

enter image description here

  • After the installation, you will see the add-ons.

enter image description here

  • You can set up your upload definitions.

enter image description here

  • You can run manual upload or use schedule uploads.

enter image description here

  • If successful, you will see the "Success" message.

enter image description here

  • You can see that data in Google Sheets have been migrated successfully to BigQuery.

enter image description here

enter image description here

enter image description here

Upvotes: 1

Sergey Geron
Sergey Geron

Reputation: 10172

Try creating a table which uses Google Sheet as a datasource. enter image description here https://towardsdatascience.com/connect-bigquery-to-google-sheets-e3c4f1377659

Upvotes: 1

Related Questions