From the course: Build a No-Code ETL Pipeline with Google BigQuery

Unlock this course with a free trial

Join today to access over 24,800 courses taught by industry experts.

Create a data source

Create a data source - BigQuery Tutorial

From the course: Build a No-Code ETL Pipeline with Google BigQuery

Start my 1-month free trial Buy for my team

Create a data source

“

- [Instructor] Here I am in the Looker Studio interface. And I have logged in with the same email that I use on Google Cloud. Now, the first thing that I want to do is to add our analytics table as a data source, so that I can build dashboards on top of this data. To do this, I will select data sources here, and then I will go on create data source. And here you can see all the different connectors that are available to get data into Looker Studio. And what I need to select here is BigQuery. And next, I need to find my data. So here I have selected my project and my dataset, and I will select the stock_data_dwh table. Now I can click on Connect. So what we see here is that Looker Studio has loaded the schema for my table. And for each field, it has assigned a Looker Studio data type. And we can check that these types make sense for us. So brand name is Text, capital gains and close are number, country is text, date is date and time. So if you look at all these fields, you'll see that…

Contents