https://community.databricks.com/t5/data-engineering/how-to-list-all-delta-tables-in-a-database/m-p/21349#M14541 <P>Below code, the snippet can be used to list down the tables in a database</P><P></P><PRE><CODE>val db = "database_name" &nbsp; spark.sessionState.catalog.listTables(db).map(table=&gt;spark.sessionState.catalog.externalCatalog.getTable(table.database.get,table.table)).filter(x=&gt;x.provider.toString().toLowerCase.contains("delta"))</CODE></PRE><P></P> Wed, 23 Jun 2021 19:22:17 GMT brickster_2018 2021-06-23T19:22:17Z https://community.databricks.com/t5/data-engineering/how-to-list-all-delta-tables-in-a-database/m-p/21348#M14540 <P>I wanted to get a list of all the Delta tables in a Database. What is the easiest way of getting it. </P> Wed, 23 Jun 2021 19:19:32 GMT https://community.databricks.com/t5/data-engineering/how-to-list-all-delta-tables-in-a-database/m-p/21348#M14540 brickster_2018 2021-06-23T19:19:32Z https://community.databricks.com/t5/data-engineering/how-to-list-all-delta-tables-in-a-database/m-p/21349#M14541 <P>Below code, the snippet can be used to list down the tables in a database</P><P></P><PRE><CODE>val db = "database_name" &nbsp; spark.sessionState.catalog.listTables(db).map(table=&gt;spark.sessionState.catalog.externalCatalog.getTable(table.database.get,table.table)).filter(x=&gt;x.provider.toString().toLowerCase.contains("delta"))</CODE></PRE><P></P> Wed, 23 Jun 2021 19:22:17 GMT https://community.databricks.com/t5/data-engineering/how-to-list-all-delta-tables-in-a-database/m-p/21349#M14541 brickster_2018 2021-06-23T19:22:17Z