Connecting Google Sheets to BigQuery
Рет қаралды 9,931
Күн бұрын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 2 жыл бұрын
Seriously.. I've been looking for how to do this for 2 days !! THANK YOU !!
@rafaelpochmorell1717 2 жыл бұрын
Excellent !!!
@felipebag Жыл бұрын
Thank You!!!
@ToanTran-gh9ls Жыл бұрын
thank you!
@brostone2538 2 жыл бұрын
awesome
@smallypuppy22 2 жыл бұрын
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 2 жыл бұрын
Thank you! What if I want to keep the BQ table automatically updated as the data is changed in the connected Google Sheet?
@k12analyticsengineering 2 жыл бұрын
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 2 жыл бұрын
@@k12analyticsengineering So in my own words, the query I see in BigQuery is actually from data within my google sheet?
Arrogant Sage Media
Рет қаралды 2 М.
Edmilson Alves - Infinity Big Data
Рет қаралды 1,1 М.
HighLoad Channel
Рет қаралды 8 М.
Soham Kamani
Рет қаралды 11 М.