From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Create labels
From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Create labels
- [Instructor] When a BigQuery repository is used by multiple individuals and teams, and they end up creating too many data sets and tables, it becomes difficult to track why they are created and of what purpose. Sometimes it is important to group these resources for billing or other purposes. You can do the same by creating labels. Labels are name value paths that can be used to attach a piece of metadata to a resource like a data set, a table, or a view. I will show you how to create and manage tables in BigQuery. We will first open up the Google Cloud shell. The steps I'm doing on the cloud shell are also possible to be done through the console. First I'm gonna create a label called department and assign a value hospital to the PatientData data set. I do that using the command bq update set label department as hospital for PatientData. Next, we can look at the labels for a given data set using the following command, bq show format as pretty the project ID followed by the data set…
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.