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.

.. csv-table::
  :header: Schema name,Dataset
  :widths: 20,20
  :align: left
  :class: longtable

  `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.