CODEWITHSUNDEEP
google-bigquery
Espresso
Espresso

Reputation: 5739

Google: Bigquery does not have option to import from specific google-drive-sheet1

In one GoogleSheet, I have two tables, in sheet1 I have table EXP1_ASTROCYTOMA, in sheet2 I have table EXP1_GLIOBLASTOMA.

Is there a way to import that into bigquery dataset by choosing Sheet1 to one table and sheet 2 to another table?

It does not import sheet2!

Upvotes: 0

Views: 599

Answers (2)

SANN3
SANN3

Reputation: 10099

In BigQuery we can import the data from the specific sheets. Refer the Sheet range field in the import screen. I tried importing the specific sheet by mentioning its name and its working.

enter image description here

Upvotes: 2

Pavlo H
Pavlo H

Reputation: 89

Update after discussion in comments:

BigQuery exports data only from 1st sheet(tab) of your spreadsheet file.

1.If your objective is to do export from tab 1, run query, save output and do same for tab 2, do this: Just click on 2nd sheet(tab) and drag it on 1st position, then create table on BQ side with same link to sheets as before.

  1. If you need to have BQ tables from each tab on regular base: Create new spreadsheet and do IMPORTRANGE of your 2nd tab there. Than use 2 different sheets as datasources of 2 BQ tables.

Upvotes: 0

Related Questions