.show continuous-export exported-artifacts
Returns all artifacts exported by the continuous-export in all runs. Filter the results by the Timestamp column in the command to view only records of interest. The history of exported artifacts is retained for 14 days.
The command doesn’t return any results if executed on a follower database, it must be executed against the leader database.
The command doesn’t return any results if executed on a database shortcut, it must be executed against the leader database.
Permissions
You must have at least Database Monitor or Database Admin permissions to run this command. For more information, see role-based access control.
Syntax
.show continuous-export ContinuousExportName exported-artifacts
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| ContinuousExportName | string | ✔️ | The name of the continuous export. |
Returns
| Output parameter | Type | Description |
|---|---|---|
| Timestamp | datetime | THe tTimestamp of the continuous export run |
| ExternalTableName | string | Name of the external table |
| Path | string | Output path |
| NumRecords | long | Number of records exported to path |
Example
The following example shows retrieved artifacts from the continuous export MyExport that were exported within the last hour.
.show continuous-export MyExport exported-artifacts | where Timestamp > ago(1h)
Output
| Timestamp | ExternalTableName | Path | NumRecords | SizeInBytes |
|---|---|---|---|---|
| 2018-12-20 07:31:30.2634216 | ExternalBlob | http://storageaccount.blob.core.windows.net/container1/1_6ca073fd4c8740ec9a2f574eaa98f579.csv | 10 | 1024 |
Related content
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.