Good day All.

Please can you advise on the following scenario keeping in mind Synapse Pipelines / ADF is used for ETL.

I need to implement a solution where:

> Data is loaded into the Raw Layer
> Synapse: Executes ETL activities and load to Enriched Destination

> User (Business) : Needs to get an email to approve the data that has been transformed and in the  enriched layer

> The ADF pipeline to await this approval before moving the data to the curated layer

> Once the Business user approves, the pipeline completes its execution into curated automatically.

Any Architectural Advise to archive this?

Thank you in advance.

​Good day All.Please can you advise on the following scenario keeping in mind Synapse Pipelines / ADF is used for ETL.I need to implement a solution where:> Data is loaded into the Raw Layer> Synapse: Executes ETL activities and load to Enriched Destination> User (Business) : Needs to get an email to approve the data that has been transformed and in the  enriched layer> The ADF pipeline to await this approval before moving the data to the curated layer> Once the Business user approves, the pipeline completes its execution into curated automatically.Any Architectural Advise to archive this?Thank you in advance.  Read More

​