Importing Google Sheets into a BigQuery Table

[DataDave]

Hi

I am importing a table into a BigQuery Dataset from a Google Sheet, using the URL from Google Drive.

Is there a way to import only certain columns from the google sheet and not all of them? There are more columns in the sheet than I need in the BigQuery Table. I need to use the google sheet as a datasource as this is being populated from Netsuite and I need to set up a Schedule within BigQuery to pull in the new data.

Any advice or guidance will be most welcomed.

Many Thanks

[lsolatorio · Accepted solution]

Hi @DataDave,

You can achieve this by setting the Sheet Range when creating a table in your dataset.

Let me guide you with a quick walk-through:

1. Select your dataset in the explorer panel
2. Click on the [+] CREATE TABLE button in the details panel
3. In the Source section, choose the following
   • Create Table From: Drive
   • Select Drive URI: Link address/ URL of your Google Sheet file from Drive
   • File Format: Google Sheet
   • Sheet Range: Specify your column/s here (ex: 'Sheet1'!A2:C)

4. Set your destination Project, Dataset and Table

5. Choose your Schema definition
6. Create your table

You can now run a basic query against the imported table, external data source limitations apply.

I hope these steps helped you.

Usable resource:
- Create external tables

[catherinemiao]

will this table in Bigquery being updated when the spreadsheet is updated?

[ftufekci]

Yes, nearly realtime.

[fabst]

Hi guys

Is it possible to specify more than one range like "Sheet1!A:C;Sheet1!G:K"?

Thanx

[sarah_hussain-1]

Is it mandatory to specify the column and row range or can you just specify the sheet name?