How can a directory table be used while working with unstructured data?
A 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.
SELECT * FROM DIRECTORY(@stage_name)
Community Discussion