From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Create a table with schema

Create a table with schema

From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Start my 1-month free trial

Create a table with schema

“

- [Instructor] Now that we have created a data set called patient data, let's create a table with schema, and then load data into this table from a CSV file. For this, we are going to go back to the BigQuery dashboard. In the data set list shown on the left side pane, click on the plus icon to open up the create table UI. The first option shown is whether you want to create the table from a source, like a file or Google Cloud storage, BigTable, or Google Drive. We can also create an empty table, which we are going to do here. So, let us choose empty table. Enter the name patient details in the box. BigQuery supports different data types. If the table is created from scratch, like we do here, it uses its native storage for the table. If the table is created from another source like BigTable, we can choose to make them as external tables, too. External tables continue to be stored in the sort system while offering querying capabilities through BigQuery. Let us now define the schema for…

Contents