---
github_directory: https://github.com/duckdb/duckdb/tree/main/extension/tpcds
layout: docu
redirect_from:
- /docs/extensions/tpcds
- /docs/stable/extensions/tpcds
- /docs/preview/core_extensions/tpcds
- /docs/stable/core_extensions/tpcds
title: TPC-DS Extension
---

> Warning The `tpcds` extension will change in DuckDB version 2.0 to make the generator compatible with TPC-DS version 4.
> See the [related PR](https://github.com/duckdb/duckdb/pull/21746) for more details.

The `tpcds` extension implements the data generator and queries for the [TPC-DS benchmark](https://www.tpc.org/tpcds/).

## Installing and Loading

The `tpcds` extension will be transparently [autoloaded]({% link docs/current/extensions/overview.md %}#autoloading-extensions) on first use from the official extension repository.
If you would like to install and load it manually, run:

```sql
INSTALL tpcds;
LOAD tpcds;
```

## Usage

To generate data for scale factor 1, use:

```sql
CALL dsdgen(sf = 1);
```

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

```sql
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:

```sql
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:

```sql
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:

```sql
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. Note that these were generated with DuckDB v1.x.
DuckDB v2.x generates slightly different TPC-DS files, compatible with TPC-DS v4.

* [`tpcds-sf10.db`](https://blobs.duckdb.org/data/tpcds-sf10.db) (2.9 GB)
* [`tpcds-sf30.db`](https://blobs.duckdb.org/data/tpcds-sf30.db) (7.7 GB)
* [`tpcds-sf100.db`](https://blobs.duckdb.org/data/tpcds-sf100.db) (26.6 GB)
* [`tpcds-sf300.db`](https://blobs.duckdb.org/data/tpcds-sf300.db) (79.3 GB)

## Limitations

The `tpcds(⟨query_id⟩)`{:.language-sql .highlight} 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.