
Explanation:
The question asks for an object that identifies the database, schema, stage, and file path to files and allows access to roles with stage privileges. A file URL in Snowflake serves this exact purpose - it provides the complete path structure (database.schema.stage/file_path) and access is controlled through role privileges on the stage. The community discussion strongly supports this with 100% consensus for option B, multiple comments confirming it's the correct answer, and references to Snowflake documentation. Option A (scoped URL) is not a standard Snowflake term for file access. Option C (pre-signed URL) is typically used for temporary external access, not internal Snowflake role-based access. Option D (directory table) is used for querying staged files but doesn't inherently provide the path identification and access mechanism described.
Ultimate access to all questions.
Which object can be used to identify the database, schema, stage, and file path for a set of files, and to grant access to those files to a role with the necessary privileges on the stage?
A
A scoped URL
B
A file URL
C
A pre-signed URL
D
A directory table
No comments yet.