QuestionQ61

Load and leverage structured, semi-structured, and unstructured data

Which schema-level Snowflake object is required to query a directory table for unstructured data?

Explanation

A directory table is associated with a stage and stores file-level metadata for the files on that stage. Directory-table queries use the DIRECTORY(@stage_name) function, so a stage with its directory table enabled is required.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!