Integrate Paradime with Firebolt

Paradime logo

Paradime is a unified platform for data science and analytics that streamlines workflows for data teams. It offers a collaborative workspace where data scientists and analysts can explore, analyze, and visualize data across multiple tools and environments. Paradime integrates with tools including Jupyter notebooks, SQL editors, and Tableau. You can use the Paradime connector to link the Paradime platform directly to Firebolt’s cloud data warehouse. This connection allows you to run SQL queries, visualize results, and collaborate with team members all within the Paradime workspace.

This guide shows you how to connect Paradime to Firebolt using the Paradime user interface (UI). You must have a Firebolt account, a Firebolt service account, access to a Firebolt database, and an account with Paradime. These instructions build on the steps in Paradime’s Getting Started with your Paradime Workspace guide, providing Firebolt-specific configuration details.

Topics:

Prerequisites

Before you can connect Paradime to Firebolt, you must have the following:

  1. Firebolt Account: Ensure that you have access to an active Firebolt account. If you don’t have access, you can sign up for an account. For more information about how to register with Firebolt, see Get started with Firebolt.
  2. Service Account: You must have access to an active Firebolt service account, which facilitates programmatic access to Firebolt.
  3. Firebolt Database: You must have access to a Firebolt database. If you don’t have access, you can create a database.
  4. Paradime Account: You must have access to an active Paradime account. If you don’t have access, you can sign up for one.

Create a Paradime workspace

Create a Paradime workspace to connect to Firebolt as follows:

  1. In the Paradime UI, navigate to your account profile in the upper-right corner of the page.
  2. Select Profile Settings.
  3. In the Workspaces window, select the New Workspace button.
  4. Enter a descriptive name for your workspace in the text box under Name.
  5. Select Create Workspace.
  6. Select Continue.
  7. Select the most recent dbt-core version from the drop-down list.
  8. Select Continue.
  9. Select a dbt repository. You can either use an existing data build tool (dbt) repository or fork Firebolt’s sample Jaffle Shop repository from GitHub. Paradime supports the following providers: Azure DevOps, Bitbucket, GitHub, and GitLab.
  10. Select Next.
  11. Enter the SSH URI for your repository in the text box under Repository URI. Copy the key that appears under the Deploy Key.
  12. Add the new deploy key to your dbt repository and allow write access. The following are resources for providers supported by Paradime:
  13. Select Continue.
  14. If your repository connected successfully, select Continue.
  15. Select Firebolt from the choices under Warehouse connection.
  16. Under Connection Settings, enter the following:
    1. Profile Name – The name of a connection profile that is defined in dbt_project.yaml by a workspace administrator, and contains configurations including credentials to connect to a data warehouse. For more information, see Paradime’s Setting up your profile guide.
    2. Target – Specify the target variable that contains information about your data warehouse connection including its name, schema, and type.
    3. Host Name – Enter api.app.firebolt.io.
  17. Under Development Credentials, enter the following:
    1. Client Id – Enter your Firebolt service account ID. Do not enter your Firebolt login email.
    2. Client Secret – Enter your Firebolt service account secret. Do not enter your Firebolt password.
    3. Account Name – Enter your Firebolt account name.
    4. Engine Name – Enter the name of the engine where you want to run your queries.
    5. Database Name – Specify the Firebolt database name.
    6. Select Test Connection to connect to Firebolt and authenticate.
    7. Select Next.

For more information about the previous connection settings, see Paradime’s documentation to add a development connection.

Create a schedule (Optional)

Paradime offers a scheduling feature using a Bolt user interface to automatically run dbt commands on a specified interval or event. You can use Bolt to run a dbt job in a production environment, in a test environment prior to merging changes to production, or in an environment that runs jobs only on changed models.

To create a new schedule:

  1. Login to your Paradime account.
  2. Select Bolt from the left navigation bar.
  3. Select + New Schedule.
  4. Select a pre-configured template from a list of popular Bolt templates or create a new schedule using a blank template. For information about how to configure settings in a Paradime schedule, see Schedule Fields.
  5. Select Publish.
  6. To view the new schedule, select Bolt from the left navigation pane.

Additional resources