Google Sheet to Dataform

[tushensu]

I want to create a model in Dataform that is a live connection to a google sheet that is stored in google drive.

I want this sheet to be live connected to a table in bigquery. How can I set up a model like this in Dataform ?

[jaia]

Hello,

Thank you for reaching out to us with your request.

We have duly noted your feedback and will thoroughly validate it. While we cannot provide an estimated time of implementation or guarantee the fulfillment of the issue, please be assured that your input is highly valued. Your feedback enables us to enhance our products and services.

Regards,
Jai Ade

[Poulomi_Biswas]

Hi @tushensu,

Welcome to Google Cloud Community!

When you go to BigQuery console and inside any data set, you can use Google Sheets to make a BigQuery table. See “Drive” option in the screenshot below. All it needs is the Google Sheet’s link. BQ link is live with the Google Sheet so any changes in the GSheet is reflected live on BQ table. Assuming you have a Dataform project setup already, you can create a .sqlx file in the project which uses the Google Sheet based BQ table in this way:

config {
type: "table",
destination: "your_project.your_dataset.your_table_name",
# Additional configurations can be set here
}

SELECT *
FROM
`your_project.your_dataset.your_table_name`
WHERE
true

 
Hope this helps!

[jaia]

Hello,

Thank you for your engagement regarding this issue. We haven’t heard back from you regarding this issue for sometime now. Hence, I'm going to close this issue which will no longer be monitored. However, if you have any new issues, Please don’t hesitate to create a new issue. We will be happy to assist you on the same.

Regards,
Jai Ade