Benchmark datasets

Benchmark datasets#

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.