# SHOW STAGE FILES

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_name`: The ID or name of the deployment in which the Stage is attached.
* `path`: A path in the Stage.
* `pattern`: Specifies a pattern similar to the SQL `LIKE` clause 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.&#x20;

## Remarks

* The `LIMIT` clause limits the number of results to the specified number.
* By default, the result is sorted in the ascending order.
* The `IN` and `IN GROUP` clauses specify the ID or name of the deployment (workspace group) in which the Stage is attached.
* Specify the `RECURSIVE` clause to list the files recursively.
* Specify the `EXTENDED` clause to return more information on the files.

## Example

The following command lists the files at the specified path with additional information:

```sql
SHOW STAGE FILES IN 's2wsg' AT "/data/" EXTENDED;
```

***

Modified at: August 4, 2025

Source: [/cloud/reference/fusion-sql/show-stage-files/](https://docs.singlestore.com/cloud/reference/fusion-sql/show-stage-files/)

(An index of the documentation is available at /llms.txt)