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

# Dremio Connector

> Connecting TextQL to Dremio

To connect TextQL with your Dremio instance, you will need to gather the following connection details:

* Host and port
* Authentication credentials (personal access token, or username & password)
* Project ID (Dremio Cloud only)

### Creating the Connector in TextQL

Navigate to the [TextQL Connectors Page](/core/datasources/the-connectors-page) and click **Create New Connector**. Select Dremio from the available connectors to open the configuration form.

The form requires the following information:

* **Connector Name:** A descriptive name to identify this Dremio connection in TextQL.
* **Host:** Your Dremio hostname (e.g., `data.dremio.cloud` for Dremio Cloud).
* **Port:** The Arrow Flight SQL port (`443` for Dremio Cloud, `32010` for self-managed).
* **Project ID:** Your Dremio Cloud project ID. Found in the Project overview page or as the `CATALOG` value in your JDBC connection string. Leave blank for self-managed Dremio.
* **Spaces:** Optional comma-separated list of Dremio spaces to scope table discovery (e.g., `my_space, analytics`). If left blank, all user tables are discovered automatically.

### Authentication

TextQL supports two authentication methods for Dremio:

| Method                    | When to use                                     |
| ------------------------- | ----------------------------------------------- |
| **Personal Access Token** | Recommended for Dremio Cloud and production use |
| **Username & Password**   | Self-managed Dremio instances                   |

Select your authentication type and fill in the relevant credentials.

#### Generating a Personal Access Token (Dremio Cloud)

1. Log in to your Dremio Cloud account.
2. Click your profile icon in the top-right corner and select **Account Settings**.
3. Navigate to **Personal Access Tokens**.
4. Click **Generate Token**, give it a name, and copy the token value.

<Warning>
  Personal access tokens are shown only once. Copy and save the token immediately after generating it.
</Warning>

### Dremio Cloud

To connect to [Dremio Cloud](https://www.dremio.com/get-started/):

1. Open the **Project overview** page in Dremio Cloud to find your connection details.
2. Your JDBC connection string contains all the values you need:

```
jdbc:arrow-flight-sql://data.dremio.cloud:443?useEncryption=true&CATALOG=4bc976cb-...
```

| Field          | Value                                                                                   |
| -------------- | --------------------------------------------------------------------------------------- |
| **Host**       | `data.dremio.cloud`                                                                     |
| **Port**       | `443`                                                                                   |
| **SSL**        | Enabled                                                                                 |
| **Project ID** | The `CATALOG` value from the JDBC string (e.g., `4bc976cb-aef0-4463-959f-56404b4076f5`) |
| **Auth**       | Personal Access Token                                                                   |

### Self-Managed Dremio

For self-managed Dremio deployments:

| Field          | Value                                        |
| -------------- | -------------------------------------------- |
| **Host**       | Your Dremio server hostname                  |
| **Port**       | `32010` (default Arrow Flight port)          |
| **SSL**        | Enable if your deployment uses TLS           |
| **Project ID** | Leave blank                                  |
| **Auth**       | Username & Password or Personal Access Token |

### SSL Configuration

SSL is enabled by default and is required for Dremio Cloud. For self-managed deployments, enable SSL if your Dremio instance is configured with TLS.

### Spaces

Dremio organizes data into **spaces** with dot-separated paths (e.g., `dremio_samples.customer360`). When you specify a space like `dremio_samples`, TextQL discovers all tables in that space and any nested sub-spaces (e.g., `dremio_samples.customer360`, `dremio_samples.nyc_citibike`).

If you leave the Spaces field blank, TextQL discovers all user-accessible tables automatically.

### Testing the Connection

After entering your credentials, click **Create** to establish the connection. TextQL will validate your credentials and create the connector. If the connection fails, verify your host, port, SSL setting, and authentication details.

<Note>
  Having trouble connecting? See the [Network Configuration Guide](/core/datasources/databases/network-configuration) for firewall and IP whitelisting setup. Dremio uses the Arrow Flight SQL protocol over gRPC, so ensure your firewall allows outbound connections on the configured port.
</Note>

### Next Steps

Once connected, you can use TextQL to query your Dremio data. The connector supports querying across any space and dataset accessible to your Dremio user. For optimal performance and security:

* Use a dedicated Dremio user or personal access token for TextQL connections
* Specify spaces to limit table discovery scope
* Enable SSL for all production deployments