跳到主要内容

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' |
+-----------+------+------+-------------------------------+--------------------+