SHOW STAGE FILES
On this page
Returns a list of files in the Stage.
Syntax
SHOW STAGE FILES [ { IN GROUP { ID '<deployment_ID>' | '<deployment_name>' } | IN { ID '<deployment_ID>' | '<deployment_name>' } } ]
[ AT '<path>' ] [ LIKE '<pattern>' ]
[ ORDER BY '<key>' [ ASC | DESC ],... ]
[ LIMIT <limit> ] [ RECURSIVE ] [ EXTENDED ]Arguments
-
deployment_,ID deployment_: The ID or name of the deployment in which the Stage is attached.name -
path: A path in the Stage. -
pattern: Specifies a pattern similar to the SQLLIKEclause and returns files with names that match the specified pattern.Uses %as the wildcard character. -
key: Key used to sort the result set. -
limit: An integer value.
Remarks
-
The
LIMITclause limits the number of results to the specified number. -
By default, the result is sorted in the ascending order.
-
The
INandIN GROUPclauses specify the ID or name of the deployment (workspace group) in which the Stage is attached. -
Specify the
RECURSIVEclause to list the files recursively. -
Specify the
EXTENDEDclause to return more information on the files.
Example
The following command lists the files at the specified path with additional information:
SHOW STAGE FILES IN 's2wsg' AT "/data/" EXTENDED;
Last modified: August 4, 2025