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.
Projects and datasets
From the course: Data Science on Google Cloud Platform: Designing Data Warehouses
Projects and datasets
- [Instructor] Before we jump into BigQuery programming, I want to give you a quick overview of two items, projects and datasets. Projects play a key role in grouping elements in BigQuery. GCP projects define the parent container inside which all data resides in BigQuery. Different projects can have different BigQuery instances. Access is controlled individually or through project-level controls. Next comes the BigQuery dataset. A BigQuery dataset is similar to the concept of databases in other RDBMS. Datasets govern the geographical location of data within the particular dataset. Locations supported include US, Europe, and Asia. Tables created within a dataset in one location cannot be joined with tables in other locations. Datasets also provide logical grouping of information similar to databases. You can create different datasets for different applications like inventory, finance, et cetera, or for different purposes like development, QA, and production. Datasets contain table…
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.