TPCH Connector

This connector can also be used to test the capabilities and query syntax of Presto without configuring access to an external data source. When you query a TPCH schema, the connector generates the data on the fly using a deterministic algorithm.

TPCH Schemas

The TPCH connector supplies several schemas:

Every TPCH schema provides the same set of tables. Some tables are identical in all schemas. Other tables vary based on the scale factor which is determined based on the schema name. For example, the schema sf1 corresponds to scale factor and the schema sf300 corresponds to scale factor 300. The TPCH connector provides an infinite number of schemas for any scale factor, not just the few common ones listed by . The tiny schema is an alias for scale factor 0.01, which is a very small data set useful for testing.