BigQuery data organization

Introduction to BigQuery

Matt Forrest

Field CTO

BigQuery table names

SELECT 
    *
FROM
    `project.dataset.table`

Projects

• Projects handle permissions, users, and controls
• BigQuery can have multiple projects

SELECT 
    *
FROM
    `project.dataset.table`

Datasets

• Datasets are unique to a project
• Act like folders that contain individual tables
• Datasets have their own permissions

SELECT 
    *
FROM
    `project.dataset.table`

Tables

• Tables are where your data resides

SELECT 
    *
FROM
    `project.dataset.table`

Regions

Working with data between regions

• Datasets cannot change regions once created
• There are methods to move/replicate data between regions
• You cannot query data in two different regions

Let's practice!

Introduction to BigQuery