Databrain home page
Search...
⌘K
Embed Playground
Start Building
Start Building
Search...
Navigation
Connecting Data Sources to Databrain
Firebolt
Docs
Guides
API Reference
Changelog
About us
Blog
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 Worskpace
Create a Dashboard
Create a Metric
Workspace Settings
Explore Data
Datasources
Connecting Data Sources to Databrain
Overview
Amazon Redshift
Snowflake
BigQuery
MySQL
Postgres
MongoDB
ElasticSearch
DataBricks
ClickHouse
MSSQL
Amazon S3
CSV
Firebolt
SingleStore
Athena
OpenSearch
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
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
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 Appearance
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
METRIC COMPONENT (UPTO VERSION V0.11.15)
Quick start
Web Components
Quick start
Framework Specific Guide
On this page
Requirements:
Setup Guide:
Locating the Configuration Details in Firebolt:
Notes:
Connecting Data Sources to Databrain
Firebolt
Copy page
Copy page
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_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.
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.
CSV
SingleStore
Assistant
Responses are generated using AI and may contain mistakes.