跳到主要内容

LIST FILES IN STAGE

Syntax

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

Where:

  internalStage ::= @<internal_stage_name>
  externalStage ::= @<external_stage_name>

Examples

list @named_external_stage PATTERN = 'ontime.*parquet';
+-----------------------+
| file_name |
+-----------------------+
| ontime_200.parquet |
| ontime_200_v1.parquet |
+-----------------------+