Show external table artifacts command

  • Article

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.chinacloudapi.cn/container1/folder/file.csv 10743 {}

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

Output

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