Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Welcome to what's new in Azure Data Explorer archive. This article is an archive of new and significantly updated content in the Azure Data Explorer documentation.
April 2024
Management
Article title | Description |
---|---|
.execute cluster script command | New article. Describes how to use the .execute cluster script command to execute a batch of management commands in the scope of a cluster. |
March 2024
API
Article title | Description |
---|---|
Use Kusto cmdlets in Azure PowerShell | New article. Describes how to use Kusto cmdlets in Azure PowerShell. |
General
Article title | Description |
---|---|
Create an Azure Data Explorer cluster and database | Updated article. Refreshed steps on how to set up Azure PowerShell to run Kusto cmdlets. |
Migrate your cluster to support multiple availability zones (preview) | Updated article. Refreshed steps on how to get the list of availability zones for your cluster's region in Azure portal. |
Management
Article title | Description |
---|---|
- What are common scenarios for using table update policies - Tutorial: Route data using table update policies - Update policy overview |
New and updated articles. Describes common use cases for how to use update table policies to perform complex transformations and route results to destination tables. |
Parquet mapping | Updated article. Added parquet type conversions table to provide a mapping of Parquet field types, and the table column types they can be converted to. |
February 2024
General
Article title | Description |
---|---|
- Azure Data Explorer web UI query overview - Access the data profile of a table |
New article that describes how to access the data profile of a table in the Azure Data Explorer web UI, and updated web UI query overview. |
Customize Azure Data Explorer dashboard visuals | Updated article. Added section on embedding images in dashboard tiles. |
Create an Event Grid data connection for Azure Data Explorer | Updated article. Refreshed content. |
How to ingest historical data into Azure Data Explorer | Updated article. Refreshed content. |
Management
Article title | Description |
---|---|
Apply row-level security on SQL external tables | New article. Describes how to create a row-level security solution with Azure Data Explorer SQL external tables. |
.update table command (preview) | New article. Describes how to use the .update table command to perform transactional data updates. |
- Stored query results - .set stored_query_result command - .show stored_query_result command - .drop stored_query_result command - stored_query_result() |
New articles. Describe how to manage stored query results. |
Continuous data export overview | Updated article. Added section on continuous export to delta table, and refreshed limitations. |
Query
Article title | Description |
---|---|
sort operator | Updated article. Added section on the use of special floating-point values. |
January 2024
General
Article title | Description |
---|---|
- Integrations overview - Data integrations overview - Query integrations overview - Visualize integrations overview |
New articles. Describes the available data connectors, tools, and query integrations, and updated article on the available visualize integrations. |
Schema optimization best practices | New article. Describes the best practices for schema design in Azure Data Explorer. |
December 2023
General
Article title | Description |
---|---|
Migrate your cluster to support multiple availability zones | New article. Describes how to migrate your cluster to support multiple availability zones. |
Query
Article title | Description |
---|---|
-Scalar function types at a glance -series_cosine_similarity() - series_magnitude() - series_sum() |
New articles. Describes how to calculate series elements, and added to scalar functions overview. |
series_dot_product() | Updated article. Added section on performance optimization. |
November 2023
General
Article title | Description |
---|---|
Migrate a Virtual Network injected cluster to private endpoints (preview) | New article. Describes how to migrate a Virtual Network injected Azure Data Explorer Cluster to private endpoints. |
- Ingest data from Splunk Universal Forwarder - Ingest data with Apache Flink - Data connectors overview |
New articles that describe how to ingest data with Splunk Universal Forwarder and Apache Flink, and updated data connector overview. |
Use follower databases | Updated article. Update limitations for clusters using customer-managed keys. |
Create Power Apps application to query data in Azure Data Explorer | Updated article. Refreshed content. |
Create a Microsoft Entra application registration in Azure Data Explorer | Updated article. Added section on creating a Microsoft Entra service principal. |
Management
Article title | Description |
---|---|
Materialized views use cases | New article. Describes common and advanced use cases for materialized views. |
October 2023
General
Article title | Description |
---|---|
- Ingest data with Fluent Bit - Data connectors overview |
New article that describes how to ingest data from Fluent Bit, and updated data connector overview with additional capabilities. |
Connect a cluster behind a private endpoint to a Power BI service | New article. Describes how to connect an Azure Data Explorer cluster behind a private endpoint to a Power BI service. |
September 2023
General
Article title | Description |
---|---|
- KQL graph semantics overview (Preview) - KQL graph semantics best practices (Preview) - Common scenarios for using KQL graph semantics (Preview) |
New articles. Describes how to use Kusto Query Language (KQL) graph semantics. |
How to ingest historical data | New article. Describes how to use LightIngest to ingest historical or ad hoc data into Azure Data Explorer. |
- Ingest data from Splunk to Azure Data Explorer - Data connectors overview |
New article that describes how to ingest data into Azure Data Explorer from Splunk, and updated data connector overview with additional capabilities. |
KQL learning resources | New article. Describes the different learning resources for ramping up on KQL. |
Dashboard-specific visuals | New article. Describes the visualizations available in Azure Data Explorer web UI or dashboards. |
Create a dashboard base query | New article. Describes how to create a base query for an Azure Data Explorer dashboard. |
Management
Article title | Description |
---|---|
- .alter-merge database policy ingestionbatching command - .alter-merge table policy ingestionbatching command |
New articles. Describes how to set the ingestion batching policy. |
Query
Article title | Description |
---|---|
- Graph operators (preview) - graph-match operator (preview) - graph-to-table operator (preview) - make-graph operator (preview) |
New articles. Describes how to use graph operators. |
Plotly (preview) | New article. Describes how to visualize data using the Plotly graphics library. |
August 2023
API
Article title | Description |
---|---|
Create an app to get data using queued ingestion | New article. Describes how to create an app to get data using queued ingestion of the Kusto client libraries. |
General
Article title | Description |
---|---|
- Get data from file - Get data from Azure storage - Get data from Amazon S3 - Create an Event Hubs data connection |
New articles. Describes the new Get data experience in Azure Data Explorer. |
- Delete a cluster - Delete a database |
New articles. Describes how to delete an Azure Data Explorer cluster and database. |
Monitor ingestion, commands, queries, and tables using diagnostic logs | Updated article. Refreshed content and added journal log data tab. |
Functions library
Article title | Description |
---|---|
series_clean_anomalies_fl() | New article. Describes how to clean anomalous points in a series. |
Management
Article title | Description |
---|---|
Use a managed identity to run an update policy | New article. Describes how to configure a managed identity to run an update policy. |
.show databases entities command | New article. Describes how to show a database's entities. |
.show database extents partitioning statistics | New article. Describes how to display a database's partitioning statistics. |
Query
Article title | Description |
---|---|
Entity names | Updated article. Refreshed identifier naming rules and references in queries. |
partition operator | Updated article. Refreshed content and added parameters. |
scan operator | Updated article. Added scan logic walkthrough. |
top-nested operator | Updated article. Refreshed content. |
July 2023
API
Article title | Description |
---|---|
Connection strings overview | Updated article. Added privacy and security measures. |
SQL external table authentication methods | Updated article. Refreshed supported authentication methods. |
General
Article title | Description |
---|---|
Query data using MATLAB | New article. Describes how to query data from Azure Data Explorer using MATLAB. |
Migration guide: Elasticsearch to Azure Data Explorer | New article. Describes how to migrate your Elasticsearch data to Azure Data Explorer. |
Visualize data from Azure Data Explorer in Grafana | Updated article. Added Azure Managed Grafana. |
Management
Article title | Description |
---|---|
Data mappings | Updated article. Added supported data formats for mapping transformations. |
- Export data to SQL - Create and alter SQL external tables |
Updated articles. Added supported authentication methods and parameters. |
Query
Article title | Description |
---|---|
- punycode_domain_from_string() - punycode_domain_to_string() |
New articles. Describes how to encode and decode a punycode domain name. |
geo_line_to_s2cells() | New article. Describes how to use the geo_line_to_2cells() function to calculate S2 cell tokens that cover a line or a multiline on Earth. |
extract_json() | Updated article. Added new example. |
Pivot chart | Updated article. Added new example. |
June 2023
API
Article title | Description |
---|---|
- Kusto.Language Overview - Define schemas for semantic analysis with Kusto.Language - Parse queries and commands with Kusto.Language |
New articles. Describes how to use the Kusto.Language library for parsing queries. |
Management commands: Create an app to run management commands | New article. Describes how to create an app to run management commands using Kusto client libraries. |
Query
Article title | Description |
---|---|
- Join operator - fullouter join - inner join - innerunique join - leftanti join - leftouter join - leftsemi join - rightanti join - rightouter join - rightsemi join |
Updated and new articles. Refreshed join overview and added topics describing each join kind. |
replace_strings() | New article. Describes how to use the replace_strings() function to replace multiple string matches with multiple replacement strings. |
May 2023
General
Article title | Description |
---|---|
- Azure Data Explorer web UI query overview - Add a cluster connection in the Azure Data Explorer web UI - Write Kusto Query Language queries in the Azure Data Explorer web UI - Share queries from Azure Data Explorer web UI |
New articles. Describes how to use the Azure Data Explorer web UI to interact with your data. |
Ingest data with the NLog sink into Azure Data Explorer | New article. Describes how to use the Azure Data Explorer NLog connector to ingest data into your cluster. |
How to architect a multitenant solution with Azure Data Explorer | New article. Describes how to architect a multitenant solution in Azure Data Explorer. |
Create an Event Hubs data connection for Azure Data Explorer | Updated article. Integration from Azure Event Hubs page added. |
Install the Azure Data Explorer Kusto emulator | Updated article. Describes how to install the Kusto emulator using a Linux Docker container image. |
Customize Azure Data Explorer dashboard visuals | Updated article. Funnel chart visualization added. |
Create Power Apps application to query data in Azure Data Explorer | Updated article. Refreshed content. |
Management
Article title | Description |
---|---|
Create and alter delta external tables on Azure Storage | New article. Describes how to create and alter delta external tables on Azure Storage. |
Query
Article title | Description |
---|---|
postgresql_request plugin | New article. Describes how to use the postgresql_request plugin to send a SQL query to a PostgreSql server network endpoint. |
Treemap | New article. Describes how to use the treemap visualization to visualize data. |
geo_info_from_ip_address() | New article. Describes how to use the geo_info_from_ip_address() function to retrieve geolocation information about IPv4 or IPv6 addresses. |
bag_zip() | New article. Describes how to use the bag_zip() function to merge two dynamic arrays into a single property-bag of keys and values. |
April 2023
API
Article title | Description |
---|---|
- Set up your development environment to use Kusto client libraries - Hello Kusto: Create your first Kusto client app - Basic query: Create an app to run basic queries |
New articles. Describes how to write code with SDKs. |
General
Article title | Description |
---|---|
Azure Data Explorer web UI results grid | Updated article. New features added. |
Functions library
Article title | Description |
---|---|
- log_reduce_fl() - log_reduce_full_fl() - log_reduce_predict_fl() - log_reduce_predict_full_fl() - log_reduce_train_fl() |
New articles. Describes how to find common patterns in textual logs. |
Management
Article title | Description |
---|---|
Use a managed identity to run a continuous export job | New article. Describes how to use a managed identity for continuous export. |
Query
Article title | Description |
---|---|
Syntax conventions for reference documentation | New article. Describes the syntax conventions for the Kusto Query Language and management command documentation. |
- punycode_from_string() - punycode_to_string() |
New articles. Describes how to encode and decode Punycode. |
March 2023
General
Article title | Description |
---|---|
Python plugin packages for Azure Data Explorer | New article. Lists the available Python packages in the Azure Data Explorer Python plugin. |
- Ingest data with the Serilog sink into Azure Data Explorer - Ingest data with the Apache log4J 2 connector |
New articles. Describe how to ingest data into Azure Data Explorer using the Serilog sink, and the Apache Log4j 2 connectors. |
Manage Event Hubs data connections in your free Azure Data Explorer cluster | New article. Describes how to manage Azure Event Hubs data connections in a free Azure Data Explorer cluster. |
Manage language extensions in your Azure Data Explorer cluster | Updated article. Steps added for changing the Python language extensions image in an Azure Data Explorer cluster. |
Management
Article title | Description |
---|---|
Manage view access to tables in Azure Data Explorer | New article. Describes how to grant access to tables in Azure Data Explorer. |
- Materialized views - .show materialized-view(s) - .show materialized-view extents - .show materialized-view failures - .show materialized-view schema - .alter materialized-view autoUpdateSchema - .alter materialized-view docstring - .alter materialized-view folder - .alter materialized-view lookback - .alter materialized-view - .clear materialized-view data - .create-or-alter materialized-view - .create materialized-view - .drop materialized-view - .disable .enable materialized-view - .rename materialized-view - .show materialized view details |
New and updated articles. Describe materialized-view commands. Parameters and examples added. |
- .alter extent tags - .drop extent tags - .move extents - .replace extents |
Updated articles. Command syntax updated. |
Query
Article title | Description |
---|---|
- Kusto.Explorer code features - Kusto Explorer options - Kusto.Explorer keyboard shortcuts (hot keys) - Using Kusto.Explorer - Kusto.Explorer installation and user interface |
Updated articles. Refreshed content. |
February 2023
API
Article title | Description |
---|---|
Authentication over HTTPS | Updated article. REST API authorization examples added. |
General
Article title | Description |
---|---|
Manage Azure Data Explorer cluster locks to prevent accidental deletion in your cluster | New article. Describes how to manage cluster locks to prevent accidental deletion of data using the Azure portal. |
Connect from common apps | New article. Describes how to connect to Azure Data Explorer with SQL Server emulation from various apps. |
- Connect to Azure Data Explorer with JDBC - Connect to Azure Data Explorer with SQL Server emulation - Connect to Azure Data Explorer with ODBC |
New articles. Describes how to connect to Azure Data Explorer with different connection apps. |
Azure Data Explorer as a linked server from SQL Server | New article. Describes how to connect Azure Data Explorer as a linked server from SQL Server. |
Set timeout limits | New article. Describes how to set query timeout limits. |
Data connectors overview | New article. Describes available data connectors and their capabilities. |
- Customize settings in the Azure Data Explorer web UI - Azure Data Explorer web UI results grid - Share queries from Azure Data Explorer web UI - Quickstart: Visualize sample data dashboards - Explore the samples gallery |
New articles. Describes how to use, query, visualize, and share queries in the Azure Data Explorer web UI. |
Query data using T-SQL | Updated article. Support limitations added. |
What is the ingestion wizard? | Updated article. Management actions added. |
January 2023
General
Article title | Description |
---|---|
- Allow cross-tenant queries and commands - Referencing security principals |
Updated articles. Renewed and restructured referencing of security principals and identity providers. |
Functions library
Article title | Description |
---|---|
- plotly_anomaly_fl() - plotly_scatter3d_fl() |
New articles. Describes how to customize a plotly template. |
Management
Article title | Description |
---|---|
- .dup-next-failed-ingest - .dup-next-ingest |
New articles. Describes how to troubleshoot data on demand. |
Query
Article title | Description |
---|---|
- render operator - Anomaly chart - Area chart - Bar chart - Card - Column chart - Ladder chart - Line chart - Pie chart - Pivot chart - Scatter chart - Stacked area chart - Table - Time chart - Time pivot |
Updated and new articles. Refreshed render overview and added topics describing each render visualization. |
series_dot_product() | New article. Describes how to calculate the dot product of two numeric series. |
hll_if() (aggregation function) | New article. Describes how to calculate the intermediate results of the dcount() function. |
bag_set_key() | New article. Describes how to set a given key to a given value in a dynamic property bag. |
December 2022
General
Article title | Description |
---|---|
Find an Azure Data Explorer partner | New article. Describes the Azure Data Explorer Find My Partner Program. |
Manage Azure Data Explorer cluster permissions | New article. Describes how to manage role-based access controls for clusters. |
Ingestion behavior of invalid data | New article. Describes the possible outcomes of ingesting invalid data |
Use data from Azure Data Explorer in Power BI | New article. Describes how to use data from Azure Data Explorer in Power BI. |
- Ingest data from Azure Cosmos DB into Azure Data Explorer (preview) - Get latest versions of Azure Cosmos DB documents (preview) |
New articles. Describes how to load data and get the latest versions of Azure Cosmos DB documents. |
Configure a database using a Kusto Query Language script | Updated article. Database scripts supports .add verb. |
November 2022
Functions library
Article title | Description |
---|---|
- series_mv_ee_anomalies_fl() - series_mv_if_anomalies_fl() - series_mv_oc_anomalies_fl() |
New article. Describes multivariate anomalies in a series user-defined functions. |
Management
Article title | Description |
---|---|
.show function(s) | Updated article. Added optional arguments and tables to .show function . |
Query
Article title | Description |
---|---|
- unicode_codepoints_from_string() - unicode_codepoints_to_string() |
Updated articles. Unicode codepoints conversion functions for strings. |
- ipv6_is_in_any_range() - ipv6_is_in_range() |
New articles. Functions that check whether an IPv6 address is in a range. |
- count_distinct() (aggregation function) - (preview) - count_distinctif() (aggregation function) - (preview) |
New articles. Count unique values specified by the scalar expression per summary group. |
- series_ceiling() - series_floor() - series_log() |
New articles. Calculate the element-wise functions of the numeric series input. |
- bin_auto() - binary_shift_left() - binary_shift_right() - binary_xor() - bin_at() - bin() - bitset_count_ones() - buildschema() (aggregation function) - case() - ceiling() - cosmosdb_sql_request plugin |
Updated articles. Added new tables and examples. |
October 2022
General
Article title | Description |
---|---|
Ingest data from OpenTelemetry | New article. Describes how to create a connector to ingest data from OpenTelemetry. |
Managed identities overview | Updated article. Added continuous export with Managed Identity. |
September 2022
API
Article title | Description |
---|---|
Kusto.Data exceptions | New article. Describes Kusto.Data exceptions. |
Evaluate query performance in your cluster | New article. Describes how to load test a cluster's query performance. |
General
Article title | Description |
---|---|
POC playbook: Big data analytics | New article. Describes a high-level methodology for running an effective proof of concept (POC) project. |
Azure Data Explorer web UI keyboard shortcuts | New article. Describes query keyboard shortcuts in the web UI. |
Optimize queries that use named expressions | New article. Describes how to optimize repeat use of named expressions in a query. |
- Kusto emulator overview - Install the Kusto emulator |
New articles. Describes the Kusto emulator, how to install it, and run your first query. |
August 2022
General
Article title | Description |
---|---|
- Use the ingestion wizard to ingest JSON data - Web UI overview |
Updated articles. Added references to ingestion wizard and updated UI. |
Management
Article title | Description |
---|---|
.cancel operation command | New article. Describes how to use the .cancel operation command. |
How to authenticate with Microsoft Entra ID | Updated article. Updated with Microsoft Authentication Library authentication. |
.drop extents | Updated article. Added examples to drop specific extents. |
Queries management | Updated article. Added show by user command. |
- Ingest from storage | Updated article. Added ingest from Amazon S3. |
- .create-or-alter function - .create function |
New and updated article. Added new parameter for stored view. |
July 2022
General
Article title | Description |
---|---|
Upgrade a free cluster | New Article. Describes how to upgrade a free cluster to a full cluster without losing your data. |
Management
Article title | Description |
---|---|
.alter extent tags | Updated article. Added documentation for alter-merge extent tags. |
Query
Article title | Description |
---|---|
- convert_angle - convert_energy - convert_force - convert_length - convert_mass - convert_speed - convert_temperature - convert_volume |
New articles. New functions for converting values. |
parse-kv operator | New Article. Describes how to extract structured information from a string in key/value form. |
- Scalar function types at a glance - arg_max() (aggregation function) - arg_min() (aggregation function) - avg() (aggregation function) - max() (aggregation function) - min() (aggregation function) - sum() (aggregation function) |
Updated articles. Added new examples. |
June 2022
Article title | Description |
---|---|
Ingest data from Azure Stream Analytics (preview) | New Article. Describes how to ingest (load) data from Azure Stream Analytics. |
Azure Data Explorer web UI overview | New Article. Describes the elements of web UI home page and the data analytics journey. |
Explore the Azure Data Explorer web UI samples gallery | New Article. Describes how to use the samples gallery in the web UI. |
Select a SKU for your Azure Data Explorer cluster | Updated Article. New SKU list and refreshed content. |
May 2022
Article title | Description |
---|---|
Ingest data from Telegraf | New Article. Describes how to ingest data into your cluster from Telegraf. |
Ingest data using managed identity authentication | New Article. Queue Azure Storage blobs for ingestion using managed identity authentication. |
- Azure Data Explorer connector for Microsoft Power Automate - Usage examples for Power Automate connector - Create Power Apps application to query data in Azure Data Explorer - Microsoft Logic App and Azure Data Explorer |
Updated articles. General availability (GA). Content refreshed. |
Use parameters in Azure Data Explorer dashboards | Updated Article. Added section on drillthrough. |
April 2022
Article title | Description |
---|---|
- Enable disk encryption for your cluster - Secure your cluster with encryption - Enable double encryption for your cluster |
New articles. Describing securing your cluster using disk encryption. |
- Create a managed private endpoint for your cluster - Network security - Create a private endpoint for your cluster - Troubleshoot private endpoints - Private endpoints for your cluster - Restrict outbound access from your cluster - Restrict public access to your cluster |
New articles. Describes private endpoint security. |
Management
Article title | Description |
---|---|
Streaming ingestion failures | New article. Describes the command to show streaming ingestion failures. |
Streaming ingestion statistics | New article. Describes the command to show streaming ingestion statistics. |
March 2022
Functions library
Article title | Description |
---|---|
pairwise_dist_fl() | New article. Describes the pairwise_dist_fl() user-defined function. |
series_uv_anomalies_fl() | New article. Describes the series_uv_anomalies_fl() user-defined function. |
series_uv_change_points_fl() | New article. Describes the series_uv_change_points_fl() user-defined function. |
Management
Article title | Description |
---|---|
Clear schema cache for cross-cluster queries | New article. Describes how to manually clear the cross-cluster query cache. |
Query
Article title | Description |
---|---|
http_request plugin / http_request_post plugin | New article. Describes the http_request plugin. |
Cross-database and cross-cluster queries | Updated article. Updated links to cross-cluster queries and schema changes page. |
Cross-cluster queries and schema changes | New article. Describes cross-cluster queries and schema changes. |
February 2022
Article title | Description |
---|---|
What is a free cluster? | New article. Describes how to get started with a free Azure Data Explorer cluster. |
Cross-tenant data connection | New article. Describes how to create cross-tenant data connections for Azure Event Hubs or Azure Event Grid services in a different tenant. |
Automated provisioning | New article. Maps different articles for automating the provisioning of clusters. |
Functions library
Article title | Description |
---|---|
series_lag_fl() | New article. Describes the series_lag_fl() user-defined function. |
January 2022
Article title | Description |
---|---|
Use the sample app generator to create code to ingest and query your data | New Article. Describes how to use the sample app generator for your preferred programming language. |
API
Article title | Description |
---|---|
Azure Data Explorer API overview | Updated article. Added new tip and link to the doc on using the one-click sample app generator. |
December 2021
Article title | Description |
---|---|
Use parameters in dashboards | Updated article. Added new section for cross-filters as dashboard parameters. |
Functions library
Article title | Description |
---|---|
time_window_rolling_avg_fl() | New Article. Describes the function that calculates the rolling average of a metric over a constant duration time window. |
November 2021
Article title | Description |
---|---|
Automatic stop of inactive clusters | New article. Inactive clusters are automatically stopped. |
Solution architectures | New article. Lists references to the architectures that include Azure Data Explorer. |
Delete data | Updated article. Added new sections for purge and soft delete. |
Query
Article title | Description |
---|---|
[Soft delete] | New article. Describes the data soft delete function. |
October 2021
Article title | Description |
---|---|
Create an Event Grid data connection using C# | Updated article. AddedEvent Grid data connection from Azure portal. |
Create an Event Grid data connection using Python | Updated article. |
Manually create resources for Event Grid ingestion | Updated article. AddedEvent Grid data connection from Azure portal. |
Event Grid data connection | Updated article. AddedEvent Grid data connection from Azure portal. |
Ingest blobs by subscribing to Event Grid notifications | Updated article. Added Event Grid data connection from Azure portal. |
Add cluster principals using C# | Updated article. AddedAllDatabasesMonitor role. |
Add cluster principals using Python | Updated article. Added AllDatabasesMonitor role. |
Add cluster principals using an Azure Resource Manager template | Updated article. Added AllDatabasesMonitor role. |
Add database principals using Python | Updated article. AddedAllDatabasesMonitor role. |
Manage Azure Data Explorer database permissions | Updated article. Added AllDatabasesMonitor role. |
Management
Article title | Description |
---|---|
Role-based access control in Kusto | Updated article. Materialized views rename source table. |
Cache policy (hot and cold cache) | Updated article. Caching with long storage. |
Role-based access control in Kusto | Updated article. Using the AllDatabasesMonitor role. |
September 2021
Article title | Description |
---|---|
Ingest data from event hub into Azure Data Explorer | Updated article. Learn how to connect event hub with managed identity. |
Query
Article title | Description |
---|---|
Views | New article. Learn how to use views, which are virtual tables based on the result-set of a query. |
Entity types | Updated article. Added information on how to use views. |
August 2021
Article title | Description |
---|---|
Use wizard for ingestion with LightIngest (preview) | New article. Learn how to use a wizard for one-time ingestion of historical data with LightIngest. |
Use one-click ingestion to create an event hub data connection | Updated article. One click event hub experience. |
Use LightIngest to ingest data into Azure Data Explorer | Updated article. Generate LightIngest commands - one click experience. |
Query
Article title | Description |
---|---|
series_pow() | New article. Calculates the element-wise power of two numeric series inputs. |
Aggregation function types at a glance | New article. Lists aggregation functions, which perform a calculation on a set of values and return a single value. |
Scalar function types at a glance | Updated article. Updated aggregation function and added series_pow. |
materialized_view() function | Updated article. Updated aggregation function. |
Management
Article title | Description |
---|---|
.alter query weak consistency policy | New article. |
Query weak consistency policy | New article. |
.show query weak consistency policy | New article. |
Functions library
Article title | Description |
---|---|
pair_probabilities_fl() | New article. The function pair_probabilities_fl() calculates probabilities and metrics. |
bartlett_test_fl() | New article. The function bartlett_test_fl() performs the Bartlett Test. |
levene_test_fl() | New article. The function levene_test_fl() performs the Levene Test. |
mann_whitney_u_test_fl() | New article. The function mann_whitney_u_test_fl() performs the Mann-Whitney U Test. |
wilcoxon_test_fl() | New article. The function wilcoxon_test_fl() performs the Wilcoxon Test. |
July 2021
Article title | Description |
---|---|
Monitor batching ingestion with metrics | New article. Learn how to use Azure Data Explorer metrics to monitor batching ingestion to Azure Data Explorer in Azure portal. |
Create an external table using the Azure Data Explorer web UI wizard | Updated article. New UI. |
Use one-click ingestion to create an event hub data connection | Updated article. New UI. |
Use one-click ingestion to ingest JSON data from a local file to an existing table in Azure Data Explorer | Updated article. New UI. |
Ingest data from a container/ADLS into Azure Data Explorer | Updated article. New UI. |
Create a table in Azure Data Explorer | Updated article. New UI. |
Query
Article title | Description |
---|---|
replace_string() | New article. Replaces all string matches with another string. |
take_any() (aggregation function) | New article. Replaces any(). |
take_anyif() (aggregation function) | New article. Replaces anyif(). |
replace_regex() | Updated article. Replace() function changed to replace_regex(). |
Management
Article title | Description |
---|---|
.alter extent tags retention policy | New article. |
.delete extent tags retention policy | New article. |
Extent tags retention policy | New article. The extent tags retention policy controls the mechanism that automatically removes extent tags from tables, based on the age of the extents. |
.show extent tags retention policy | New article. |
Stored query results | Updated article. General Availability. |
Functions library
Article title | Description |
---|---|
two_sample_t_test_fl() | New article. The function two_sample_t_test_fl() performs the Two-Sample T-Test. |
June 2021
Article title | Description |
---|---|
-Monitor Azure Data Explorer ingestion, commands, queries, and tables using diagnostic logs - Monitor Azure Data Explorer performance, health, and usage with metrics |
Updated articles. Document batching types. |
Query
Article title | Description |
---|---|
rows_near() plugin | New article. Finds rows near a specified condition. |
has_any_ipv4() | New article. Returns a value indicating whether one of specified IPv4 addresses appears in a text. |
has_any_ipv4_prefix() | New article. Returns a value indicating whether one of specified IPv4 address prefixes appears in a text. |
Management
Article title | Description |
---|---|
IngestionBatching policy | Updated article. Document batching types |
May 2021
Article title | Description |
---|---|
Use follower databases | Updated article. Added table level sharing. |
April 2021
Query
Article title | Description |
---|---|
has_ipv4() | New article. Returns a value indicating whether a specified IPv4 address appears in a text. |
has_ipv4_prefix() | New article. Returns a value indicating whether a specified IPv4 address prefix appears in a text. |
scan operator (preview) | New article. Scans data, matches, and builds sequences based on the predicates. |
Query results cache | Updated article. Per shard query results cache added. |
The string data type | Updated article. |
Null Values | Updated article. |
Management
Article title | Description |
---|---|
Workload groups - Management commands | Updated article. General Availability (GA). |
Workload groups | Updated article. General Availability (GA). |
Materialized views | Updated article. General Availability (GA). |
Materialized views policies | Updated article. General Availability (GA). |
Functions library
Article title | Description |
---|---|
time_weighted_avg_fl() | New article. The function time_weighted_avg_fl() calculates the time weighted average of a metric in a given time window, over input time bins. |
API
Article title | Description |
---|---|
Request properties and ClientRequestProperties | Updated article. Per shard query results cache added. |
March 2021
Article title | Description |
---|---|
Create an external table (preview) | New article. An external table is a schema entity that references data stored outside the Azure Data Explorer database. |
Management
Article title | Description |
---|---|
- Auto delete policy command - Auto delete policy |
New articles. An auto delete policy on a table sets an expiry date for the table. |
Stored query results (preview) | Updated article. Added async mode. |
Functions library
Article title | Description |
---|---|
binomial_test_fl() | New article. The function binomial_test_fl() performs the binomial test. |
comb_fl() | New article. The function comb_fl() calculates C(n, k), the number of combinations for selection of k items out of n, without order. |
factorial_fl() | New article. The function factorial_fl() calculates factorial of positive integers (n!). |
perm_fl() | New article. The function perm_fl() calculates P(n, k), the number of permutations for selection of k items out of n, with order. |
February 2021
Article title | Description |
---|---|
Optimize for high concurrency with Azure Data Explorer | New article. In this article, you learn to optimize your Azure Data Explorer setup for high concurrency. |
Quickstart: Query data in Azure Data Explorer web UI | Updated article. Explanation of table grid options. |
Query
Article title | Description |
---|---|
ipv4_is_in_range() | New article. Checks if IPv4 string address is in IPv4-prefix notation range. |
ipv4_netmask_suffix() | New article. Returns the value of the IPv4 netmask suffix from IPv4 string address. |
has_all operator | New article. has_all operator filters based on the provided set of values (all values must be present). |
row_rank() | New article. Returns the current row's rank in a serialized row set. |
Null Values | Updated article. New behavior in Engine V3. |
String operators | Updated article. String term indexing for Engine V3. |
Management
Article title | Description |
---|---|
Materialized views data purge | New article. Data purge commands can be used to purge records from materialized views. |
.alter materialized-view lookback | New article. Alters the lookback value of an existing materialized view. |
.alter materialized-view autoUpdateSchema | New article. Sets the autoUpdateSchema value of an existing materialized view to true or false . |
.alter materialized-view docstring | New article. Alters the DocString value of an existing materialized view. |
.alter materialized-view folder | New article. Alters the folder value of an existing materialized view. |
.create-or-alter materialized-view | New article. Creates a materialized view or alters an existing materialized view. |
Materialized views policies | New article. Includes information about policies that can be set on a materialized view. |
Request queuing policy (preview) | New article. A workload group's request queuing policy controls queueing of requests for delayed execution, once a certain threshold of concurrent requests is exceeded. |
Functions library
Article title | Description |
---|---|
series_dbl_exp_smoothing_fl() | New article. Applies a double exponential smoothing filter on a series. |
January 2021
Article title | Description |
---|---|
Azure Policy Regulatory Compliance controls | New article. This page lists the compliance domains and security controls. |
Allow cross-tenant queries and commands | New article. In this article, you'll learn how to give cluster access to principals from another tenant. |
Management
Article title | Description |
---|---|
Clean extent containers commands | New article. Describes the .clean databases extentcontainers and .show database extentcontainers clean operations commands. |
Request classification policy (preview) Request classification policy (preview) - Management commands |
New articles. The classification process assigns incoming requests to a workload group, based on the characteristics of the requests. |
Request limits policy (preview) | New article. A workload group's request limits policy allows limiting the resources used by the request during its execution. |
Request rate limit policy (preview) | New article. The workload group's request rate limit policy lets you limit the number of concurrent requests classified into the workload group. |
Workload groups (preview) Workload groups (preview) - Management commands |
New articles. A workload group serves as a container for requests (queries, commands) that have similar classification criteria. A workload allows for aggregate monitoring of the requests, and defines policies for the requests. |
Queries management | Updated article. Syntax updated |
December 2020
Article title | Description |
---|---|
Ingestion error codes in Azure Data Explorer | New article. This list contains error codes you may come across during ingestion. |
Management
Article title | Description |
---|---|
.create table based-on | New article. Creates a new empty table based on existing table. |
Stored query results (preview) | New article. Stored query results is a mechanism that temporarily stores the result of a query on the service. |
Create and alter Azure Storage external tables | Updated article. Document filesPreview and dryRun external table definition options |
Export data to an external table | Updated article. New external table syntax in export docs |
Functions library
Article title | Description |
---|---|
series_metric_fl() | New article. The series_metric_fl() function selects and retrieves time series of metrics ingested to Azure Data Explorer using the Prometheus monitoring system. |
series_rate_fl() | New article. The function series_rate_fl() calculates the average rate of metric increase per second. |
series_fit_lowess_fl() | New article. The function series_fit_lowess_fl() applies a LOWESS regression on a series. |
November 2020
Article title | Description |
---|---|
Azure Policy built-in definitions | New article. Index of Azure Policy built-in policy definitions. |
Use one-click ingestion to create an event hub data connection | New article. Connect an event hub to a table using the one-click ingestion experience. |
Configure managed identities for your cluster | Updated article. Supports both user-assigned managed identities and system-assigned managed identities |
Create a table | Updated article. General availability (GA). |
Quickstart: Query data in Azure Data Explorer web UI | Updated article. New capabilities. |
What is one-click ingestion? | Updated article. Added ingestion from JSON nested levels. General availability (GA). |
Customize Azure Data Explorer dashboard visuals | Updated article. New dashboard visuals and parameter changes. |
Query
Article title | Description |
---|---|
mysql_request plugin (preview) | New article. The mysql_request plugin sends a SQL query to a MySQL Server network endpoint and returns the first rowset in the results. |
ipv4_lookup plugin | New article. The ipv4_lookup plugin looks up an IPv4 value in a lookup table and returns rows with matched values. |
ipv4_is_private() | New article. Checks if IPv4 string address belongs to a set of private network IPs. |
Splunk to Kusto Query Language map | New article. This article is intended to assist users who are familiar with Splunk learn the Kusto Query Language to write log queries with Kusto. |
gzip_compress_to_base64_string() | New article. Performs gzip compression and encodes the result to base64. |
gzip_decompress_from_base64_string() | New article. Decodes the input string from base64 and performs gzip decompression. |
array_reverse() | New article. Reverses the order of the elements in a dynamic array. |
Management
Article title | Description |
---|---|
.disable plugin | New article. Disables a plugin. |
.enable plugin | New article. Enables a plugin. |
.show plugins | New article. Lists all plugins of the cluster. |
Follower commands | Updated article. Syntax changed, added .alter follower database prefetch-extents . |
Functions library
Article title | Description |
---|---|
series_downsample_fl() | The function series_downsample_fl() downsamples a time series by an integer factor. |
series_exp_smoothing_fl() | Applies a basic exponential smoothing filter on a series. |