Requirements:

  • Active Firebolt account and setup.
  • Ensure the necessary service account, role, and user permissions are configured for connectivity.

Setup Guide:

  1. 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.
  2. 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.
  3. Create a User:
    • Create a user within Firebolt and assign the newly created role to the user.
  4. Retrieve Service Account Keys:
    • Return to the Service Accounts section.
    • Copy the Client_ID and Client_Secret for the created service account.
  5. 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_ID 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.
  6. 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.