show-external-table-artifacts.md

title	description	ms.topic	ms.date
.show external table artifacts command	Learn how to use the `.show external table artifacts` command to show external table artifacts for Azure Blob Storage or Azure Data Lake external tables.	reference	08/11/2024

Show external table artifacts command

[!INCLUDE applies] [!INCLUDE fabric] [!INCLUDE 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]

[!INCLUDE syntax-conventions-note]

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"}