Firebolt connection

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 Production Connection

To add the Firebolt Production connection, go to account settings > connections, select Production Environment and enter the required 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
Username	A Firebolt username with adequate permissions to access the specified engine_name	[e-mail]
Password	The password set for the user created in Firebolt.	password_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