From the course: Learning BigQuery
Unlock this course with a free trial
Join today to access over 25,300 courses taught by industry experts.
Defining a BigQuery table from the UI - BigQuery Tutorial
From the course: Learning BigQuery
Defining a BigQuery table from the UI
- [Instructor] Having created a dataset in a GCP project, it's now time for us to provision a table within the dataset. If you have the dataset info up, you should see this option to create a new table from here. Alternatively, we can head over to the project, then over to the dataset and choose the option to create a table. Of course, a form will pop up and we have the option of specifying a source for our table. This will allow us to pull in data from already existing sources such as the Google cloud storage, we could upload a file from our own file systems, and then there are handful of other options here, which includes connecting to an Amazon S3 bucket. The first table we create will be rather simple. In fact, it'll be an empty table. We also have the option of changing the project and dataset here. I'll just leave that untouched. As for the table name, I'm just going to call this Students since we will be storing…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
Configuring the GCP3m 33s
-
(Locked)
Creating a BigQuery dataset5m 16s
-
(Locked)
Defining a BigQuery table from the UI4m 45s
-
(Locked)
Querying a simple BigQuery table4m 56s
-
(Locked)
Uploading data to create a BigQuery table3m 56s
-
(Locked)
Querying data and viewing statistics of queries3m 31s
-
(Locked)
Reading JSON data into a BigQuery table2m 28s
-
(Locked)
Creating a table from a query result4m 22s
-
(Locked)
Creating a table from a filter2m 27s
-
-
-
-
-