# Connect Rockset to dbt Core

Local development

Vendor-supported plugin

Certain core functionality may vary. If you would like to report a bug, request a feature, or contribute, you can check out the linked repository and open an issue.

* **Maintained by**: Rockset, Inc.
* **Authors**: Rockset, Inc.
* **GitHub repo**: [rockset/dbt-rockset](https://github.com/rockset/dbt-rockset) [![](https://img.shields.io/github/stars/rockset/dbt-rockset?style=for-the-badge)](https://github.com/rockset/dbt-rockset)
* **PyPI package**: `dbt-rockset` [![](https://badge.fury.io/py/dbt-rockset.svg)](https://badge.fury.io/py/dbt-rockset)
* **Slack channel**: [#dbt-rockset](https://getdbt.slack.com/archives/C02J7AZUAMN)
* **Supported dbt Core version**: v0.19.2 and newer
* **dbt support**: Not Supported
* **Minimum data platform version**: ?

## Installing dbt-rockset

Use `pip` to install the adapter. Use the following command for installation:

`python -m pip install dbt-rockset`

## Configuring dbt-rockset

For Rockset-specific configuration, please refer to [Rockset configs.](../../../reference/resource-configs/no-configs.md)

## Connecting to Rockset with **dbt-rockset**

The dbt profile for Rockset is very simple and contains the following fields:

profiles.yml

```yaml
rockset:
  target: dev
  outputs:
    dev:
      type: rockset
      workspace: [schema]
      api_key: [api_key]
      api_server: [api_server] # (Default is api.rs2.usw2.rockset.com)
```

### Materializations

| Type        | Supported? | Details                                                                                                                                |
| ----------- | ---------- | -------------------------------------------------------------------------------------------------------------------------------------- |
| view        | YES        | Creates a [view](https://rockset.com/docs/views/#gatsby-focus-wrapper).                                                                |
| table       | YES        | Creates a [collection](https://rockset.com/docs/collections/#gatsby-focus-wrapper).                                                    |
| ephemeral   | YES        | Executes queries using CTEs.                                                                                                           |
| incremental | YES        | Creates a [collection](https://rockset.com/docs/collections/#gatsby-focus-wrapper) if it doesn't exist, and then writes results to it. |

## Caveats

1. `unique_key` is not supported with incremental, unless it is set to [\_id](https://rockset.com/docs/special-fields/#the-_id-field), which acts as a natural `unique_key` in Rockset anyway.
2. The `table` materialization is slower in Rockset than most due to Rockset's architecture as a low-latency, real-time database. Creating new collections requires provisioning hot storage to index and serve fresh data, which takes about a minute.
3. Rockset queries have a two-minute timeout. Any model which runs a query that takes longer to execute than two minutes will fail.

## Was this page helpful?

YesNo

[Privacy policy](https://www.getdbt.com/cloud/privacy-policy)[Create a GitHub issue](https://github.com/dbt-labs/docs.getdbt.com/issues)

This site is protected by reCAPTCHA and the Google [Privacy Policy](https://policies.google.com/privacy) and [Terms of Service](https://policies.google.com/terms) apply.