How to list all Delta tables in a Database?

[brickster_2018]

I wanted to get a list of all the Delta tables in a Database. What is the easiest way of getting it.

[brickster_2018 · Accepted solution]

Below code, the snippet can be used to list down the tables in a database

val db = "database_name"
 
spark.sessionState.catalog.listTables(db).map(table=>spark.sessionState.catalog.externalCatalog.getTable(table.database.get,table.table)).filter(x=>x.provider.toString().toLowerCase.contains("delta"))