Note: Mage’s implementation of the Dremio source does not allow the query
connection parameter.
Key | Description | Sample Value |
---|---|---|
username | Username of the Dremio account used for authentication. | ABC123 |
schema | Dremio source table schema. | ABC123 |
source_backend | SQL source backend used to query data from Dremio (see section below). | postgresql |
password | Password for the Dremio account. (Required if no token is provided.) | ABC123 |
token | Personal Access Token or OAuth2 Token. (Required if no password is provided.) | ABC123 |
Key | Description | Sample Value |
---|---|---|
hostname | Hostname or IP address of the coordinator node (defaults to localhost ). | localhost |
port | Dremio’s Arrow Flight server port (defaults to 32010 ). | 32010 |
tls | Enables TLS encryption for the connection. | false |
disable_certificate_verification | Disables TLS server certificate verification. | true |
path_to_certs | Path to trusted certificates for TLS connections. | /path/to/certs |
session_properties | Key-value pairs for session properties. | { "key": "value" } |
postgresql
mysql
mssql
Note:
OracleDB and Snowflake do not require asource_backend
.
Internal tables created by S3 or other object storage also do not require a backend source.