Skip to main content

Has anyone successfully queried a data set that resides in a Azure Databricks from within AA? If so, what are the steps to get this setup?

@JMarino Looking at this Azure Databricks architecture overview…

https://www.databricks.com/wp-content/uploads/2021/06/AzureDatabricksReferenceArchitecture.pdf

...it almost looks like Databricks is exposed as a SQL connector. (upper right corner) If so, get the connection string for your database instance and you should be able to use regular SQL queries. In theory.  😉


If IT allows driver installation → ODBC/JDBC is simpler for bot developers, since you just run SQL queries directly inside AA.

If driver install is restricted → REST API works with only Control Room + Bot Runner, no external dependencies.


Reply