This pipeline can be used to export data from an ADX table to the lake via an external table.
The loop in the sample pipeline is defined a sequential. If you have a cluster with more resources, you can change the loop to parallel.
You can find a step guide, how to define metadata and deploy the pipeline in Details
- Required objects (SQL + ADX) and SQL meta data
- Pipeline definition