
Data Engineering with Google Cloud Platform
By :

Now let's start our exercise; we will try to use data visualization for exploration and reporting. You will only need Data Studio and BigQuery for the exercise in this chapter. Note that using Data Studio is free.
There will be two main things that we will be doing in this section:
INFORMATION_SCHEMA
table using Data StudioBefore trying Data Studio, let's get familiar with INFORMATION_SCHEMA in BigQuery.
INFORMATION_SCHEMA
is a collection of tables in BigQuery that stores your BigQuery metadata. For example, if you want to know how many tables you have in your project, you can use the table INFORMATION_SCHEMA
view. The other common example is that you might be wondering how much a query costs per job, day, or month. To do that, you...