F&O Export to Data Lake to Azure SQL DB

Hi everyone,

I am asking this question for learning purposes. I have used the Export to Data Lake features to get some tables from F&O into ADLS Gen 2. I was also exploring how to consume the data, and I found the Power BI ADLS Gen 2 connector with the Common Data Model (CDM) option. Secondly, I found the CDM Util approach.

But I would like to know that is it possible to use ADF/Synapse Pipelines to loop through all the tables inside the Tables.manifest.cdm.json file and copy them into Azure SQL DB.

Thanks in advance.