List files in a stage

Syntax

LIST { internalStage | externalStage } [ PATTERN = '<regex_pattern>' ]

Where:

  internalStage ::= @<internal_stage_name>

  externalStage ::= @<external_stage_name>

Examples

mysql>

list @named_external_stage PATTERN = 'ontime.*parquet';

+-----------------------+
| file_name             |
+-----------------------+
| ontime_200.parquet    |
| ontime_200_v1.parquet |
+-----------------------+