Troubleshooting ADX table operations error in ADF with Kql

Question

I'm trying to remove the content of an ADX table from a Lookup in ADF using Kql before inserting new data. When I run a query with just the table name (using TableName), it displays the table content from ADX, which works fine. However, when I try to run a control command like 'insert' or 'clear,' it shows an error. The error message mentions that queries starting with a dot (.) are not allowed. Query: . Request is invalid and cannot be processed: { "error": { "code": "Bad request", "message": "Control commands (starting with a dot '.') cannot be served from the query endpoint unless they are .show control commands." }

Answer 1

Hi @HideyoshiAkaio ,

Thank you for using Microsoft Q&A platform and thanks for your question.

In Azure Data Factory lookup activity can only run queries and cannot execute ADX commands. To execute ADX commands in ADF, you can use the Azure Data Explorer Command activity.

Once you have configured the Azure Data Explorer Command activity, you can use it in your pipeline to execute ADX commands.

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.