Guides
Visit our websiteDeveloper Docs
  • Getting Started with DataBrain
    • What is DataBrain?
  • ❄️Onboarding & Configuration
    • 📝Sign-Up
    • ✍️Sign-In
    • ✏️Google Sign In Setup for Self-hosted app
    • 🤔Forgot password? Recover your DataBrain Account
    • 🌟Onboarding
    • 💾Add a Data Source
    • 🧑Configure Tenants
    • 🆕Create a Workspace
    • 🔓Create a Private Workspace
    • 🆕Create a Dashboard
    • 💠Create a Metric
      • Create Custom Columns
      • Create a Metric using Chat Mode
      • Create a Metric using Custom SQL
    • Workspace Settings
      • General Settings
      • Access Control Settings
      • Cache Settings
      • Download Settings
    • 🗄️Explore Data
  • 🛢️Datasources
    • Connecting Data Sources to DataBrain
      • Amazon Redshift
      • Snowflake
      • BigQuery
      • MySQL
      • Postgres
      • MongoDB
      • ElasticSearch
      • DataBricks
      • ClickHouse
      • MSSQL
      • Amazon S3
      • CSV
      • Firebolt
      • SingleStore
      • Athena
    • Allow Access to our IP
    • Add a Data Source
    • Configure Tenants
    • How to Sync a Data Source
    • Edit Tenancy
    • Create a Datamart
    • Semantic Layer
    • Create a Data App
    • Creating a Custom Dataset/View in a Multi-Datasource Environment
  • Workspace
    • Multi Datasource Workspace
  • 🔍DASHBOARDS
    • Edit a Dashboard
    • Share Dashboard
    • Dashboard Settings
    • Create/Modify Dashboard Filter
      • Dashboard Filter - Variable Apply On
      • Add LHS and RHS custom sql support for dashboard filter
    • Customize Layout
    • Adding Elements to Dashboard
    • Import/Export Dashboard
    • Report Scheduler
  • 📉METRIC
    • Edit a Metric
    • Joins , Filter, Sort, Group By
    • Complex Filter
    • Apply Metric Filter
      • Metric Filter - Variable
      • Metric Filter - Custom
    • Switch X axis and Switch Y axis
    • Group By
    • Footnote and Long Description
    • Dynamic Property
    • Archive/Unarchive Metric Card
    • Download Metric Card
    • Download Underlying Data
    • Metric Summary
    • Metric Expression for Single Value Card
    • AI Summary
    • Merge Metrics
    • Section Filters
    • View Unpublished Metrics
  • 📊VISUALIZATIONS - ACTIONS & APPEARANCE
    • Chart Actions
      • Chart Click Action
      • Chart Click Action with Metric
      • Card Click Action
      • Drill Down
      • Cross Dashboard Drill Down
    • Chart Appearance
      • Chart-Specific Appearance Options
  • 🛢️PREVIEW OF DASHBOARDS
    • Email Settings for Scheduled Reports
    • Scheduled Reports for End User
  • 🔍FILTERS
    • Dashboard Filter
    • Metric Filter
    • App filter
  • 💡Features
    • Python Editor Console
    • Custom SQL Console
    • Custom SQL Query Guidelines
  • 🏢Integrating Plugin
    • ✳️Get an auth token
    • 🙏Get a guest token
  • 🛃THEMEING & CUSTOMIZATION
    • 🎨Creating a theme
    • 🖼️View the theme in action
    • ⚙️Reset a saved theme
  • 📊Metric Component (upto version v0.11.15)
    • ✨Quick start
  • 🕸️Web Components
    • ✨Quick start
    • ⚛️Framework Specific Guide
  • 🚀Product Changelog
  • 🤳Self Hosted Changelog
Powered by GitBook
On this page
  • Requirements:
  • Setup Guide:
  • Locating the Configuration Details in Firebolt:
  1. Datasources
  2. Connecting Data Sources to DataBrain

Firebolt

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_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.

  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.

PreviousCSVNextSingleStore

Last updated 4 months ago

🛢️