I have a data factory pipeline that helps us clean our data sources for compliance (cosmos/blobs etc). I want to add kusto clean up as well to this pipeline. There is a purge option in kusto that helps to clean docs but this command can only be run on the Data Management endpoint (https://ingest-[YourClusterName].[Region].kusto.windows.net).
There is an ADF activity for data explorer commands but I cannot select the data management endpoint in the linked service. The auto populate doesn't include ingest cluster (only normal kusto cluster is present) and when entering it manually requires database and other info which is not present for data management endpoint. Is there a way we can select the data management endpoint for the command activity ? If not is there any other way to do this ?