.show external table command

  • Article

Applies to: ✅ Azure Data Explorer

Returns a specified external table or all external tables in the database.

This command is relevant to any external table of any type. For an overview of external tables, see external tables.

Permissions

You must have at least Database User, Database Viewer, Database Monitor to run these commands. For more information, see role-based access control.

Syntax

.show external tables

.show external table TableName

Learn more about syntax conventions.

Parameters

Name Type Required Description
TableName string ✔️ The name of the external table to show.

Returns

Output parameter Type Description
TableName string Name of external table
TableType string Type of external table
Folder string Table's folder
DocString string String documenting the table
Properties string Table's JSON serialized properties (specific to the type of table)

Example

.show external tables
.show external table T
TableName TableType Folder DocString Properties
T Blob ExternalTables Docs {}