> ## 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.

# Firebolt

> Deliver production grade data applications & analytics with Firebolt - the cloud data warehouse for modern data engineering & dev teams

## Overview

Hightouch lets you pull data stored in [Firebolt](https://firebolt.io/) and push it to downstream destinations. Most of the setup occurs in the Hightouch UI, but you need access to Firebolt for information like your database name and credentials.

> [!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.

## Connection configuration

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

* **Username**: This can be your personal Firebolt login or a dedicated user for Hightouch.
* **Password**: The password for the user specified above.
* **Database**: This specifies the database to use when Hightouch connects to Firebolt.
* **Engine**: This specifies the engine to use when Hightouch executes queries in the database defined above. It can be either a general purpose engine or an analytics engine.

You can find this infomration in Firebolt's UI:

![Firebolt engine](https://mintcdn.com/hightouch-3c037897/L_vQfA0JQEpeGUUo/images/sources/source-firebolt-engine.png?fit=max\&auto=format\&n=L_vQfA0JQEpeGUUo\&q=85\&s=9cb63f990d0feab0b8d408cd09cef3f5)

You can also choose to **Automatically start the engine before executing queries**. Warming up the connection can result in faster first queries.

## Test your connection

When setting up Firebolt 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 Firebolt.

The Firebolt 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).