Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?
Which function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire?
The function that generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs, with a file URL that does not expire is BUILD_STAGE_FILE_URL. This function takes the stage name and the relative file path and constructs the appropriate URL without an expiration.
B example: SELECT BUILD_STAGE_FILE_URL('mystage', 'path/to/file.csv') AS file_url;
bbbbbbbbb
B. BUILD_STAGE_FILE_URL(stage_name, relative_file_path)