Query Data From Google Cloud Storage In Google BigQuery With BigQuery API In Python

preview_player
Показать описание
In this tutorial, we will learn how to run queries against data stored in Google Cloud Storage in Google BigQuery using BigQuery API in Python.

I will share two examples. One example is to query dataset in a Google Cloud Storage as a temporary table. The other example is to establish a permanent external connection to a Cloud Storage dataset in BigQuery for re-usability.

► Buy Me a Coffee? Your support is much appreciated!
-------------------------------------------------------------------------------------------
☕ Venmo: @Jie-Jenn

► Support my channel so I can continue making free contents
---------------------------------------------------------------------------------------------------------------

#bigquery #googlebigquery #gbq
Рекомендации по теме
Комментарии
Автор

Jie, thank you for this tutorial. I am looking to import data from an external API to BigQuery in order to later connect it to Looker Studio and do some data analysis. Could you please make a tutorial about how to do this correctly using Cloud Functions, Scheduler and Storage? And specifically, how to make sure that data gets replaced in BigQuery, not appended. Thanks!

MrValVet