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
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:
Select your dataset in the explorer panel
Click on the [+] CREATE TABLE button in the details panel
In the Source section, choose the following
Set your destination Project, Dataset and Table
Choose your Schema definition
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:
will this table in Bigquery being updated when the spreadsheet is updated?
Yes, nearly realtime.
Is it mandatory to specify the column and row range or can you just specify the sheet name?
Hi guys
Is it possible to specify more than one range like âSheet1!A:C;Sheet1!G:Kâ?
Thanx
When a bigQuery table uses a google sheet as source, we canât preview data as if the data were actually not stored in BQ. Itâs only visible through a query. Is there a way to have data actually loaded into bigQuery and keep the connection with the spreadsheet in case it is updated? I have software connecting to such a bigQuery table to access the data but it can retrieve any data. Thank you for your help!
Hello ! I have created a table imported from the google sheets and it successfully created. However, I want to know why I donât have a preview on it?
Hello,
You can go to the BigQuery console, navigate to your dataset â click on the Create table â set Create table from to Drive â paste the URL of your Google Sheet in the Select Drive URI field. For File Format, choose Google Sheet. In the Sheet Range field, specify the columns you want to import.
Alternatively, if you need a kind of automation you can use 3rd party tools like Skyvia. This one supports more than 200 connectors, including Netsuite, and allows to easily integrate data between BigQuery and Google Sheets, or directly between BigQuery and NetSuite with no coding. You can integrate just specific columns and even apply filtering, if needed.
I hope it helps you to solve your issue!
Hi @DataDave ,
With the Cooltables add-on for Google Sheets, you can achieve this in 3 clicks:
Other parameters will be auto-detected, including:
To get the add-on, open the Google Sheets Extensions menu. Select âGet add-onsâ and search for âCooltablesâ.
I hope this will be useful.
You canât filter columns directly in the import config, but one workaround is to use a separate tab with only the needed columns and import that. This article explains different ways to load data into BigQuery, and might give you a few ideas - (URL Removed by Staff)
Yes, you are right. BigQuery does not allow directly importing specific columns from a Google sheet or Google Drive URL.
A common workaround is to import the full sheet from the staging table. Next, use a scheduled query to select the needed columns into your final table. The results? You get a clean and efficient pipeline.
To simplify this further, you can use automated ETL tools like Windsor.ai. It helps you manage spreadsheet imports, data transformations, and scheduling through an easy-to-use interface. Plus, it automates repetitive workflows while keeping everything version-controlled and centralized, reducing manual effort and errors.
