> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cube.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Firebolt

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

<Warning>
  The driver for Firebolt is supported by its vendor. Please report any issues to
  their [Help Center][firebolt-help].
</Warning>

## Prerequisites

* The id/secret (client id/client secret) for your [Firebolt][firebolt] [service account][firebolt-service-accounts]

## Setup

### Manual

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

```dotenv theme={"dark"}
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`](/reference/configuration/environment-variables#cubejs_db_name)                             | The name of the database to connect to                                             | A valid database name                                                   |     ✅    |
| [`CUBEJS_DB_USER`](/reference/configuration/environment-variables#cubejs_db_user)                             | A service account ID for accessing Firebolt programmatically                       | A valid service id                                                      |     ✅    |
| [`CUBEJS_DB_PASS`](/reference/configuration/environment-variables#cubejs_db_pass)                             | A service account secret for accessing Firebolt programmatically                   | A valid service secret                                                  |     ✅    |
| [`CUBEJS_FIREBOLT_ACCOUNT`](/reference/configuration/environment-variables#cubejs_firebolt_account)           | Account name                                                                       | An account name                                                         |     ✅    |
| [`CUBEJS_FIREBOLT_ENGINE_NAME`](/reference/configuration/environment-variables#cubejs_firebolt_engine_name)   | Engine name to connect to                                                          | A valid engine name                                                     |     ✅    |
| [`CUBEJS_FIREBOLT_API_ENDPOINT`](/reference/configuration/environment-variables#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`](/reference/configuration/environment-variables#cubejs_db_max_pool)                     | The maximum number of concurrent database connections to pool. Default is `20`     | A valid number                                                          |     ❌    |
| [`CUBEJS_CONCURRENCY`](/reference/configuration/environment-variables#cubejs_concurrency)                     | The number of [concurrent queries][ref-data-source-concurrency] to the data source | A valid number                                                          |     ❌    |

[ref-data-source-concurrency]: /admin/connect-to-data/concurrency#data-source-concurrency

[firebolt]: https://www.firebolt.io/

[firebolt-help]: https://help.firebolt.io/

[firebolt-service-accounts]: https://docs.firebolt.io/godocs/Guides/managing-your-organization/service-accounts.html
