Show external table artifacts command
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"} |
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for