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

Пікірлер: 10

  • @tyroneogarrojr.3448
    @tyroneogarrojr.3448 Жыл бұрын

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

  • @mohamedelsayad2479
    @mohamedelsayad24792 жыл бұрын

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

  • @rafaelpochmorell1717
    @rafaelpochmorell17172 жыл бұрын

    Excellent !!!

  • @felipebag
    @felipebag Жыл бұрын

    Thank You!!!

  • @brostone2538
    @brostone25382 жыл бұрын

    awesome

  • @ToanTran-gh9ls
    @ToanTran-gh9ls Жыл бұрын

    thank you!

  • @smallypuppy22
    @smallypuppy222 жыл бұрын

    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
    @darknes543212 жыл бұрын

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

  • @k12analyticsengineering

    @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

    @markgarrett2971

    2 жыл бұрын

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