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)
- KQL: bag unpack json into single row
- Is customDimension column name 'first' restricted?
- How can I get sub value in nested json via KQL?
- Kusto make-series by month
- KQL merge rows with the same ID into one row
- How to do a KQL time window join at millisecond granularity?
- Kusto Query replace the timestamp of duplicate rows
- Bin producing unexpected results
- How to create a whitelist with two fields in KQL with a Watchlist?
- KQL Query for Calculation of ErrorDuration within Timespan
- Add text to point(s) in Kusto linechart
- Kusto query with multiple sample values from an aggregate
- How to get data for specific date (startofweek) in a given time range in KQL?
- How can I convert TimeGenerated to TimeIngested in this KQL query for an Azure Workbook?
- multiple if and else within kql azure
- Controlling scatter chart markers in Azure Data Explorer dashboard using KQL
- Monitor HTTP traffic for Azure Web App using Log analitics and KQL query
- Defining external table kind as delta
- Kusto query map through array
- how to use or condition in kql
- KQL: Every time a word is mentioned in a column append it to a new column as a list
- KQL: Create an id column every time a value changes in column x ordered by another column y
- KQL query returns available memory but not Total Memory
- Display lines & values for whole range of y-axis values in Kusto linechart
- Kusto - fetch data from one table where matching records do not exist in another table
- KQL - extract property value from an array of JSON objects, based on the value of another property
- Defender Advance Query
- Calculation of outlier score in series_outlier method
- How to get Azure Advisor scores from azure resource graph explorer?
- KQL: How to reference columns within a let query in the next query