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

# Firebolt

> Connect Firebolt to Paradime to run dbt™ against your Firebolt engines and databases from the Code IDE, Bolt, and Agent environments.

[Firebolt](https://www.firebolt.io/) is a cloud data warehouse for storing and querying your data. Connect it to Paradime to run dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent work against your warehouse.

<Warning>
  **IP restrictions**

  Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

  See also: [Paradime IP addresses](/developers/ip-restrictions).
</Warning>

<Note>
  **Available in:** Code IDE, Bolt, and Agent environments.
</Note>

## Create a Firebolt user

<Tabs>
  <Tab title="Bolt">
    We advise creating a new Firebolt user and granting the suggested access required to create tables and views in your Production database.

    Create a new Firebolt user and assign the `DB Admin` role. This user will need to have access to your Production database.
  </Tab>

  <Tab title="Agent">
    We recommend creating a dedicated Firebolt service user for the Agent environment, with the minimum permissions required to create tables and views in your database.

    Create a new Firebolt user and assign the `DB Admin` role. This user will need access to the database used by the Agent environment.
  </Tab>
</Tabs>

## Add a connection

You will be prompted to add a Code IDE connection during onboarding, or you can add more connections by completing the following:

1. Click **Settings** in the top menu bar of the Paradime interface to access **Workspace Settings**.
2. In the left sidebar, click **Environments**.
3. Click **Add New** next to the section for the environment you are configuring:
   * **Code IDE** for the Code IDE connection
   * **Bolt** for the Bolt connection
   * **Agent** for the Agent connection
4. Select **Firebolt** and fill out the corresponding fields.

## Field details

<Info>
  Field access levels apply only to the **Code IDE** environment: an `Admin` sets workspace-level fields, and each developer sets their own user-level fields. In the Bolt and Agent environments, an `Admin` sets all fields.
</Info>

| Field         | Description                                                                                                                                                                                                                    | Example                   |
| ------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------- |
| Profile Name  | The profile name set in your `dbt_project.yaml`. See more [here](https://docs.getdbt.com/docs/core/connect-data-platform/connection-profiles).                                                                                 | **`dbt-firebolt`**        |
| Target        | The target name used to identify the connection. See more [here](https://docs.getdbt.com/reference/dbt-jinja-functions/target).                                                                                                | **`dev`**                 |
| Host Name     | The host name of the connection. For all customers it is `api.app.firebolt.io`.                                                                                                                                                | **`api.app.firebolt.io`** |
| Account Name  | Specifies the account name (not the account ID) under which the specified `database` exists.                                                                                                                                   | **`acme`**                |
| Engine Name   | The name of the Firebolt engine to use.                                                                                                                                                                                        | **`analytics_gp`**        |
| Database      | The name of your Firebolt database.                                                                                                                                                                                            | **`analytics`**           |
| Client ID     | Your [service account](https://docs.firebolt.io/Guides/managing-your-organization/service-accounts.html) ID.                                                                                                                   | **`client_id_xyz`**       |
| Client Secret | The secret associated with the specified `client_id`.                                                                                                                                                                          | **`client_secret_xyz`**   |
| Schema        | Recommended. A string to add as a prefix to the names of generated tables when using the [custom schemas workaround](https://docs.getdbt.com/reference/warehouse-profiles/firebolt-profile#supporting-concurrent-development). | **`dbt_john`**            |
| Threads       | Must be set to `1`. Multi-threading is not currently supported in Firebolt.                                                                                                                                                    | **`1`**                   |

## Related

<CardGroup cols={2}>
  <Card title="Optional connection attributes" href="/guides/data-warehouse-essentials/optional-connection-attributes" icon="gear" horizontal>
    Set additional `profiles.yml` attributes for this connection.
  </Card>
</CardGroup>


## Related topics

- [Security model](/resources/other-important-stuff/security-model.md)
- [Bolt environment](/products/settings/connections/scheduler-environment/index.md)
- [Agent environment](/products/settings/connections/dinoai-background-agent-environment/index.md)
- [Code IDE environment](/products/settings/connections/development-environment/index.md)