search

kaareseras / node-red-contrib-kusto

Custom Node-Red node to inject data in Kusto (Azure Data Explorer)
MIT License
3 stars 1 forks source link

Support for commands/queries #3

Open hannuterasloihde opened 1 year ago

hannuterasloihde commented 1 year ago

Currently the node supports only ingestion of data. Would it be possible to add execution of data explorer queries and commands?

kaareseras commented 1 year ago

I guess it will be possible to add support for commands relative easily. but Im not sure how I would work with a tabular result-set from a query and push that to other nodes

hannuterasloihde commented 1 year ago

True, the parsing of the result set is not trivial. In my use cases I'm mainly fetching rowcounts and it would be sufficient to just pass the raw result from Data Explorer to the next node. I could then parse whatever I need from the result with a function node. So not an ideal general solution, but it would help me a great deal to get rid of executing shell scripts to do the same thing.