files

Creates, updates, deletes, gets or lists a files resource.

Overview

Name	files
Type	Resource
Id	snowflake.stage.files

Fields

Name	Datatype	Description
name	string	Name of the file.
last_modified	string	Date and time when the file was last modified.
md5	string	md5 hash of the file.
size	string	Size of the file.

Methods

Name	Accessible by	Required Params	Description
list_files	SELECT	database_name, name, schema_name, endpoint	List files in the stage -- this is equivalent to LIST @stage.

SELECT examples

List files in the stage -- this is equivalent to LIST @stage.

SELECT
name,
last_modified,
md5,
size
FROM snowflake.stage.files
WHERE database_name = '{{ database_name }}'
AND name = '{{ name }}'
AND schema_name = '{{ schema_name }}'
AND endpoint = '{{ endpoint }}';