LIST STAGE FILES

Returns a list of the staged files in a stage (i.e. uploaded from a local file system).

Syntax

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

Examples

LIST @my_int_stage;
+-----------+------+------+-------------------------------+--------------------+
| name      | size | md5  | last_modified                 | creator            |
+-----------+------+------+-------------------------------+--------------------+
| books.csv |   91 | NULL | 2022-06-10 12:01:40.000 +0000 | 'root'@'127.0.0.1' |
+-----------+------+------+-------------------------------+--------------------+