Databricks connector

[Rykie]

Hi Team

How would I go about connecting to Databricks?
I see there are connectors for both tableau and power bi.

Thanks

[dgudkov]

1. Start with installing the ODBC driver (64-bit): https://www.databricks.com/spark/odbc-drivers-download

2. Create an ODBC connection (64-bit) for Databricks in Windows (use System DSN).

3. In EasyMorph, create an “ODBC” connector, select the ODBC connection created in p.2 above, and use the “Other SQL” dialect. For this dialect, only custom SQL queries are possible. Visual queries don’t support Databricks at this point.

[Rykie]

Thanks, Dmitry

[dgudkov]

See also:

We've added support for Databricks (experimental)

[image] As an experiment, we've added support for the SQL dialect of Databricks in the most recent build of EasyMorph (updated today). With it, it should be possible to import data from Databricks using the Visual Query editor. A few other actions are supported too: Database command Select matching database rows Delete database rows (using a query) Actions that do not support Databricks currently: Export to database Bulk export to database Update database rows Delete matching database rows …

[Rykie]

Thank you Dmitry