Databricks Delta Connector

Back Next

JDBC URL parameters

You can utilize the additional JDBC URL parameters field in the Databricks Delta connection to customize and set any additional parameters required to connect to Databricks Delta.

You can configure the following properties as additional JDBC URL parameters in the Databricks Delta connection:

To pass the unity catalog information to Databricks, specify the catalog name after the SQL warehouse cluster ID in the following format:

jdbc:spark://<Databricks Host>:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/endpoints/<SQL endpoint cluster ID>;ConnCatalog=<catalog_name>;

To connect to Databricks using the proxy server, enter the following parameters:

jdbc: spark://<Databricks Host>:443/default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/219fe3013963cdce;UseProxy=<Proxy=true>;ProxyHost=<proxy host IPaddress>;ProxyPort=<proxy server port number>;ProxyAuth=<Auth_true>;

If you specify the database name in the JDBC URL, it is not considered. Specify the database name in the Database Name connection property.

Rename Saved Search

Table of Contents

Databricks Delta Connector

Databricks Delta Connector

JDBC URL parameters

JDBC URL parameters