How to execute kusto DDL commands in Azure Data Studio?
DDL commands in kusto generally start with . . But the SQL Editor in Azure Data Studio is not liking it? Note that the parser is happy (no errors noted in red):
Query failed: A recognition error occurred in the query. Query could not be parsed at '.' on line [1,1]
Solution
This Azure Data Studio extension currently supports running only queries, but not control commands.
https://learn.microsoft.com/en-us/azure-data-studio/extensions/kusto-extension
you can run control commands from the ADX web interface (https://dataexplorer.azure.com)
- How to ingest inline into Azure Data Explorer Table from PowerShell?
- Using KQL and externaldata() operator to pull infromation from json file
- ADF Copy activity is making double column in adx as "infinity" for 1.7976931348623157E308 value
- KQL: how to exclude first and last incomplete bin?
- KQL query to extend new column with other row values
- How to create an empty bag in KQL?
- Column contains text contains other column
- Kql function to append columns
- Applying a KQL query to the transform_kql parameter through terraform
- KQL query to list the secrets and keys in keyvault that are expired or going to expire in 7 days
- Monitor HTTP traffic for Azure Web App using Log analytics and KQL query
- How to hide or change legend in "Run query and visualize results" logic app function?
- How to calculate time difference between the latest entries of two indirectly tables in Kusto (KQL)?
- Calculate the number of overlapping days for each device using KQL
- How good is performance of "has" operator in Kusto when RHS is not exactly one term?
- how to retrieve all resources under given subnet using Azure Resource Graph Explorer query
- Count how many elements are in an array created by make_set in kusto language
- Inserting data in KQL
- Stuck at PIM Diagnostics via KQL
- union with all fields
- How to create an Alert for Data Collection Rule deletion across all VMs in a subscription?
- Are joins within the same cluster consistent and isolated in Azure Data Explore?
- How to run Get Kusto query using Rest API
- use range with custom field
- Azure Application Insights: How to make a nice time graph from a custom KQL query?
- KQL: bag unpack json into single row
- Is customDimension column name 'first' restricted?
- How can I get sub value in nested json via KQL?
- ADX - KQL: Conditionally Extending Property Columns from Dynamic Column
- Kusto make-series by month