QuestionQ26Verified/Ingest and Process DataCopy linkReport a problemAsk AstroTutorSave questionHow can a directory table be used while working with unstructured data?Choose twoAFile access URLs can be shared with collaborators and partners.BData stored in an external stage can be queried as if the data was inside a table in Snowflake.CAll unstructured files on a stage can be queried using the SELECT * FROM DIRECTORY(@); command.DAll unstructured files on a stage can be queried using the SELECT * FROM @; command.EA directory table can be joined with other tables to produce a view of unstructured data that combines the file URLs with the file metadata.Show AnswerAnswerExplanationA Snowflake directory table provides file-level metadata for a stage and can be queried using SELECT * FROM DIRECTORY(@stage_name). Its results can be joined with other tables to create a view that combines file URLs with related file metadata.Learn moreQuery directory tablesDirectory tablesShow comments1Show commentsCommunity DiscussionNo comments yet. Be the first to start the discussion!
Community Discussion