Skip to content

Connection Error in Jupyter Notebook for Azure Data Explorer (Kusto) #26165

Open
@asilverman

Description

@asilverman

Type: Bug

Description:
When attempting to establish a connection to the Azure Data Explorer cluster (s360prodro.kusto.windows.net) through a Jupyter Notebook in Azure Data Studio, the following error occurs:
"Object reference not set to an instance of an object."

This issue prevents the connection from being established and blocks further querying of the specified database (service360db).

Image


Steps to Reproduce:

  1. Open a Jupyter Notebook in Azure Data Studio.
  2. Set up the connection with the following details:
    • Connection Type: Azure Data Explorer (Kusto)
    • Cluster: https://s360prodro.kusto.windows.net
    • Authentication Type: Azure Active Directory - Universal with MFA support
    • Database: service360db
  3. Click Connect.
  4. Observe the error: "Object reference not set to an instance of an object."

Expected Behavior:

The connection to the Azure Data Explorer cluster should be established successfully, allowing the notebook to run queries on the specified database.

Additional Context:

  • The issue occurs consistently when trying to connect to the Azure Data Explorer cluster via a Jupyter Notebook in Azure Data Studio.
  • The cluster and database connection work correctly when accessed via other tools, such as Kusto Explorer.
  • Ensuring correct Azure Active Directory authentication details (Universal with MFA support) does not resolve the issue.

Azure Data Studio version: azuredatastudio 1.50.0 (49c73a8, 2024-11-17T22:41:05.327Z)
OS version: Windows_NT x64 10.0.26100
Restricted Mode: No
Preview Features: Enabled
Modes:

System Info
Item Value
CPUs AMD EPYC 7763 64-Core Processor (16 x 2445)
GPU Status 2d_canvas: unavailable_software
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: disabled_software
multiple_raster_threads: enabled_on
opengl: disabled_off
rasterization: disabled_software
raw_draw: disabled_off_ok
skia_graphite: disabled_off
video_decode: disabled_software
video_encode: disabled_software
vulkan: disabled_off
webgl: unavailable_software
webgl2: unavailable_software
webgpu: unavailable_software
webnn: disabled_off
Load (avg) undefined
Memory (System) 63.95GB (39.87GB free)
Process Argv
Screen Reader no
VM 0%
Extensions (2)
Extension Author (truncated) Version
copilot Git 1.242.0
kusto Mic 0.5.8

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions