Unable to connect to app insight cluster using kql

[Zysce]

Describe the bug

I am unable to connect to a app insights cluster using #!connect kql

Please complete the following:

Which version of .NET Interactive are you using? (In a notebook, run the #!about magic command. ):
Version: 1.0.258004+3429f67626d2f15eec7d8f15a29215909284cb79

• OS
  • Windows 11
  • Windows 10
  • macOS
  • Linux (Please specify distro)
  • iOS
  • Android
• Browser
  • Chrome
  • Edge
  • Firefox
  • Safari
• Frontend
  • Jupyter Notebook
  • Jupyter Lab
  • nteract
  • Visual Studio Code
  • Visual Studio Code Insiders
  • Visual Studio
  • Other (please specify)

Screenshots

#!connect kql --kernel-name insights --cluster "https://ade.applicationinsights.io/subscriptions/<subscription>/resourceGroups/<resource-group>/providers/microsoft.insights/components/<app-insights-resource-name>" --database "<app-insights-resource-name>"

[grankiran]

Same is the case for loganalytics (fails to connect), which has a URL for format - Data Source=https://ade.loganalytics.io/subscriptions/< sub-id >/resourcegroups/< rg-name >/providers/microsoft.operationalinsights/workspaces/< workspace -name >;Initial Catalog=NetDefaultDB;AAD Federated Security=True;Authority Id=< aad-tenant-name >;User=< user-fqdn >

The stack is identical to the one above.

[janegilring]

I am seeing the same error when connecting to Log Analytics.

Any workarounds or solutions available?

[colombod]

@corivera Is there any update on this scenario?

[corivera]

@JustinMDotNet would know more about the Kusto kernel.

[JustinMDotNet]

Hey @colombod , the Kusto extension doesn't support App Insights/Log Analytics (though it could with minor modifications). The way it was originally designed, a different library was used for querying those data sources called AzureMonitor. It's built into the Kusto extension but uses a deprecated Nuget package for its querying.

[Expecho]

he Kusto extension doesn't support App Insights/Log Analytics (though it could with minor modifications). The way it was originally designed, a different library was used for querying those data sources called AzureMonitor. It's built into the Kusto extension but uses a deprecated Nuget package for its querying.

Hi @JustinMDotNet I would love to put some effort into enabling this . Do you have any pointers to get me started with this?

[colombod]

@JustinMDotNet is there any update coming? @Expecho is also willing to give this a go. Can we help him?