Firebolt

IP RESTRICTION

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.

We advise creating a new Firebolt user and grant the suggested access required to create tables and views your Production database.

Create a Firebolt user

Create a new Firebolt user and assign the DB Admin. This user will need to have access to your Production database.

Add Scheduler Connection

To add the Firebolt Scheduler connection, follow these instructions:

1. Click Settings in the top menu bar of the Paradime interface to access Account Settings

2. In the left sidebar, click "Connections"

3. Click "Add New" next to the Bolt Schedules section

4. Select "Firebolt" and fill out the corresponding fields.

Fields Details

Below are list of fields and example to create a connection.

Field	Description	Example
Profile Name	The profile name set in your dbt_project.yaml . See more here.	dbt-firebolt
Target	The target name used to identify the connection. See more here.	prod
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 your Firebolt production database.	analytics_gp
Database	The name of your Firebolt production database.	analytics
Client ID	Your service account 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.	dbt_prod
Threads	Must be set to 1. Multi-threading is not currently supported in Firebolt.	1