Learning BigQuery

Introduction

• Introducing BigQuery

1. Introducing BigQuery

• BigQuery services and compute process
• The arrangement of data in BigQuery
• Data sources and queries in BigQuery
• The BigQuery cost structure

2. Creating and Working with Datasets and Tables

• Configuring the GCP
• Creating a BigQuery dataset
• Defining a BigQuery table from the UI
• Querying a simple BigQuery table
• Uploading data to create a BigQuery table
• Querying data and viewing statistics of queries
• Reading JSON data into a BigQuery table
• Creating a table from a query result
• Creating a table from a filter

3. Executing Queries and Visualizing Results

• Public datasets in BigQuery
• Configuring and using BigQuery caches
• External BigQuery tables
• Integrating BigQuery with Data Studio
• Geographic points in BigQuery
• Visualizing geographical data with Geo Viz

4. Creating and Working with Views

• Saving query results using views
• Querying views vs. querying the original tables
• Materialized views in BigQuery
• Defining a restricted view of data
• Granting a user project-level access
• Setting up an authorized view

5. Using the bq Command-Line Tool

• Configuring the bq shell
• Executing queries from the BigQuery command-line

Conclusion

• Summary and next steps