Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

Question

Options

• Alist @bronzestage;
• Bselect * from directory(@bronzestage);
• Cselect metadata$filename from @bronzestage;
• Dselect * from table(information_schema.stage_directory_file_registration_history( stage

• A
  9% (2)
• B
  87% (20)
• D
  4% (1)

Explanation

The DIRECTORY() table function queries the directory table associated with a named stage and returns metadata about staged files, including the Snowflake-hosted file URL (a pre-signed URL in the FILE_URL column). This URL allows access to the file through Snowflake's infrastructure. The LIST command (A) shows file paths but not hosted URLs. Querying metadata$filename (C) returns relative paths within the stage. The information_schema function (D) returns file registration history, not current directory contents with hosted URLs.

No community discussion yet for this question.