Пропустить и перейти к основному содержимому

General availability: Azure Data Explorer adds support for PostgreSQL, MySQL, and CosmosDB SQL external tables

Дата публикации: 10 июля, 2023

We are excited to announce that Azure Data Explorer now supports three new types of external tables: PostgreSQL, MySQL, and CosmosDB SQL. External tables enable you to query data stored in external data sources as if they were regular tables in Azure Data Explorer, without ingesting or copying the data. This allows you to leverage the power and scalability of Azure Data Explorer to analyze and join data from different sources, while reducing storage and operational costs.

With the new types of external tables, you can now query data PostgreSQL, MySQL, and CosmosDB SQL databases using the familiar Kusto Query Language (KQL). To use external tables, you need to create an external data source that defines the connection details and credentials for the external database, and then create an external table that maps the schema and properties of the external data.

You can find the detailed documentation on how to use external tables here: https://learn.microsoft.com/azure/data-explorer/kusto/management/external-sql-tables

We hope you enjoy this new feature and we welcome your feedback and suggestions on how to improve Azure Data Explorer.

  • Azure Data Explorer
  • Azure Cosmos DB
  • Azure Cosmos DB for PostgreSQL
  • База данных Azure для MySQL
  • Azure Synapse Analytics
  • Features