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