Utils Driver
Specifies the driver the generated Databricks utilities use for connectivity back to the BimlFlex catalog database.
Options: ODBC, JDBC
| Option | Behavior |
|---|---|
ODBC (default) | The build generates the bfx_init_odbc.sh cluster init script and an ODBC-based bfxutils.py; clusters install the ODBC driver through the init script |
JDBC | The build generates a JDBC-based bfxutils.py and no init script; the generated job tasks instead install the Python packages python-tds, pyOpenSSL and certifi, as task libraries on job clusters, or through a bfx_jdbc environment for serverless tasks |
When to Change This Setting
Keep ODBC for classic job clusters, where the init script installs the driver. Select JDBC when running on serverless compute, where cluster init scripts are not available and the package-based JDBC path is the compatible option.
Related Settings
| Setting | Interaction |
|---|---|
| Job Cluster | Serverless compute pairs with the JDBC driver |
Notes
- This setting is part of the Databricks settings category.
- The default value for this setting is
ODBC.