Data Shuttle and Googles Sheets that are connected by BigQuery
Hello all I wanted to use Data Shuttle to import data from Google sheets. This sheet has multiple tabs of which some are connected by BigQuery and some are not. When I use Data Shuttle and target the "connected" tabs the mapping only shows the name of the Tab itself and not the column names. But if I select a tab that is not connected to BigQuery I can see all the column names and map to my sheet. Can I use Data Shuttle to import data from a Google sheet tab that is connected?
Best Answer
-
Hey @Elguapo24
I heard from another customer (also using BigQuery and Google Sheets) that if you set First Row = 2 it will pull in the column names and import the data!
Let me know if that resolved your issue.
Cheers,
Genevieve
Answers
-
Hey @Elguapo24
I heard from another customer (also using BigQuery and Google Sheets) that if you set First Row = 2 it will pull in the column names and import the data!
Let me know if that resolved your issue.
Cheers,
Genevieve
-
Yes. That works @Genevieve P.! I ended up figuring it out just this morning by chance. For some reason when a sheet is connected to a data source the first row in Data shuttle is the name of the tab and the second row shows up with the column names. Thank you for your help. I really appreciate it.
