Skip to main content

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.

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 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:
MethodWhen to use
Personal Access TokenRecommended for Dremio Cloud and production use
Username & PasswordSelf-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.
Personal access tokens are shown only once. Copy and save the token immediately after generating it.

​
Dremio Cloud

To connect to Dremio Cloud:
  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-...
FieldValue
Hostdata.dremio.cloud
Port443
SSLEnabled
Project IDThe CATALOG value from the JDBC string (e.g., 4bc976cb-aef0-4463-959f-56404b4076f5)
AuthPersonal Access Token

​
Self-Managed Dremio

For self-managed Dremio deployments:
FieldValue
HostYour Dremio server hostname
Port32010 (default Arrow Flight port)
SSLEnable if your deployment uses TLS
Project IDLeave blank
AuthUsername & 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.
Having trouble connecting? See the Network Configuration Guide 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.

​
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