BigQuery - Sampling

Table sampling allows you to query subsets of large BigQuery tables, providing diverse records and reduces the cost of scanning the entire table.

This query ~selects 10% of a data:

SELECT * FROM dataset.table TABLESAMPLE SYSTEM (10 PERCENT)

https://cloud.google.com/bigquery/docs/table-sampling

See all notes