LIST¶

Returns a list of files from one of the following Snowflake storage features:

• 暂存区

  • 已命名的内部暂存区。
  • 已命名的外部暂存区。
  • 指定表的暂存区。
  • 当前用户的暂存区。

• Git repository clone in Snowflake

LIST 可以缩写为 LS。

See also:

REMOVE, PUT, COPY INTO <table>, COPY INTO <location>, GET

语法

The syntax differs depending on whether you’re listing files in a stage or a Git repository clone.

For a stage¶

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

其中：

Copy codeExpand code block

internalStage ::=
    @[<namespace>.]<int_stage_name>[/<path>]
  | @[<namespace>.]%<table_name>[/<path>]
  | @~[/<path>]

Show lessSee more

Scroll to top

Copy codeExpand code block

externalStage ::=
  @[<namespace>.]<ext_stage_name>[/<path>]

Show lessSee more

Scroll to top

For a Git repository clone¶

LIST repositoryClone [ PATTERN = '<regex_pattern>' ]

其中：

Copy codeExpand code block

repositoryClone ::=
  @[<namespace>.]<repository_clone>/<path>

Show lessSee more

Scroll to top

必填参数

For a stage¶

internalStage | externalStage

指定暂存数据文件的位置：

@[namespace.]int_stage_name[/path]	Files are in the specified named internal stage.
@[namespace.]ext_stage_name[/path]	Files are in the specified named external stage.
@[namespace.]%table_name[/path]	Files are in the stage for the specified table.
@~[/path]	Files are in the stage for the current user.
Where:
- namespace is the database and/or schema in which the named stage or table resides. It is optional if a database and
schema are currently in use within the session; otherwise, it is required.
- path is an optional case-sensitive path for files in the cloud storage location (i.e. files have names that begin with a
common string) that limits access to a set of files. Paths are alternatively called prefixes or folders by different cloud storage
services.
If the stage name or path includes spaces or special characters, it must be enclosed in single quotes (e.g. '@"my stage"' for a
stage named "my stage").
Specifying a path provides a scope for the LIST command, potentially reducing the amount of time required to run the command.

Expand

Show lessSee more

For a Git repository clone¶

repositoryClone

Specifies the name of the repository clone and the branch, tag, or commit for which to list files.

@[namespace.]repository_clone/path

When listing files from a Git repository clone, the path is required and must begin with one of the following:

branches/branch_name	List files from the specified branch.
tags/tag_name	List files from the specified tag.
commits/commit_hash	List files from the commit specified by the commit hash.
If the repository clone name or path includes spaces or special characters, it must be enclosed in single quotes (for example,
'@"my repository"' for a repository named "my repository").

Expand

Show lessSee more

可选参数

PATTERN = 'regex_pattern'

Specifies a regular expression pattern for filtering files from the output. The command lists all files in the specified path and applies the regular expression pattern on each of the files found.

使用说明

• To run this command with an external stage that uses a storage integration, you must use a role that has or inherits the USAGE privilege on the storage integration.

  For more information, see Stage privileges.

• In contrast to named stages, table and user stages are not first-class database objects; rather, they are implicit stages associated with the table/user. As such, they have no grantable privileges of their own:
  • 您始终可以在用户暂存区列出文件（即不需要任何权限）。
  • 要列出表暂存区中的文件，必须使用对表具有 OWNERSHIP 权限的角色。
  • PATTERN supports the Java Pattern class (https://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html) syntax.

输出

The command returns columns in the following tables. Column values differ depending on whether you’re using LIST with a stage or Git repository clone.

For a stage¶

For a Git repository clone¶

示例

For a stage¶

List all the files in the stage for the mytable table:

LIST @%mytable;

List all the files in the path1 path of the mystage named stage:

LIST @mystage/path1;

List the files that match a regular expression (i.e. all file names containing the string data_0) in the stage for the mytable table:

LIST @%mytable PATTERN='.*data_0.*';

List the files in the /analysis/ path of the my_csv_stage named stage that match a regular expression (i.e. all file names containing the string data_0):

LIST @my_csv_stage/analysis/ PATTERN='.*data_0.*';

使用命令的缩写形式列出当前用户在暂存区中的所有文件：

LS @~;

For a Git repository clone¶

For examples, see View a list of repository files.