We have ADLS container location which contains several (100+) different data subjects folders which contain Parquet files with partition column and we want to expose each of the data subject folder as a table in Databricks SQL. Is there any way to automate the creation these tables?

abfss://landing@xyz.dfs.core.windows.net/sc/raw/DataSubject1/

abfss://landing@xyz.dfs.core.windows.net/sc/raw/DataSubject2/

abfss://landing@xyz.dfs.core.windows.net/sc/raw/DataSubject3/

abfss://landing@xyz.dfs.core.windows.net/sc/raw/DataSubject4/

....

abfss://landing@xyz.dfs.core.windows.net/sc/raw/DataSubject100/

I would like to automatically create tables DataSubject1,DataSubject2,DataSubject3...DataSubject100 under a database (sqlanalytics_db) in Databricks SQL.