Troubleshooting Databricks JDBC Errors with Liquibase

Incomplete JDBC URL: [Databricks][DatabricksJDBCDriver](500540)

Condition

You've received this error message:

Unexpected error running Liquibase: Error executing SQL SELECT MD5SUM FROM main.default.DATABASECHANGELOG WHERE MD5SUM IS NOT NULL: [Databricks][JDBCDriver](500540) Error caught in BackgroundFetcher. Foreground thread ID: 1. Background thread ID: 20. Error caught: Could not initialize class com.databricks.client.jdbc42.internal.apache.arrow.memory.util.MemoryUtil.

Cause

If you use v1.1.3 of the Liquibase Open Source Databricks extension, you may receive this error running Liquibase

Remedy

To resolve this, append ;UserAgentEntry=Liquibase;EnableArrow=0; to your JDBC URL. For example, using username/password authentication:

jdbc:databricks://<host>:<port>/<schema>;AuthMech=3;httpPath=/sql/1.0/warehouses/<warehouse>;ConnCatalog=<catalog>;UserAgentEntry=Liquibase;EnableArrow=0;

Connection could not be created to <my _URL> with driver: [Databricks][JDBCDriver](500174)

Condition

You've received this error message:

ERROR: Exception Primary Reason: Connection could not be created to <MY_URL> with driver com.databricks.client.jdbc.Driver. [Databricks][JDBCDriver](500174) Connection property UID has invalid value of <your-email-address>. Valid values are: token.

Cause

If you're using Databricks JDBC driver 2.7.1 or higher, it's possible that token authentication support for your Databricks extension has changed.

Remedy

Verify which version of the Databricks driver you are using. If you're using Databricks Extension driver 2.7.1 or higher, specify username: token and password:<PAT> or specify UID=token;PWD=<PAT> in your URL to connect to Databricks.

Missing SSL certificate: [Databricks][JDBCDriver](500593)

Condition

You've received this error message:

Connection could not be created to jdbc:databricks://...; with driver com.databricks.client.jdbc.Driver. [Databricks][JDBCDriver](500593) Communication link failure. Failed to connect to server. Reason: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.

Cause

You are receiving this error message because the required SSL certificate is not available in Java versions before 1.8.

Remedy

To resolve this, upgrade Java to version 1.8 or higher.