Show external table artifacts command

Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer

This article describes how to show all files that will be processed when querying a given external table.

Permissions

You must have Database User permissions to run this command.

Syntax

.show external table ExternalTableName artifacts [limit MaxResults]

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
ExternalTableName	string	✔️	The name of the external table.
MaxResults	int		The maximum number of results to return.

Tip

Iterating over all files referenced by an external table can be quite costly, depending on the number of files. Make sure to use limit parameter if you just want to see some URI examples.

Returns

Output parameter	Type	Description
Uri	string	URI of external storage data file
Size	long	File length in bytes
Partition	dynamic	Dynamic object describing file partitions for partitioned external table

Example

.show external table T artifacts

Output

Uri	Size	Partition
https://storageaccount.blob.core.windows.net/container1/folder/file.csv	10743	{}

For partitioned table, Partition column will contain extracted partition values:

Output

Uri	Size	Partition
https://storageaccount.blob.core.windows.net/container1/customer=john.doe/dt=20200101/file.csv	10743	{"Customer": "john.doe", "Date": "2020-01-01T00:00:00.0000000Z"}