Firebolt - Paradime

IP RESTRICTIONMake 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:

Click Settings in the top menu bar of the Paradime interface to access Account Settings
In the left sidebar, click “Connections”
Click “Add New” next to the Bolt Schedules section
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`

​Create a Firebolt user

​Add Scheduler Connection

​Fields Details

Create a Firebolt user

Add Scheduler Connection

Fields Details