> ## Documentation Index
> Fetch the complete documentation index at: https://docs.hightouch.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Rockset

> Rockset is a real-time analytics solution enabling low latency search and aggregations. Using Rockset, you can create personalized user experiences, build real-time decision systems, serve IoT applications, and more, with a real-time indexing database that can power sub-second queries at massive scale.

## Overview

Hightouch lets you pull data stored in [Rockset](https://rockset.com) and push it to downstream destinations. Connecting Hightouch to Rockset requires some setup in both platforms. Specifically, you have to create an Rockset API key to configure your connection in Hightouch.

> [!NOTE]
>
> You may need to allowlist Hightouch's IP addresses to let our systems connect to your warehouse. Reference our [networking docs](https://docs.hightouch.com/security/networking#ip-addresses) to determine which IP addresses you need to allowlist.

## Create Rockset API key

1. Go to the [Rockset Console](https://console.rockset.com/) and open **Manage** > **API Keys**.

![Rockset Console screenshot](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/sources/source-rockset-console.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=834b4d78a489047ba4810ad9973a60bd)

2. Click **Create API key**. Give the API Key a descriptive name, for example "Hightouch Integration," and give it an **admin** role.

![API key creation in the Rockset UI](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/sources/source-rockset-api-key.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=a38b16808bcabb453c15d9ccbd444a18)

3. Click **Submit**. Copy your API key to use it in Hightouch.

## Connection configuration

To get started in Hightouch, go to the [**Sources** overview page](https://app.hightouch.com/sources?from=docs) and click the **Add source** button. Select **Rockset** and enter the following fields into Hightouch:

* **Region**: You can find the region of your Rockset organization in the top left corner of the [Rockset Console](https://console.rockset.com/) Overview.

![API key in the Rockset UI](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/sources/source-rockset-region.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=5d3119792e61229938882dd611483380)

* **API Key**: The API key you previously created.

## Test your connection

When setting up Rockset as a source for the first time, Hightouch checks that you have the correct permissions. Once the test passes, click **Continue** to finish setup.

## Create models

Once your source configuration has passed the necessary validation, your source setup is complete. Next, you can set up [models](https://docs.hightouch.com/getting-started/concepts.md#models) to define which data you want to pull from Rockset.

The Rockset source supports these modeling methods:

* writing a query in [the SQL editor](https://docs.hightouch.com/models/sql-editor.md)
* using the visual [table selector](https://docs.hightouch.com/models/table-selector.md)
* leveraging existing [dbt models](https://docs.hightouch.com/extensions/dbt-models.md)

## Tips and troubleshooting

If you run into an issue this page doesn't cover, [contact support](#pylon-chat).