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,500 courses taught by industry experts.

Create table in BigQuery

Create table in BigQuery - 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 table in BigQuery

“

- [Instructor] The next step is to create the BigQuery table where we will load and store our data. So I'm once again in the homepage of my Google Cloud project and I will write BigQuery here in the search bar and I will select BigQuery. Now don't worry if you are not familiar with this interface. We will actually explain more in detail later how it works. But for now, what I want you to do is to click on this plus icon over here and then paste the query that I have provided you. Now, I will close this side panel for now and make the text bigger to increase visibility. So let us see what this command is doing. This command will create a new table called stock data, and this table will be stored in the Kaggle stocks dataset. You will remember from our previous video that datasets are like folders that contain our tables. Because the command says create or replace, if the table is already existing, then this command will overwrite it. So be careful when running this command because if…

Contents