Connector Improvement: Google sheets support query()
Answered
The topic here is that I have 8 tabs each independently managed and updated, and I want to query in one connector the aggregate union of all 8 tabs. I use a query() formula roughly looking like the following:
=query({Adidas!A:I;Altra!A:I;Asics!A:I;'La Sportiva'!A:I;'New Balance'!A:I;OOFOS!A:I;Reebok!A:I;Saucony!A:I},"select * where Col1 is not null")
I want to be able to set up fivetran to query the output of this query in a new tab.
If there is another way to get to the same single result I would appreciate guidance. My desire/goal is to have one Fivetran connector to grab one named range of the output of all 8 tabs. Today I have to create 8 individual connectors. Quite a hassle.
-
Official comment
Hi Gene,
Currently the Google Sheets connector supports one tab, so if you were able to create a union of the tabs in one sheet then this could be accomplished. However, this would mean the other 8 source tabs would not be synced by the connector.
Would this potentially solve you use case? Are all tabs relevant for the destination, or just that file tab with the query?
Please sign in to leave a comment.
Comments
1 comment