{"id":21505,"library":"kqlmagiccustom","title":"Kqlmagic (Custom Dependencies)","description":"Kqlmagic is a Jupyter notebook magic extension for running Kusto queries (Azure Data Explorer / Azure Monitor) and visualizing results. This variant, kqlmagiccustom, uses custom dependencies. Current version 0.1.114.post26, requires Python >=3.6. Release cadence irregular.","status":"active","version":"0.1.114.post26","language":"python","source_language":"en","source_url":"https://github.com/microsoft/jupyter-Kqlmagic","tags":["jupyter","kusto","azure","notebook","magic","kql"],"install":[{"cmd":"pip install kqlmagiccustom","lang":"bash","label":"Install kqlmagiccustom"}],"dependencies":[{"reason":"Required for authentication (InteractiveBrowserCredential, DefaultAzureCredential, etc.)","package":"azure-identity","optional":false}],"imports":[{"note":"Loading the extension must happen after import.","symbol":"kqlmagiccustom","correct":"import kqlmagiccustom"}],"quickstart":{"code":"%load_ext kqlmagiccustom\ncluster = \"your_cluster_url\"\ndatabase = \"your_database_name\"\nquery = \"YourTable | take 10\"\n%kql --cluster $cluster --database $database $query","lang":"python","description":"Load the magic extension, set cluster and database, then run a KQL query."},"warnings":[{"fix":"Ensure the cell containing '%load_ext kqlmagiccustom' is executed before any '%kql' cells.","message":"The magic command '%kql' requires that you first load the extension with '%load_ext kqlmagiccustom' before use.","severity":"gotcha","affected_versions":"all"},{"fix":"Use '--auth-mode' flag (e.g., 'device_code', 'interactive') and pass credentials via environment variables or config.","message":"Authentication changes: older versions used '--tenant-id' or '--client-id' flags; newer versions may require a KustoConnectionStringBuilder or different auth flow.","severity":"breaking","affected_versions":">=0.1.100"}],"env_vars":null,"last_verified":"2026-04-27T00:00:00.000Z","next_check":"2026-07-26T00:00:00.000Z","problems":[{"fix":"Run '!pip install kqlmagiccustom' in a notebook cell or install in the correct environment.","cause":"The package is not installed or the kernel is using a different Python environment.","error":"%load_ext kqlmagiccustom\nImportError: No module named 'kqlmagiccustom'"},{"fix":"Add a cell with '%load_ext kqlmagiccustom' and run it before any queries.","cause":"Extension not loaded; missing '%load_ext kqlmagiccustom' before '%kql'.","error":"no module named 'kqlmagiccustom'"},{"fix":"Verify your Azure AD app registration and correct the tenant/client IDs in the magic command.","cause":"Invalid client ID or tenant ID provided for app registration.","error":"Kusto client error: AADSTS700016: Application with identifier '...' was not found"}],"ecosystem":"pypi","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}