Learn how to connect to Databricks from Exasol and load data.
Download the Databricks JDBC driver from JDBC Drivers Archive | Databricks.
Create a configuration file called settings.cfg with the following settings:
DRIVERNAME=DATABRICKS
PREFIX=jdbc:databricks:
NOSECURITY=YES
FETCHSIZE=100000
INSERTSIZE=-1
The settings.cfg file must end with an empty line (line break followed by zero characters).
To learn how to upload the driver and the configuration file to an Exasol as-application deployment, see Add JDBC driver.
To learn how to upload the driver and the configuration file to Exasol SaaS, see Add JDBC driver (SaaS).
For information about how to create a connection string, see Create a Named Connection in our GitHub repository.
Use IMPORT to load data from a table or SQL statement using the connection that you created.