From the course: Build a No-Code ETL Pipeline with Google BigQuery
Join today to access over 24,800 courses taught by industry experts.
Create and modify tables in BigQuery - BigQuery Tutorial
From the course: Build a No-Code ETL Pipeline with Google BigQuery
Create and modify tables in BigQuery
- [Narrator] Let us see how we can create and modify tables in BigQuery. There are typically two ways to do these things in BigQuery. One is using the interface and the other one is using code. So let us look at both of them and let us start with creating a table. To create a table via the interface, I will go to my Explorer over here and open my project. And then I will open the dataset where I want to put my table. And on these three dots over here, I will select Create table. So in this form I can create a new table and the first thing that I need to choose is the source. So there are several sources here available for creating the table. What I want to show you is that you can upload a local file from your computer to create a table in BigQuery. So I will select Upload, and I will go on browse here to get the file. And here I have the data for my kaggle_stocks, and I will select the first file. Now as you see, BigQuery has already detected that the file format is CSV. Next is the…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.