External tables

An external table is a Kusto schema entity that references data stored outside the Azure Data Explorer database.

Similar to tables, an external table has a well-defined schema (an ordered list of column name and data type pairs). Unlike tables where data is ingested into Azure Data Explorer cluster, external tables operate on data stored and managed outside Azure Data Explorer cluster.

Supported external data stores are:

  • Files stored in Azure Blob Storage or in Azure Data Lake. Most commonly the data is stored in some standard format such as CSV, JSON, Parquet, AVRO, etc. For the list of supported formats, refer to supported formats.
  • SQL Server table.

See the following ways of creating external tables:

An external table can be referenced by its name using the external_table() function.

Use the following commands to manage external tables:

For more information about how to query external tables, and ingested and uningested data, see how to query data in Azure Data Lake using Azure Data Explore.

Notes

  • External table names:
    • Case-sensitive.
    • Can’t overlap with Kusto table names.
    • Follow the rules for entity names.
  • Maximum limit of external tables per database is 1,000.
  • Kusto supports export and continuous export to an external table.
  • Data purge isn't applied on external tables. Records are never deleted from external tables.