Benchmark datasets v1.6

Suggest edits

You can use our public S3 buckets in AWS that contains sample benchmarking datasets. They are available through the following endpoints:

s3://beacon-analytics-demo-data-ap-east-1-prod
s3://beacon-analytics-demo-data-ap-northeast-1-prod
s3://beacon-analytics-demo-data-ap-northeast-2-prod
s3://beacon-analytics-demo-data-ap-south-1-prod
s3://beacon-analytics-demo-data-ap-south-2-prod
s3://beacon-analytics-demo-data-ap-southeast-1-prod
s3://beacon-analytics-demo-data-ap-southeast-2-prod
s3://beacon-analytics-demo-data-ap-southeast-3-prod
s3://beacon-analytics-demo-data-ca-central-1-prod
s3://beacon-analytics-demo-data-eu-central-1-prod
s3://beacon-analytics-demo-data-eu-south-2-prod
s3://beacon-analytics-demo-data-eu-west-1-prod
s3://beacon-analytics-demo-data-eu-west-2-prod
s3://beacon-analytics-demo-data-us-east-1-prod
s3://beacon-analytics-demo-data-us-east-2-prod
s3://beacon-analytics-demo-data-us-west-2-prod

You can query tables in these datasets by referencing them with their schema name.

Schema name	Dataset
`tpcds_sf_1`	TPC-DS, Scale Factor 1
`tpcds_sf_10`	TPC-DS, Scale Factor 10
`tpcds_sf_100`	TPC-DS, Scale Factor 100
`tpcds_sf_1000`	TPC-DS, Scale Factor 1000
`tpch_sf_1`	TPC-H, Scale Factor 1
`tpch_sf_10`	TPC-H, Scale Factor 10
`tpch_sf_100`	TPC-H, Scale Factor 100
`tpch_sf_1000`	TPC-H, Scale Factor 1000
`clickbench`	ClickBench, 100 million rows
`brc_1b`	Billion row challenge

Note

The data column EventData for the ClickBench dataset is an integer, not dates. You must quote ClickBench column names because they contain uppercase letters, but unquoted identifiers in Postgres are case-insensitive.

← Prev

Data types and definitions

↑ Up

Reference