1

I am trying to read data from databricks delta lake via. apache superset. I can connect to delta lake with a JDBC connection string supplied by the cluster but superset seems to require a sql alchemy string so I'm not sure what I need to do to get this working. Thank you, anything helps

superset database setup

Henry Dang
  • 25
  • 1
  • 3

2 Answers2

1

Have you tried this? https://flynn.gg/blog/databricks-sqlalchemy-dialect/

Thanks to contributions by Evan Thomas, the Python databricks-dbapi package now supports using Databricks as a SQL dialect within SQLAlchemy. This is particularly useful for hooking up Databricks to a dashboard frontend application like Apache Superset. It provides compatibility with both standard Databricks and Azure Databricks.

Alberto De Vega
  • 68
  • 9
0

Just use pyhive and you should be ready to connect to databricks thrift JDBC server.

Qiuzhuang Lian
  • 1
  • 1