Google Cloud Platform: Partitioning and Clustering in BigQuery

BigQuery is a serverless fully-managed, petabyte-scale, low-cost enterprise data warehouse for analytics.

A BigQuery dataset resides in a GCP project and contains one or more tables.

In this demo is shown how to use the BigQuery web UI in the GCP Console to understand partitioning and clustering in BigQuery. BigQuery's table partitioning and clustering helps structuring your data to match common data access patterns. Partition and clustering is key to fully maximize BigQuery performance and cost when querying over a specific data range. It results in scanning less data per query, and pruning is determined before query start time.

Видео Google Cloud Platform: Partitioning and Clustering in BigQuery канала Tiago Medici