Back to Details

azure-data-explorer

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Azure Data Explorer Skill

Azure Data Explorer Skill

This skill provides expert guidance for Azure Data Explorer. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.
本Skill为Azure Data Explorer提供专业指导，涵盖故障排除、最佳实践、决策制定、架构与设计模式、限制与配额、安全、配置、集成与编码模式以及部署。它结合了本地快速参考内容与远程文档获取能力。

How to Use This Skill

如何使用本Skill

IMPORTANT for Agent: Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., 
L35-L120
), use 
read_file
with the specified lines. For categories with file links (e.g., 
[security.md](security.md)
), use 
read_file
on the linked reference file
IMPORTANT for Agent: If 
metadata.generated_at
is more than 3 months old, suggest the user pull the latest version from the repository. If 
mcp_microsoftdocs
tools are not available, suggest the user install it: Installation Guide
This skill requires network access to fetch documentation content:
  • Preferred: Use 
    mcp_microsoftdocs:microsoft_docs_fetch
    with query string 
    from=learn-agent-skill
    . Returns Markdown.
  • Fallback: Use 
    fetch_webpage
    with query string 
    from=learn-agent-skill&accept=text/markdown
    . Returns Markdown.
Agent注意事项：使用下方的分类索引定位相关章节。对于带有行范围的分类（例如
L35-L120
），使用
read_file
读取指定行。对于带有文件链接的分类（例如
[security.md](security.md)
），使用
read_file
读取链接的参考文件
Agent注意事项：如果
metadata.generated_at
已超过3个月，建议用户从仓库拉取最新版本。如果
mcp_microsoftdocs
工具不可用，建议用户安装：安装指南
本Skill需要网络访问权限来获取文档内容：
  • 首选方式：使用
    mcp_microsoftdocs:microsoft_docs_fetch
    ，查询字符串为
    from=learn-agent-skill
    ，返回Markdown格式内容。
  • 备用方式：使用
    fetch_webpage
    ，查询字符串为
    from=learn-agent-skill&accept=text/markdown
    ，返回Markdown格式内容。

Category Index

分类索引

CategoryLinesDescription
TroubleshootingL37-L48Diagnosing and fixing ADX cluster health, creation, connection, private endpoint, ingestion, and DB/table operation errors, including interpreting ingestion error codes and using Resource Health.
Best PracticesL49-L59Guidance on ADX performance and reliability: schema design, handling duplicates, JSON ingestion, monitoring queued ingestion, hot/cold data querying, high concurrency, and Power BI integration.
Decision MakingL60-L74Guidance on ADX cluster sizing and SKUs, cost and reservations, business continuity, confidential/isolated compute, streaming ingestion choices, and migrating from Elasticsearch.
Architecture & Design PatternsL75-L81Patterns for ADX deployment: regional DR and replication, cross-cluster access via follower DBs, and multitenant cluster/database design choices.
Limits & QuotasL82-L92Cluster limits and behaviors: free cluster quotas, auto-stop, safe delete/recover, ingestion file size and invalid data handling, and supported data/compression formats.
SecurityL93-L120Configuring ADX security: auth/RBAC, managed identities, encryption/CMK, network isolation (private endpoints, outbound/public access), policies, compliance, and data privacy (purge).
ConfigurationL121-L136Configuring ADX clusters, schemas, policies, plugins, and data connections, plus emulator setup, KQL/T-SQL use, monitoring refs, and web UI settings/profiles/shortcuts.
Integrations & Coding PatternsL137-L170Integrating ADX with tools and services (SQL, ODBC/JDBC, Power Automate/Apps, Functions, Grafana, Splunk, OpenTelemetry, Tableau, MATLAB, etc.) and coding/query patterns for those connections.
DeploymentL171-L177Provisioning and automating ADX environments, deploying schema via Azure DevOps, and migrating clusters to availability zones and from VNet injection to private endpoints.
分类行范围描述
故障排除L37-L48诊断并修复ADX集群健康、创建、连接、专用终结点、数据摄入以及数据库/表操作错误，包括解读摄入错误代码和使用资源健康功能。
最佳实践L49-L59ADX性能与可靠性指导：架构设计、重复数据处理、JSON数据摄入、队列摄入监控、冷热数据查询、高并发以及Power BI集成。
决策制定L60-L74ADX集群规模与SKU选择、成本与预留实例、业务连续性、机密/隔离计算、流式摄入选择以及从Elasticsearch迁移的指导。
架构与设计模式L75-L81ADX部署模式：区域灾难恢复与复制、通过跟随数据库实现跨集群访问、多租户集群/数据库设计选择。
限制与配额L82-L92集群限制与行为：免费集群配额、自动停止、安全删除/恢复、摄入文件大小与无效数据处理、支持的数据/压缩格式。
安全L93-L120配置ADX安全：身份验证/RBAC、托管标识、加密/CMK、网络隔离（专用终结点、出站/公共访问）、策略、合规性以及数据隐私（清除）。
配置L121-L136配置ADX集群、架构、策略、插件以及数据连接，此外还有模拟器设置、KQL/T-SQL使用、监控参考以及Web UI设置/配置文件/快捷键。
集成与编码模式L137-L170将ADX与工具和服务集成（SQL、ODBC/JDBC、Power Automate/Apps、Functions、Grafana、Splunk、OpenTelemetry、Tableau、MATLAB等），以及这些连接的编码/查询模式。
部署L171-L177预配并自动化ADX环境、通过Azure DevOps部署架构、将集群迁移到可用性区域以及从VNet注入迁移到专用终结点。

Troubleshooting

故障排除

TopicURL
Monitor and troubleshoot Azure Data Explorer cluster healthhttps://learn.microsoft.com/en-us/azure/data-explorer/check-cluster-health
Interpret ADX ingestion error codes and failureshttps://learn.microsoft.com/en-us/azure/data-explorer/error-codes
Resolve common Azure Data Explorer ingestion issueshttps://learn.microsoft.com/en-us/azure/data-explorer/ingestion-faq
Use Resource Health to diagnose ADX issueshttps://learn.microsoft.com/en-us/azure/data-explorer/monitor-with-resource-health
Troubleshoot Azure Data Explorer private endpoint issueshttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-private-endpoint-troubleshoot
Fix Azure Data Explorer cluster connection issueshttps://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-connect-cluster
Troubleshoot Azure Data Explorer cluster creation failureshttps://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-create-cluster
Resolve Azure Data Explorer DB and table operation failureshttps://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-database-table
主题URL
监控并排查Azure Data Explorer集群健康问题https://learn.microsoft.com/en-us/azure/data-explorer/check-cluster-health
解读ADX数据摄入错误代码与失败原因https://learn.microsoft.com/en-us/azure/data-explorer/error-codes
解决Azure Data Explorer常见数据摄入问题https://learn.microsoft.com/en-us/azure/data-explorer/ingestion-faq
使用资源健康功能排查ADX问题https://learn.microsoft.com/en-us/azure/data-explorer/monitor-with-resource-health
排查Azure Data Explorer专用终结点问题https://learn.microsoft.com/en-us/azure/data-explorer/security-network-private-endpoint-troubleshoot
修复Azure Data Explorer集群连接问题https://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-connect-cluster
排查Azure Data Explorer集群创建失败问题https://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-create-cluster
解决Azure Data Explorer数据库与表操作失败问题https://learn.microsoft.com/en-us/azure/data-explorer/troubleshoot-database-table

Best Practices

最佳实践

TopicURL
Handle duplicate data in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/dealing-with-duplicates
Optimize Azure Data Explorer clusters for high-concurrency workloadshttps://learn.microsoft.com/en-us/azure/data-explorer/high-concurrency
Use hot windows to efficiently query cold data in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/hot-windows
Ingest JSON into Azure Data Explorer with KQL, C#, and Pythonhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-json-formats
Monitor queued ingestion metrics in ADXhttps://learn.microsoft.com/en-us/azure/data-explorer/monitor-queued-ingestion
Apply Power BI best practices for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/power-bi-best-practices
Optimize Azure Data Explorer table schema designhttps://learn.microsoft.com/en-us/azure/data-explorer/schema-best-practice
主题URL
在Azure Data Explorer中处理重复数据https://learn.microsoft.com/en-us/azure/data-explorer/dealing-with-duplicates
优化Azure Data Explorer集群以应对高并发工作负载https://learn.microsoft.com/en-us/azure/data-explorer/high-concurrency
使用热窗口高效查询Azure Data Explorer中的冷数据https://learn.microsoft.com/en-us/azure/data-explorer/hot-windows
通过KQL、C#和Python将JSON数据摄入Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-json-formats
监控ADX中的队列摄入指标https://learn.microsoft.com/en-us/azure/data-explorer/monitor-queued-ingestion
应用Azure Data Explorer的Power BI最佳实践https://learn.microsoft.com/en-us/azure/data-explorer/power-bi-best-practices
优化Azure Data Explorer表架构设计https://learn.microsoft.com/en-us/azure/data-explorer/schema-best-practice

Decision Making

决策制定

TopicURL
Choose Azure Data Explorer business continuity optionshttps://learn.microsoft.com/en-us/azure/data-explorer/business-continuity-overview
Deploy Azure Data Explorer with confidential computehttps://learn.microsoft.com/en-us/azure/data-explorer/confidential-compute
Decide when to use streaming ingestion in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-streaming
Select isolated compute SKUs for Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/isolated-compute
Choose optimal Azure Data Explorer compute SKUhttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-choose-sku
Plan vertical scaling and SKU changes for clustershttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-vertical-scaling
Migrate Elasticsearch workloads to Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/migrate-elasticsearch-to-azure-data-explorer
Use ADX pricing calculator for cluster planninghttps://learn.microsoft.com/en-us/azure/data-explorer/pricing-calculator
Optimize ADX cost per GB ingestedhttps://learn.microsoft.com/en-us/azure/data-explorer/pricing-cost-drivers
Understand ADX reservation discount applicationhttps://learn.microsoft.com/en-us/azure/data-explorer/pricing-reservation-discount
Buy ADX reserved capacity to reduce markup costshttps://learn.microsoft.com/en-us/azure/data-explorer/pricing-reserved-capacity
主题URL
选择Azure Data Explorer业务连续性方案https://learn.microsoft.com/en-us/azure/data-explorer/business-continuity-overview
部署带有机密计算的Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/confidential-compute
确定何时在Azure Data Explorer中使用流式摄入https://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-streaming
为Data Explorer集群选择隔离计算SKUhttps://learn.microsoft.com/en-us/azure/data-explorer/isolated-compute
选择最优的Azure Data Explorer计算SKUhttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-choose-sku
规划集群的纵向扩展与SKU变更https://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-vertical-scaling
将Elasticsearch工作负载迁移到Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/migrate-elasticsearch-to-azure-data-explorer
使用ADX定价计算器进行集群规划https://learn.microsoft.com/en-us/azure/data-explorer/pricing-calculator
优化ADX每GB摄入成本https://learn.microsoft.com/en-us/azure/data-explorer/pricing-cost-drivers
了解ADX预留折扣应用方式https://learn.microsoft.com/en-us/azure/data-explorer/pricing-reservation-discount
购买ADX预留容量以降低加价成本https://learn.microsoft.com/en-us/azure/data-explorer/pricing-reserved-capacity

Architecture & Design Patterns

架构与设计模式

TopicURL
Design ADX regional DR and replication solutionshttps://learn.microsoft.com/en-us/azure/data-explorer/business-continuity-create-solution
Use follower databases for cross-cluster ADX accesshttps://learn.microsoft.com/en-us/azure/data-explorer/follower
Choose multitenant architectures for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/multi-tenant
主题URL
设计ADX区域灾难恢复与复制解决方案https://learn.microsoft.com/en-us/azure/data-explorer/business-continuity-create-solution
使用跟随数据库实现ADX跨集群访问https://learn.microsoft.com/en-us/azure/data-explorer/follower
为Azure Data Explorer选择多租户架构https://learn.microsoft.com/en-us/azure/data-explorer/multi-tenant

Limits & Quotas

限制与配额

TopicURL
Understand automatic stop behavior for inactive clustershttps://learn.microsoft.com/en-us/azure/data-explorer/auto-stop-clusters
Apply Event Grid ingestion file size limits in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/create-event-grid-connection
Delete and recover Azure Data Explorer clusters safelyhttps://learn.microsoft.com/en-us/azure/data-explorer/delete-cluster
Understand invalid data behavior during ADX ingestionhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-invalid-data
Supported data and compression formats for Azure Data Explorer ingestionhttps://learn.microsoft.com/en-us/azure/data-explorer/ingestion-supported-formats
Use Azure Data Explorer free cluster limitshttps://learn.microsoft.com/en-us/azure/data-explorer/start-for-free
Upgrade free Azure Data Explorer clusters and remove limitshttps://learn.microsoft.com/en-us/azure/data-explorer/start-for-free-upgrade
主题URL
了解非活动集群的自动停止行为https://learn.microsoft.com/en-us/azure/data-explorer/auto-stop-clusters
应用Azure Data Explorer中Event Grid摄入文件大小限制https://learn.microsoft.com/en-us/azure/data-explorer/create-event-grid-connection
安全删除并恢复Azure Data Explorer集群https://learn.microsoft.com/en-us/azure/data-explorer/delete-cluster
了解ADX数据摄入期间的无效数据处理行为https://learn.microsoft.com/en-us/azure/data-explorer/ingest-invalid-data
Azure Data Explorer数据摄入支持的数据与压缩格式https://learn.microsoft.com/en-us/azure/data-explorer/ingestion-supported-formats
使用Azure Data Explorer免费集群限制https://learn.microsoft.com/en-us/azure/data-explorer/start-for-free
升级Azure Data Explorer免费集群并移除限制https://learn.microsoft.com/en-us/azure/data-explorer/start-for-free-upgrade

Security

安全

TopicURL
Programmatically add Azure Data Explorer cluster principalshttps://learn.microsoft.com/en-us/azure/data-explorer/add-cluster-principal
Programmatically add Azure Data Explorer database principalshttps://learn.microsoft.com/en-us/azure/data-explorer/add-database-principal
Enable disk encryption for Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/cluster-encryption-disk
Configure encryption options for Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/cluster-encryption-overview
Configure managed identities on Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/configure-managed-identities-cluster
Configure cross-tenant access for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/cross-tenant-query-and-commands
Configure customer-managed keys for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/customer-managed-keys
Purge personal data from Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/data-purge-portal
Authenticate external tables with managed identitieshttps://learn.microsoft.com/en-us/azure/data-explorer/external-tables-managed-identities
Ingest data using managed identity authenticationhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-managed-identity
Configure and manage Azure Data Explorer cluster lockshttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-locks
Configure Azure Data Explorer cluster RBAC permissionshttps://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-permissions
Configure database and table RBAC in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/manage-database-permissions
Use managed identities with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/managed-identities-overview
Apply built-in Azure Policy definitions to ADXhttps://learn.microsoft.com/en-us/azure/data-explorer/policy-reference
Securely connect private-endpoint clusters to Power BIhttps://learn.microsoft.com/en-us/azure/data-explorer/power-bi-private-endpoint
Create and authorize Microsoft Entra apps for Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/provision-entra-id-app
Enable conditional access policies for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/security-conditional-access
Apply Azure Policy compliance controls to Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/security-controls-policy
Configure managed private endpoints for Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-managed-private-endpoint-create
Plan network security for Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-overview
Secure Azure Data Explorer with private endpointshttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-private-endpoint
Restrict outbound access from Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-restrict-outbound-access
Control public network access to Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-restrict-public-access
主题URL
以编程方式添加Azure Data Explorer集群主体https://learn.microsoft.com/en-us/azure/data-explorer/add-cluster-principal
以编程方式添加Azure Data Explorer数据库主体https://learn.microsoft.com/en-us/azure/data-explorer/add-database-principal
为Azure Data Explorer集群启用磁盘加密https://learn.microsoft.com/en-us/azure/data-explorer/cluster-encryption-disk
配置Azure Data Explorer集群的加密选项https://learn.microsoft.com/en-us/azure/data-explorer/cluster-encryption-overview
在Azure Data Explorer集群上配置托管标识https://learn.microsoft.com/en-us/azure/data-explorer/configure-managed-identities-cluster
配置Azure Data Explorer的跨租户访问https://learn.microsoft.com/en-us/azure/data-explorer/cross-tenant-query-and-commands
为Azure Data Explorer配置客户管理密钥https://learn.microsoft.com/en-us/azure/data-explorer/customer-managed-keys
从Azure Data Explorer中清除个人数据https://learn.microsoft.com/en-us/azure/data-explorer/data-purge-portal
使用托管标识对外部表进行身份验证https://learn.microsoft.com/en-us/azure/data-explorer/external-tables-managed-identities
使用托管标识身份验证摄入数据https://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-managed-identity
配置并管理Azure Data Explorer集群锁https://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-locks
配置Azure Data Explorer集群RBAC权限https://learn.microsoft.com/en-us/azure/data-explorer/manage-cluster-permissions
在Azure Data Explorer中配置数据库与表RBAChttps://learn.microsoft.com/en-us/azure/data-explorer/manage-database-permissions
在Azure Data Explorer中使用托管标识https://learn.microsoft.com/en-us/azure/data-explorer/managed-identities-overview
向ADX应用内置Azure Policy定义https://learn.microsoft.com/en-us/azure/data-explorer/policy-reference
将专用终结点集群安全连接到Power BIhttps://learn.microsoft.com/en-us/azure/data-explorer/power-bi-private-endpoint
为Data Explorer创建并授权Microsoft Entra应用https://learn.microsoft.com/en-us/azure/data-explorer/provision-entra-id-app
为Azure Data Explorer启用条件访问策略https://learn.microsoft.com/en-us/azure/data-explorer/security-conditional-access
向Data Explorer应用Azure Policy合规控制https://learn.microsoft.com/en-us/azure/data-explorer/security-controls-policy
为Data Explorer配置托管专用终结点https://learn.microsoft.com/en-us/azure/data-explorer/security-network-managed-private-endpoint-create
规划Azure Data Explorer集群的网络安全https://learn.microsoft.com/en-us/azure/data-explorer/security-network-overview
使用专用终结点保护Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-private-endpoint
限制Azure Data Explorer集群的出站访问https://learn.microsoft.com/en-us/azure/data-explorer/security-network-restrict-outbound-access
控制Data Explorer集群的公共网络访问https://learn.microsoft.com/en-us/azure/data-explorer/security-network-restrict-public-access

Configuration

配置

TopicURL
Clone Azure Data Explorer database schemas with management commandshttps://learn.microsoft.com/en-us/azure/data-explorer/clone-database-schema
Use KQL database scripts in ARM deploymentshttps://learn.microsoft.com/en-us/azure/data-explorer/database-script
Programmatically create Azure Data Explorer database and table policieshttps://learn.microsoft.com/en-us/azure/data-explorer/database-table-policies
Create cross-tenant Event Hubs data connections for Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-cross-tenant
Install and run the ADX Kusto emulatorhttps://learn.microsoft.com/en-us/azure/data-explorer/kusto-emulator-install
Manage language extension plugins in Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/language-extensions
Reference metrics and logs for Azure Data Explorer monitoringhttps://learn.microsoft.com/en-us/azure/data-explorer/monitor-data-explorer-reference
Synchronize ADX schema with Sync Kusto toolhttps://learn.microsoft.com/en-us/azure/data-explorer/sync-kusto
Use T-SQL queries against Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/t-sql
Customize Azure Data Explorer web UI environment settingshttps://learn.microsoft.com/en-us/azure/data-explorer/web-customize-settings
Configure cloud sync for Azure Data Explorer web UI profileshttps://learn.microsoft.com/en-us/azure/data-explorer/web-sync
Use Azure Data Explorer web UI query keyboard shortcutshttps://learn.microsoft.com/en-us/azure/data-explorer/web-ui-query-keyboard-shortcuts
主题URL
使用管理命令克隆Azure Data Explorer数据库架构https://learn.microsoft.com/en-us/azure/data-explorer/clone-database-schema
在ARM部署中使用KQL数据库脚本https://learn.microsoft.com/en-us/azure/data-explorer/database-script
以编程方式创建Azure Data Explorer数据库与表策略https://learn.microsoft.com/en-us/azure/data-explorer/database-table-policies
为Azure Data Explorer创建跨租户Event Hubs数据连接https://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-cross-tenant
安装并运行ADX Kusto模拟器https://learn.microsoft.com/en-us/azure/data-explorer/kusto-emulator-install
管理Azure Data Explorer中的语言扩展插件https://learn.microsoft.com/en-us/azure/data-explorer/language-extensions
参考Azure Data Explorer监控指标与日志https://learn.microsoft.com/en-us/azure/data-explorer/monitor-data-explorer-reference
使用Sync Kusto工具同步ADX架构https://learn.microsoft.com/en-us/azure/data-explorer/sync-kusto
对Azure Data Explorer使用T-SQL查询https://learn.microsoft.com/en-us/azure/data-explorer/t-sql
自定义Azure Data Explorer Web UI环境设置https://learn.microsoft.com/en-us/azure/data-explorer/web-customize-settings
为Azure Data Explorer Web UI配置文件配置云同步https://learn.microsoft.com/en-us/azure/data-explorer/web-sync
使用Azure Data Explorer Web UI查询键盘快捷键https://learn.microsoft.com/en-us/azure/data-explorer/web-ui-query-keyboard-shortcuts

Integrations & Coding Patterns

集成与编码模式

TopicURL
Manage ADX with Azure PowerShell Kusto cmdletshttps://learn.microsoft.com/en-us/azure/data-explorer/azure-powershell
Connect common SQL tools to Azure Data Explorer via emulationhttps://learn.microsoft.com/en-us/azure/data-explorer/connect-common-apps
Configure JDBC connectivity to Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/connect-jdbc
Set up ODBC connections to Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/connect-odbc
Query Azure Storage external tables from Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/external-azure-storage-tables-query
Use ADX connector in Power Automate flowshttps://learn.microsoft.com/en-us/azure/data-explorer/flow
Automate ADX queries with Power Automate exampleshttps://learn.microsoft.com/en-us/azure/data-explorer/flow-usage
Configure Grafana integration with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/grafana
Connect Splunk Enterprise to Azure Data Explorer for ingestionhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-splunk
Ingest data from Splunk Universal Forwarder into Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-splunk-uf
Configure Telegraf Azure Data Explorer output pluginhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-telegraf
Use ADX input/output bindings in Azure Functionshttps://learn.microsoft.com/en-us/azure/data-explorer/integrate-azure-functions
Integrate MCP servers with Azure Data Explorer clustershttps://learn.microsoft.com/en-us/azure/data-explorer/integrate-mcp-servers
Configure K2Bridge to use Azure Data Explorer in Kibanahttps://learn.microsoft.com/en-us/azure/data-explorer/k2bridge
Query ADX from Jupyter using Kqlmagichttps://learn.microsoft.com/en-us/azure/data-explorer/kqlmagic
Query ADX as a linked server from SQL Serverhttps://learn.microsoft.com/en-us/azure/data-explorer/linked-server
Run ADX queries via Logic Apps connectorhttps://learn.microsoft.com/en-us/azure/data-explorer/logic-apps
Configure OpenTelemetry collector to ingest into Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/open-telemetry-connector
Build Power Apps that query Azure Data Explorer via connectorhttps://learn.microsoft.com/en-us/azure/data-explorer/power-apps-connector
Integrate Azure Data Explorer with Microsoft Purviewhttps://learn.microsoft.com/en-us/azure/data-explorer/purview
Query Azure Data Explorer using the Python data client libraryhttps://learn.microsoft.com/en-us/azure/data-explorer/python-query-data
Query Azure Data Explorer from MATLAB using authorization tokenshttps://learn.microsoft.com/en-us/azure/data-explorer/query-matlab
Run cross-service queries between Azure Data Explorer and Azure Monitorhttps://learn.microsoft.com/en-us/azure/data-explorer/query-monitor-data
Use Redash native connector with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/redash
Use Serilog sink to stream logs into Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/serilog-sink
Set up Sisense integration with Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/sisense
Run KQL queries and stored functions over TDS from SQL clientshttps://learn.microsoft.com/en-us/azure/data-explorer/sql-kql-queries-and-stored-functions
Connect to Azure Data Explorer using SQL Server emulation (TDS endpoint)https://learn.microsoft.com/en-us/azure/data-explorer/sql-server-emulation-overview
Connect Azure Data Explorer to Tableau via ODBChttps://learn.microsoft.com/en-us/azure/data-explorer/tableau
Debug KQL inline Python plugin code using Visual Studio Codehttps://learn.microsoft.com/en-us/kusto/debug-inline-python?view=microsoft-fabric
主题URL
使用Azure PowerShell Kusto cmdlets管理ADXhttps://learn.microsoft.com/en-us/azure/data-explorer/azure-powershell
通过模拟将常见SQL工具连接到Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/connect-common-apps
配置Azure Data Explorer的JDBC连接https://learn.microsoft.com/en-us/azure/data-explorer/connect-jdbc
设置Azure Data Explorer的ODBC连接https://learn.microsoft.com/en-us/azure/data-explorer/connect-odbc
从Azure Data Explorer查询Azure存储外部表https://learn.microsoft.com/en-us/azure/data-explorer/external-azure-storage-tables-query
在Power Automate流中使用ADX连接器https://learn.microsoft.com/en-us/azure/data-explorer/flow
通过Power Automate示例自动化ADX查询https://learn.microsoft.com/en-us/azure/data-explorer/flow-usage
配置Azure Data Explorer与Grafana的集成https://learn.microsoft.com/en-us/azure/data-explorer/grafana
将Splunk Enterprise连接到Azure Data Explorer进行数据摄入https://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-splunk
将Splunk Universal Forwarder的数据摄入Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-splunk-uf
配置Telegraf Azure Data Explorer输出插件https://learn.microsoft.com/en-us/azure/data-explorer/ingest-data-telegraf
在Azure Functions中使用ADX输入/输出绑定https://learn.microsoft.com/en-us/azure/data-explorer/integrate-azure-functions
将MCP服务器与Azure Data Explorer集群集成https://learn.microsoft.com/en-us/azure/data-explorer/integrate-mcp-servers
配置K2Bridge以在Kibana中使用Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/k2bridge
使用Kqlmagic从Jupyter查询ADXhttps://learn.microsoft.com/en-us/azure/data-explorer/kqlmagic
从SQL Server将ADX作为链接服务器查询https://learn.microsoft.com/en-us/azure/data-explorer/linked-server
通过Logic Apps连接器运行ADX查询https://learn.microsoft.com/en-us/azure/data-explorer/logic-apps
配置OpenTelemetry收集器以将数据摄入Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/open-telemetry-connector
构建通过连接器查询Azure Data Explorer的Power Appshttps://learn.microsoft.com/en-us/azure/data-explorer/power-apps-connector
将Azure Data Explorer与Microsoft Purview集成https://learn.microsoft.com/en-us/azure/data-explorer/purview
使用Python数据客户端库查询Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/python-query-data
使用授权令牌从MATLAB查询Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/query-matlab
在Azure Data Explorer与Azure Monitor之间运行跨服务查询https://learn.microsoft.com/en-us/azure/data-explorer/query-monitor-data
将Redash原生连接器与Azure Data Explorer配合使用https://learn.microsoft.com/en-us/azure/data-explorer/redash
使用Serilog接收器将日志流式传输到Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/serilog-sink
设置Azure Data Explorer与Sisense的集成https://learn.microsoft.com/en-us/azure/data-explorer/sisense
通过SQL客户端的TDS运行KQL查询与存储函数https://learn.microsoft.com/en-us/azure/data-explorer/sql-kql-queries-and-stored-functions
通过SQL Server模拟（TDS终结点）连接到Azure Data Explorerhttps://learn.microsoft.com/en-us/azure/data-explorer/sql-server-emulation-overview
通过ODBC将Azure Data Explorer连接到Tableauhttps://learn.microsoft.com/en-us/azure/data-explorer/tableau
使用Visual Studio Code调试KQL内联Python插件代码https://learn.microsoft.com/en-us/kusto/debug-inline-python?view=microsoft-fabric

Deployment

部署

TopicURL
Automate provisioning of Azure Data Explorer environmentshttps://learn.microsoft.com/en-us/azure/data-explorer/automated-deploy-overview
Use Azure DevOps pipelines for Azure Data Explorer schema deploymenthttps://learn.microsoft.com/en-us/azure/data-explorer/devops
Migrate Azure Data Explorer clusters to availability zoneshttps://learn.microsoft.com/en-us/azure/data-explorer/migrate-cluster-to-multiple-availability-zone
Migrate Azure Data Explorer VNet injection to private endpointshttps://learn.microsoft.com/en-us/azure/data-explorer/security-network-migrate-vnet-to-private-endpoint
主题URL
自动化预配Azure Data Explorer环境https://learn.microsoft.com/en-us/azure/data-explorer/automated-deploy-overview
使用Azure DevOps管道进行Azure Data Explorer架构部署https://learn.microsoft.com/en-us/azure/data-explorer/devops
将Azure Data Explorer集群迁移到可用性区域https://learn.microsoft.com/en-us/azure/data-explorer/migrate-cluster-to-multiple-availability-zone
将Azure Data Explorer从VNet注入迁移到专用终结点https://learn.microsoft.com/en-us/azure/data-explorer/security-network-migrate-vnet-to-private-endpoint