Firebolt - Cube Documentation

The driver for Firebolt is supported by its vendor. Please report any issues to their Help Center.

Prerequisites

The id/secret (client id/client secret) for your Firebolt service account

Setup

Manual

Add the following to a .env file in your Cube project:

CUBEJS_DB_NAME=firebolt_database
CUBEJS_DB_USER=aaaa-bbb-3244-wwssd
CUBEJS_DB_PASS=**********
CUBEJS_FIREBOLT_ACCOUNT=cube
CUBEJS_FIREBOLT_ENGINE_NAME=engine_name

Environment Variables

Environment Variable	Description	Possible Values	Required
`CUBEJS_DB_NAME`	The name of the database to connect to	A valid database name	✅
`CUBEJS_DB_USER`	A service account ID for accessing Firebolt programmatically	A valid service id	✅
`CUBEJS_DB_PASS`	A service account secret for accessing Firebolt programmatically	A valid service secret	✅
`CUBEJS_FIREBOLT_ACCOUNT`	Account name	An account name	✅
`CUBEJS_FIREBOLT_ENGINE_NAME`	Engine name to connect to	A valid engine name	✅
`CUBEJS_FIREBOLT_API_ENDPOINT`	Firebolt API endpoint. Used for authentication	`api.dev.firebolt.io`, `api.staging.firebolt.io`, `api.app.firebolt.io`	-
`CUBEJS_DB_MAX_POOL`	The maximum number of concurrent database connections to pool. Default is `20`	A valid number	❌
`CUBEJS_CONCURRENCY`	The number of concurrent queries to the data source	A valid number	❌