Firebolt
Requirements:
Active Firebolt account and setup.
Ensure the necessary service account, role, and user permissions are configured for connectivity.
Setup Guide:
Create a Service Account:
Log in to your Firebolt account.
Navigate to the Configure tab and select the Service Accounts section.
Click CREATE to establish a new service account.
Assign Roles:
Go to the Govern tab and create a new role.
Assign the role the permissions to use any database and use any engine.
Create a User:
Create a user within Firebolt and assign the newly created role to the user.
Retrieve Service Account Keys:
Return to the Service Accounts section.
Copy the Client_ID and Client_Secret for the created service account.
Fill Up Connection Info:
Provide the necessary information to connect to your Firebolt account in Databrain:
Integration Name: Pick a name to help you identify this source in Databrain.
Firebolt Datasource: Select Firebolt as your data source.
Client_ID: Copy and paste the Client_D retrieved from the service account.
Client Secret: Copy and paste the Client_ID retrieved from the service account.
Account Name: Provide the account name for your Firebolt setup.
Database Name: Enter the name of the database.
Engine Name: Specify the name of the engine (e.g., my_engine).
Schema: Provide the schema name to be used.
Test the Connection:
Use the Add a Data Source UI in Databrain to verify that the connection is successful.
Locating the Configuration Details in Firebolt:
Service Account Client_Secret & Client_ID:
These are found under the Service Accounts tab in the Firebolt Configure section.
Role Permissions:
Verify roles and permissions in the Govern tab. Ensure the role has access to all required databases and engines.
Database and Engine Details:
Review your Firebolt account dashboard to confirm database and engine configurations.
Notes:
Ensure you are using the correct Client_Secret and Client_ID for your service account.
Maintain the security of your credentials to prevent unauthorized access.
Last updated