Connecting Google Sheets to BigQuery

This video covers how to connect Google Sheets to Google BigQuery so data can be transformed via SQL. I connect a Sheet to BigQuery and use dbt to manage the SQL transformation work to connect that data to data brought in from the Ed-Fi ODS.
K12 Analytics Engineering dbt repo:
github.com/xmarcosx/dbt

[@tyroneogarrojr.3448]

Very informal video, great tip about creating the schema to prevent any upload errors

[@mohamedelsayad2479]

Seriously.. I've been looking for how to do this for 2 days !! THANK YOU !!

[@rafaelpochmorell1717]

Excellent !!!

[@felipebag]

Thank You!!!

[@ToanTran-gh9ls]

thank you!

[@brostone2538]

awesome

[@smallypuppy22]

Hello sir! I have been watching your videos and they seem extremely helpful for something I have to do at work. Is there a complete course that I can take?

[@darknes54321]

Thank you! What if I want to keep the BQ table automatically updated as the data is changed in the connected Google Sheet?

[@k12analyticsengineering]

Great question, the BigQuery table is always up to date because the table is not actually storing any data in BigQuery itself. It is an external table which means every time a SQL query is run on the table, BigQuery pulls from the Sheet.

[@markgarrett2971]

@@k12analyticsengineering So in my own words, the query I see in BigQuery is actually from data within my google sheet?