Type of Support: Read & Write; In-Database
Validated On: Spark 1.2.0; Simba Spark Driver
Connection Type: ODBC (32- and 64-bit)
Driver Details: The ODBC driver can be downloaded here.

In-Database processing requires 64-bit database drivers.

Driver Configuration Requirements: 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.


Alteryx tools used to connect:

Additional Details

To connect to Spark, you must have Spark SQL enabled. Not all Hadoop distributions support Spark. If you are unable to connect to Spark, contact your Hadoop vendor for instructions on how to set up the Spark server correctly.

Read Support

Install and configure the Spark ODBC driver:

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

Write Support

To write a table with field names that total more than 4000 characters, use CSV instead of Avro.