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

# Dremio

> [!NOTE]
>
> **INFO**
>
> Column-level Lineage is not currently supported for Dremio.

> [!NOTE]
>
> **INFO**
>
> Schemas for tables in external data sources need to be specified with quotes e.g., "Postgres prod.analytics.sales".

**Steps to complete:**

1. [Configure user in Dremio](https://docs.datafold.com/classic/integrations/databases/dremio.md#configure-user-in-dremio)
2. [Create schema for Datafold](https://docs.datafold.com/classic/integrations/databases/dremio.md#create-schema-for-datafold)
3. [Configure your data connection in Datafold](https://docs.datafold.com/classic/integrations/databases/dremio.md#configure-in-datafold)

## Configure user in Dremio

To connect to Dremio, create a user with read-only access to all data sources you wish to diff and generate an access token.

Temporary tables will be created in the `$scratch` schema that doesn't require special permissions.

## Create schema for Datafold

Datafold utilizes a temporary dataset to materialize scratch work and keep data processing in your warehouse.

## Configure in Datafold

| Field Name | Description |
| - | - |
| Connection name | A name given to the data connection within Datafold. |
| Host | The hostname for your Dremio instance (data.dremio.cloud for Dremio SaaS). |
| Port | Dremio endpoint port; default value is 443. |
| Encryption | Should be checked for Dremio Cloud, possibly unchecked for local deployments. |
| User ID | User ID as created in Dremio, typically an email address. |
| Project ID | Dremio Project UID. If left blank, the default project will be used. |
| Token | Access token generated in Dremio. |
| Password | Alternatively, provide a password. |
| Schema for temporary views | A Dremio space for temporary views. |
| Schema for temporary tables | \$scratch should suit most applications, or use "\<Datasource>.\<schema>" (with quotes) if you wish to create temporary tables in an external data source. |

Click **Create**. Your data connection is now ready!


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.