From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Tables
From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Tables
- In this video, I will explore BigQuery tables. A BigQuery table is the container of data for similar sets of entity. It is fairly similar to a regular defactor RDBMS table. Recall that a table contains rows and columns. An example of a row is a purchase order. And the columns in the row will represent various attributes of that order, like order date, product ordered, and price. Tables in BigQuery have schema. The schema represents the columns in the table, and their data types and sizes. A schema can either be defined during table creation, or during data load time. There is flexibility to do just in time definition, or automatically datamine the schema from the source data. A schema can of course be modified to add or drop columns as needed. BigQuery supports a number of data types for columns in a table. Floating point, numeric and integer data types can be used to represent numbers. Boolean type is used to draw present true or false. String is used to represent ex data. Bytes…
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.
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.