Support Azure Application Insights &

[shawnz42]

I'm always frustrated when I want to use superset to explore my data in Azure Application Insights. I need to use its api to pull data into postgresql, and use superset connect postgresql, but when data amount get larger, it's very inefficient. I think if superset can directly connect to Azure Application Insights, it has api but use kusto sql, something differ from ansi sql.

Azure Application Insights docs: https://dev.applicationinsights.io/documentation/Overview
kusto sql: https://docs.microsoft.com/azure/data-explorer/kusto/query/
python lib: https://github.com/Azure/azure-kusto-python

I want to write a new connection to visit Azure Application Insights, is any guides or examples?

[issue-label-bot]

Issue-Label Bot is automatically applying the label #enhancement to this issue, with a confidence of 0.64. Please mark this comment with 👍 or 👎 to give our bot feedback!

Links: app homepage, dashboard and code for this bot.

[villebro]

@zheya08 Based on this SQL to Kusto cheat sheet, Kusto (or KQL) is a subset of SQL but with different syntax than SQL. Instead of writing a custom connector that can only be used with Superset, have you considered authoring a Sql Alchemy connector for Kusto? In addition to being able to connect Superset to Azure Application Insights, it could be leveraged by the whole Python ecosystem.

[junlincc]

🏷sources

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.

[junlincc]

@villebro did pysuperset take us one step closer to supporting Azure application? or is it relevant?

[villebro]

It's not directly relevant I'm afraid. What's really needed is a Kusto SQLAlchemy connector.

[xneg]

Hi there! We added Kusto db_engine to Superset.