What is the best approach to use Delta tables without Unity Catalog enabled?

narvinya
New Contributor

Hello!

I would like to work with delta tables outside of Databricks UI notebook. I know that the best option would be to use databricks-connect but I don’t have Unity Catalog enabled.

What would be the most effective way to do so? I know that via JDBC using spark it is possible to read/write delta tables but is there an option to make some delta operations directly? Is there any other option than doing delta related operation in my local spark session? 

NanthakumarYoga
New Contributor III

Programatically, you can go for DeltaTables.forPath ( not forName which require Unity Catalog )... This works