JDBC
Dremio provides a JDBC driver that allows client applications to connect to Dremio Cloud.
You can download the JDBC driver from here. The driver does not require installation.
Supported Authentication Methods
Connection strings can authenticate to Dremio Cloud by using a personal access token (PAT) obtained from Dremio Cloud or a JSON Web Token (JWT). You can use a PAT with or without OAuth enabled. To use a JWT, you must have OAuth enabled.
Construct a Connection String for JDBC Applications
note:
If you are using the JDBC driver to connect to Dremio Cloud from a supported client application, refer to the documentation for creating connections from that application.
note:
If you want to start with the base JDBC connection string for your Dremio Cloud project:
In Dremio Cloud, hover over the Settings icon and select Project Settings.
On the left side of the page, click General Information.
Copy the connection string that is in the JDBC Connection field.
To construct a connection string:
Set the subprotocol to
jdbc:dremio:
.Set the property
direct
equal tosql.dremio.cloud:443
.Add one of these types of authentication credentials for connecting from your JDBC client application to Dremio Cloud:
Use a personal access token (PAT) in either of the following ways:
Set
Use PAT as password when client app does not support OAuthusername
to$token
and use the PAT as the password when the client application does not support OAuth:jdbc:dremio:direct=sql.dremio.cloud:443;username=$token;password=<personal-access-token>;
Set
Use PAT as passwordtoken_type
topersonal_access_token
, use the PAT as the password, and setusername
to null when the client application supports OAuth:jdbc:dremio:direct=sql.dremio.cloud:443;token_type=personal_access_token;password=<personal-access-token>;username=;
Use a JSON Web Token (JWT). You can use a JWT when the tool used with the JDBC driver supports OAuth:
Use a JWTjdbc:dremio:direct=sql.dremio.cloud:443;token_type=jwt;password=<jwt>;username=;
Set the property
Set ssl to truessl
equal totrue
.jdbc:dremio:direct=sql.dremio.cloud:443;token_type=personal_access_token;password=<personal-access-token>;username=;ssl=true;
Add the ID of the project that you are connecting to.
Set the project IDjdbc:dremio:direct=sql.dremio.cloud:443;token_type=personal_access_token;password=<personal-access-token>;username=;ssl=true;project_id=<project-id>;
(Optional) Route queries to a particular engine in your project, set the property
Set engine nameengine
to the name of an engine.jdbc:dremio:direct=sql.dremio.cloud:443;token_type=personal_access_token;password=<personal-access-token>;username=;ssl=true;engine=<engine-name>;
Encryption Properties
SSL JDBC Connection Parameter | Type | Description | Default Value | Required |
---|---|---|---|---|
disableCertificateVerification | boolean | Controls whether the driver verifies the host certificate against the trust store.
| false | No |
disableHostVerification | boolean | Forces the driver to verify that the host in the certificate is the host being connected to.
| false | No |
ssl | boolean | Forces the client to use an SSL encrypted connection to communicate with the Dremio server.
Note: | false | Yes |
trustStoreType | string | The trustStore type. Accepted value is: JKS PKCS12 The following property only applies to Windows.
| None | No |
trustStore | string | Path to the truststore. If this parameter is not specified, it defaults to Java truststore ( $JAVA_HOME/lib/security/cacerts ) and the trustStorePassword parameter is ignored. | $JAVA_HOME/lib/security/cacerts | No |
useSystemTrustStore | boolean | Bypasses trustStoreType and automatically picks the correct truststore based on the operating system:
| true | No |
trustStorePassword | string | Password to the truststore. | None | No |