You may want to get a list of all the Delta tables and non-Delta tables available in your Unity Catalog instance.

You can use these sample SQL queries to get a table names and the corresponding data source format.

Instructions

Make sure your cluster has permission to access Unity Catalog.

Use this sample SQL query to get a list of all the available Delta tables in your Unity Catalog.

%sql

SELECT table_name, data_source_format 
FROM system.information_schema.tables where data_source_format = "DELTA";

Use this sample SQL query to get a list of all the available tables and their source formats in your Unity Catalog.

%sql

SELECT table_name, data_source_format 
FROM system.information_schema.tables;