Author Topic: connection via ODBC to Databricks deltalake  (Read 8443 times)

soad1981

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
connection via ODBC to Databricks deltalake
« on: March 26, 2024, 08:37:51 pm »
Hi,
our source database is Databricks datalake that supports ODBC connection and it works fine (we can connect from outside of databricks). Now we have EA v 15/16 and we would like to connect to databricks also from EA and to read data some metadata from Databricks tables. Is it supported by scripting in EA? Can you provide a simple snippet that opens connection via ODBC and reads content of specific table?
Thanks
« Last Edit: March 26, 2024, 11:09:42 pm by soad1981 »

ea0522

  • EA User
  • **
  • Posts: 80
  • Karma: +3/-0
    • View Profile
Re: connection via ODBC to Databricks deltalake
« Reply #1 on: April 30, 2024, 08:07:07 pm »
Hai,
Is there an answer to this question?
We would also like to connect to Databricks from our EA instance running in the cloud.

We are particularly interested in modelling the Databricks warehouse and define relations to data objects as used by other applications.
That way we think we can use the modelling capabilities of EA together with the DWH capabilities of Databricks.
The Database Builder seems to be a fine option to use for this.

Another way to connect to DataBricks is using the Delta Sharing option supported by Databricks. Is this option also supported by EA?

Thanks.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8001
  • Karma: +114/-20
    • View Profile
Re: connection via ODBC to Databricks deltalake
« Reply #2 on: May 01, 2024, 08:18:01 am »
Enterprise Architect doesn't know how Databricks stores its metadata, so will not be able to import it into your model.