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

# Dremio

> Connect Dremio to Paradime to run dbt™ against your Dremio Cloud or Software project from the Code IDE, Bolt, and Agent environments.

[Dremio](https://www.dremio.com/) is a lakehouse platform that enables high-performance SQL queries directly on data lake storage. Paradime supports connections to both **Dremio Cloud** and **Dremio Software**. Connect it to Paradime to run dbt™ from the Code IDE, deploy production jobs with Bolt, and let the DinoAI background agent work against your lakehouse.

<Warning>
  **IP restrictions**

  Allow traffic from one of the Paradime IPs in your firewall, depending on the data location selected.

  See also: [Paradime IP addresses](/developers/ip-restrictions).
</Warning>

<Note>
  **Available in:** Code IDE, Bolt, and Agent environments.
</Note>

## Prerequisites

Dremio offers different authentication methods for Dremio Cloud and Dremio Software deployments. Choose the appropriate method and ensure you complete the respective prerequisites.

**Dremio Cloud**

* Access to a Dremio Cloud workspace
* Access to the ID of the Sonar project you want to use. See [Obtaining the ID of a Project](https://docs.dremio.com/cloud/cloud-entities/projects/#obtaining-the-id-of-a-project).
* A valid personal access token (PAT) for authenticating to Dremio Cloud. See [Creating a Token](https://docs.dremio.com/cloud/security/authentication/personal-access-token/#creating-a-token).
* Python 3.9 or later installed on the system running dbt™.

**Dremio Software**

* Dremio Software version 22.0 or later
* Python 3.9 or later installed
* Required support keys enabled in your Dremio cluster (see [Support Keys](https://docs.dremio.com/software/advanced-administration/support-settings/#support-keys) for details):
  * `dremio.iceberg.enabled`
  * `dremio.iceberg.ctas.enabled`
  * `dremio.execution.support_unlimited_splits`

## Add a connection

1. Click **Settings** in the top menu bar of the Paradime interface to access **Workspace Settings**.
2. In the left sidebar, click **Environments**.
3. Click **Add New** next to the section for the environment you are configuring:
   * **Code IDE** for the Code IDE connection
   * **Bolt** for the Bolt connection
   * **Agent** for the Agent connection
4. Select **Dremio**.
5. In the **Profile Configuration** field, add the parameters for your authentication method. See [Profile fields reference](#profile-fields-reference) below for additional context and configurations.
6. Provide a dbt™ **Profile Name** (this should match the profile name set in your `dbt_project.yml`).
7. In the **Target** field, enter the target for the environment you are configuring: `dev` for Code IDE, `prod` for Bolt, or `dinoai` for the Agent.
8. The **Threads** value is pre-configured to 1, but you can adjust this to specify how many parallel operations your dbt™ project can run.

<Info>
  After adding the configuration, ensure it is properly formatted using a YAML formatter like [YAML Formatter](https://jsonformatter.org/yaml-formatter).
</Info>

## Profile configuration

<Tabs>
  <Tab title="Dremio Cloud">
    ```yaml theme={"system"}
    cloud_host: https://api.dremio.cloud      # US Control Plane
    cloud_project_id: 12345678                # Sonar project ID
    object_storage_source: my_storage         # Filesystem name for objects
    object_storage_path: data/analytics       # Filesystem path for objects
    dremio_space: analytics_space             # Space for view creation
    dremio_space_folder: reports.daily        # Space folder path
    pat: drm_cl_1a2b3c4d5e6f                  # Personal access token
    use_ssl: true                             # Required for Cloud
    user: analyst@company.com                 # Your email
    ```
  </Tab>

  <Tab title="Dremio Software (Username/Password)">
    ```yaml theme={"system"}
    software_host: dremio.company.com         # Hostname or IP address
    port: 9047                                # Default: 9047
    user: dremio_analyst                      # Username
    password: your_secure_password            # Password
    object_storage_source: company_storage    # Filesystem name for objects
    object_storage_path: data/transforms      # Filesystem path for objects
    dremio_space: dev_space                   # Space for view creation
    dremio_space_folder: testing.models       # Space folder path
    threads: 4                                # Number of threads
    use_ssl: true                             # Enable SSL
    ```
  </Tab>

  <Tab title="Dremio Software (Personal Access Token)">
    ```yaml theme={"system"}
    pat: drm_sw_1a2b3c4d5e6f                  # Token for authentication
    port: 9047                                # Port for Dremio Software cluster API endpoints
    software_host: dremio.internal.net        # Hostname or IP address of the Dremio coordinator node
    object_storage_source: analytics_source   # Name of filesystem for creating tables and views
    object_storage_path: production/models    # Path in filesystem for objects
    dremio_space: prod_space                  # Dremio space for creating views
    dremio_space_folder: models.validated     # Folder path in Dremio space
    threads: 4                                # Number of threads for dbt™ project execution
    use_ssl: true                             # Enable/disable SSL connection
    user: dremio_prod                         # Username for authentication
    ```
  </Tab>
</Tabs>

## Profile fields reference

<Tabs>
  <Tab title="Common Fields">
    | Field                   | Description                                      | Default Value | Required |
    | ----------------------- | ------------------------------------------------ | ------------- | -------- |
    | object\_storage\_source | Source name for storing tables and other objects | `$scratch`    | ❌        |
    | object\_storage\_path   | Path within storage for object creation          | `no_schema`   | ❌        |
    | dremio\_space           | Space designation for view creation              | `@username`   | ❌        |
    | dremio\_space\_folder   | Folder structure within Dremio space             | `no_schema`   | ❌        |
  </Tab>

  <Tab title="Dremio Cloud">
    | Field              | Description                        | Default Value              | Required |
    | ------------------ | ---------------------------------- | -------------------------- | -------- |
    | cloud\_host        | Dremio Cloud API endpoint          | `https://api.dremio.cloud` | ✅        |
    | cloud\_project\_id | Project identifier in Dremio Cloud | None                       | ✅        |
    | user               | Email address for authentication   | None                       | ✅        |
    | pat                | Authentication token               | None                       | ✅        |
    | use\_ssl           | SSL connection enablement          | `true`                     | ✅        |
  </Tab>

  <Tab title="Dremio Software">
    | Field          | Description                                  | Default Value | Required |
    | -------------- | -------------------------------------------- | ------------- | -------- |
    | software\_host | Host address of Dremio instance              | None          | ✅        |
    | port           | Connection port number                       | `9047`        | ✅        |
    | user           | Authentication username                      | None          | ✅        |
    | password       | User password (if not using PAT)             | None          | Yes\*    |
    | pat            | Authentication token (if not using password) | None          | Yes\*    |
    | use\_ssl       | SSL connection enablement                    | `false`       | ✅        |

    \*Either `password` or `pat` must be provided, but not both.
  </Tab>
</Tabs>

## Related

<CardGroup cols={2}>
  <Card title="Optional connection attributes" href="/guides/data-warehouse-essentials/optional-connection-attributes" icon="gear" horizontal>
    Set additional `profiles.yml` attributes for this connection.
  </Card>
</CardGroup>


## Related topics

- [Bolt environment](/products/settings/connections/scheduler-environment/index.md)
- [Agent environment](/products/settings/connections/dinoai-background-agent-environment/index.md)
- [Code IDE environment](/products/settings/connections/development-environment/index.md)