Source
How to use the hyphenated (dashed) format of the Snowsight regionless privatelink URL?
How to use the hyphenated (dashed) format of the Snowsight regionless privatelink URL?
PARSE_URL
Returns an OBJECT value that consists of all the components (fragment, host, parameters, path, port, query, scheme) in a valid input URL/URI.
When trying to access a URL generated using the function get_presigned_url for a non-existing files, the error "NoSuchKey" is raised
ISSUE: When you are trying to access a non - existing file from an internal or external stage using the URL generated as part of the function GET_PRESIGNED_URL, you get NoSuchKey error.
How to decode URL values in Snowflake
CAUSE: URL decoding is currently not supported in Snowflake. SOLUTION: As a workaround, a Javascript function can be used to decode the URL before being passed to the PARSE_URL function.
BUILD_SCOPED_FILE_URL
Generates a scoped Snowflake file URL to a staged file using the stage name and relative file path as inputs. A scoped URL is encoded and permits access to a specified file for a limited period of time.