We have BigJson files (complex nested Json files 10 levels deep) stored in Azure Data Lake gen 2. We need to read the Json files, parse them and store the data into separate tables in Azure SQL DB.
So, it's NOT like parsing the Json into one single flattened denormalized table in SQL DW.
Can we do this by Azure Data Factory? What is the best way to achieve this?