TPC-DS 10TB Managed Iceberg
收藏资源简介：
# Standard TPC-DS 10TB schema in Managed Iceberg format 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 Managed Iceberg format, in schemas named TPCDS_SF10T_ICEBERG, within this listing. ## <br/>Database Entities, Relationships, and Characteristics TPC-DS consists of 7 fact tables and 17 dimensions in the following schemas:<br/><br/>TPCDS_SF10T_ICEBERG: 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).
