In this lab, you will explore existing datasets with Data Catalog and mine the table and column metadata for insights.
Overview
Syllabus
- GSP789
- Overview
- Start the lab
- Scenario: CEO of NYC transportation company
- Part 1: Explore the existing data environment with the owner role
- Task 1. Confirm the owner role can view and query the new_york_mv_collisions Dataset
- Task 2. Confirm the owner role can view and query the Bike Share dataset
- Part 2: Explore the existing data environment with restricted user access
- Task 3. Log in with the Data Analyst user and confirm restricted project access
- Task 4. Attempt to directly query a private dataset
- Part 3: Using Data Catalog to tag datasets across projects
- Task 5. Create a Data Catalog tag template from a BigQuery dataset
- Task 6. Create a new Data Catalog template
- Congratulations!