how to pull selected columns from ADLS table to azure data explorer(kusto), please give some screen shots for creating linked & Data sets for easy to understand.

1

There are 1 best solutions below

2
On

To pull data from ADLS to Azure Data Explorer (Kusto) with selected columns from source table using azure data factory

  • First allow ADF to access the cluster, to do this give permission to ADF System assigned Managed Identity and assign AllDatabaseAdmin role to it as below from Cluster settings >> permission >> Add >> AllDatabaseAdmin enter image description here

  • First create a Sink dataset with Azure Data Explorer (Kusto) linked service select authentication as System assigned managed identity. The select your cluster and database. enter image description here

  • After this add table where you want to copy data in the dataset. enter image description here

  • Use Mapping to pull data from selected columns from source table click on import mapping and assign it properly to destination column. enter image description here