TPC-DS 10TB

# Standard TPC-DS 10TB schema generated via TPC benchmark tools, shared publicly to enable easy testing on Snowflake.

<p><br/></p>

## Database and Schemas

Snowflake provides TPC-DS schema of 10TB, in schemas named TPCDS_SF10TCL, within this listing.

<p><br/></p>

## Database Entities, Relationships, and Characteristics

TPC-DS consists of 7 fact tables and 17 dimensions in the following schemas:<br/><br/>TPCDS_SF10TCL: The 10 TB (scale factor 10,000) version represents 65 million customers and over 400,000 items stored, with sales data spanning 3 channels — stores, catalogs, and the web — covering a period of 5 years. The largest table, STORE_SALES, contains nearly 29 billion rows, and the fact tables contain over 56 billion rows in total.<br/><br/>The relationships between facts and dimensions are represented through joins on surrogate keys. The detailed relationships are too numerous to display here, but can be found in the TPC-DS specification.

## <br/>Query Definitions

TPC-DS contains a set of 99 queries with wide variation in complexity and range of data scanned. Each TPC-DS query asks a business question and includes the corresponding query to answer the question. We have generated samples of all 99 TPC-DS queries for you to explore. Alternatively, you can use the tools in the TPC-DS Benchmark Kit to generate many different versions of these queries that vary by parameter values.<br/>

We recommend to use a 2XL warehouse to run but you can expect a faster or slower performance if you choose larger or smaller size warehouses and try out the elasticity of Snowflake data warehouse.

<br/>For the full set of TPC-DS queries to run against this data set, please refer to the [Documentation](https://docs.snowflake.com/en/user-guide/sample-data-tpcds).