While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
While working with unstructured data, which file function generates a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs?
The correct function to generate a Snowflake-hosted file URL to a staged file using the stage name and relative file path as inputs is BUILD_STAGE_FILE_URL. This function is specifically designed for this purpose in the context of working with unstructured data in Snowflake.
https://docs.snowflake.com/en/sql-reference/functions/build_stage_file_url
For this question, answers AC are both correct in my opinion.
Change to A "Snowflake file URL" is a SCOPED