Last modified: August 11, 2021
Connection Type

ODBC (64-bit)

Driver Configuration Requirements

The host must be a Databricks cluster JDBC/ODBC Server hostname.

For optimal performance, you must enable the Fast SQLPrepare option within the driver Advanced Options to allow Alteryx to retrieve metadata without running a query.

To use Visual Query Builder, select the Get Tables With Query option within the driver Advanced Options.

Type of Support

Read & Write, In-Database

Validated On

Databricks version 2.18, Simba Apache Spark Driver 2.06.16

Alteryx Tools Used to Connect

Standard Workflow Processing

Input Data Tool Icon

Input Data Tool

Output Data Tool Icon

Output Data Tool

In-Database Workflow Processing

Blue icon with database being plugged in.

Connect In-DB Tool

Blue icon with a stream-like object flowing into a database.

Data Stream In Tool

If you have issues with reading or writing Unicode® characters, access the Simba Impala ODBC driver. Under Advanced Options, select the "Use SQL Unicode Types" option.

Read Support

Install and configure the Apache Spark ODBC driver:

  • Spark Server Type: Select the appropriate server type for the version of Apache Spark that you are running. If you are running Apache Spark 1.1 and later, then select Apache SparkThriftServer.
  • Authentication Mechanism: See the installation guide downloaded with the Simba Apache Spark driver to configure this setting based on your setup.

To set up the driver Advanced Options, see the installation guide downloaded with the Simba Apache Spark driver.

Write Support

For both standard and in-database workflows, use the Data Stream In tool to write to Databricks. Write support is via the Databricks Bulk Loader.

In the Manage In-DB Connections > Write Tab

Configure the Write tab

  1. Select Databricks Bulk Loader (Avro) or Databricks Bulk Loader (CSV). To write a table with field names that total more than 4000 characters, use CSV instead of Avro.
  2. Select the Connection String dropdown, and then select New Databricks connection.
  3. Select an existing ODBC data source, or select ODBC Admin to create one.
  4. Specify a user name and password. These fields cannot be blank.
  5. Specify the Databricks URL
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.