⌘+k ctrl+k
1.5 (current)
Search Shortcut cmd + k | ctrl + k
TPC-DS Extension

The tpcds extension implements the data generator and queries for the TPC-DS benchmark.

Installing and Loading

The tpcds extension will be transparently autoloaded on first use from the official extension repository. If you would like to install and load it manually, run:

INSTALL tpcds;
LOAD tpcds;

Usage

To generate data for scale factor 1, use:

CALL dsdgen(sf = 1);

To run a query, e.g., query 8, use:

PRAGMA tpcds(8);
s_store_name sum(ss_net_profit)
able -10354620.18
ation -10576395.52
bar -10625236.01
ese -10076698.16
ought -10994052.78

Listing Queries

To list all 99 queries, run:

FROM tpcds_queries();

This function returns a table with columns query_nr and query.

Listing Expected Answers

To produce the expected results for all queries on scale factors 1 and 10, run:

FROM tpcds_answers();

This function returns a table with columns query_nr, scale_factor and answer.

Generating the Schema

It's possible to generate the schema of TPC-DS without any data by setting the scale factor to 0:

CALL dsdgen(sf = 0);

Data Generator Parameters

The data generator function dsdgen has the following parameters:

Name Type Description
catalog VARCHAR Target catalog
keys BOOLEAN Generate primary and foreign keys
overwrite BOOLEAN (Not used)
schema VARCHAR Target schema
sf DOUBLE Scale factor
suffix VARCHAR Append the suffix to table names

Pre-Generated Datasets

Pre-generated DuckDB databases for TPC-DS are available for download:

Limitations

The tpcds(query_id) function runs a fixed TPC-DS query with pre-defined bind parameters (a.k.a. substitution parameters). It is not possible to change the query parameters using the tpcds extension.

About this page
© 2026 DuckDB Foundation, Amsterdam NL
DuckDB Home Code of Conduct Trademark Use Blog