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 views
From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Create views
- [Instructor] Similar to other RDBMS database products, BigQuery allows you to create views on data that makes querying easier. Let us create a query that joins the patient details and the test results table. First, we're gonna create a query here. Then, we run the query to see how the results show up, then we then click Save View to save this query as a view. In the Table ID, we are going to provide Patient_all as the name. Click OK. Now you see Patient_all showing up on the left side. It has a different icon to indicate that it is a view. This table then can be looked at in a similar fashion like normal tables are used.
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.