File Functions

File functions enable you to access files staged in cloud storage.

In this Topic:

List of Functions

Function Name

Notes

Returns the URL for an external or internal named stage using the stage name as the input.

Extracts the path of a staged file relative to its location in the stage using the stage name and absolute file path in cloud storage as inputs.

Returns the absolute path of a staged file using the stage name and path of the file relative to its location in the stage as inputs.

Generates the pre-signed URL to a staged file using the stage name and relative file path as inputs. Access files in an external stage using the function.

Generates a scoped Snowflake-hosted URL to a staged file using the stage name and relative file path as inputs.

Generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs.

Usage Notes

  • GET_PRESIGNED_URL and BUILD_SCOPED_FILE_URL are non-deterministic functions; the others are deterministic.