What object should be added to the share to allow Company B access to the files?

Company A uses Snowflake to manage audio files of call recordings. Company A hired Company B, who also uses Snowflake, to transcribe the audio files for further analysis.

Company A’s Administrator created a share.

What object should be added to the share to allow Company B access to the files?
A . A secure view with a column for file URLs.
B . A secure view with a column for pre-signed URLs.
C . A secure view with a column for METADATA$FILENAME.
D . A secure view with a column for the stage name and a column for the file path.

View Answer

Answer: B

Explanation:

According to the Snowflake documentation1, pre-signed URLs are required to access external files in a share. A secure view can be used to generate pre-signed URLs for the audio files stored in an external stage and expose them to the consumer account.

Option A is incorrect because file URLs alone are not sufficient to access external files in a share.

Option C is incorrect because METADATA$FILENAME only returns the file name, not the full path or URL.

Option D is incorrect because the stage name and file path are not enough to generate pre-signed URLs.