Ignorez la navigation

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

Date de publication : 10 juillet, 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.

  • Explorateur de données Azure
  • Azure Cosmos DB
  • Azure Cosmos DB for PostgreSQL
  • Base de données Azure pour MySQL
  • Azure Synapse Analytics
  • Features