We have created a logic app which would read the data from a Staging table from Azure Data Explorer and would expand the data using the Azure Data Explorer. Once expanded it would then push the data back to Azure Data Explorer to another table. This entire process takes around 1.5 hrs since we are fetching around 6k records from Staging table and we are writing around 9k records into the Azure Data Explorer table.
Below are the detailed steps:
1. Extract Data from Staging Table
Iterate through the records obtained from step 1(Here we are iterating over 6.2k records)
Once done we would expand the data which generate records and added into the table in Azure Data Explorer:
Since the entire process is taking around 1.5 hs we would like to optimize this execution. How do we increase the compute capacity of logic apps so to speed up the execution and to perform the operations quickly.
Is there a way to increase the memory or the compute instance for logic apps. Kindly provide with the optimized approach for this.
