TRY_TO_FILE¶

Syntax¶

Use one of the following:

TRY_TO_FILE( <stage_name>, <relative_path> )

TRY_TO_FILE( <file_url> )

TRY_TO_FILE( <metadata> )

Arguments¶

stage_name

The name of the stage where the file is located, as a string, in the form '@stage_name'.

relative_path

The path to the file on the stage specified by stage_name as a string.

file_url

A valid stage or scoped file URL as a string.

metadata

An OBJECT containing the required FILE metadata. A FILE must have CONTENT_TYPE, SIZE, ETAG, and LAST_MODIFIED fields. It must also specify the file’s location in one of the following ways:

• Both STAGE and RELATIVE_PATH

• STAGE_FILE_URL

• SCOPED_FILE_URL

Returns¶

A FILE, or NULL.

Usage notes¶

Returns NULL when:

• The supplied URL is not validL.

• The file is on a stage that the user has no permissions to access.

• The supplied metadata doesn’t contain the required FILE fields.

Examples¶

See TO_FILE.