Snowflake 架构
Emily Melhuish
Technical Curriculum Developer, Snowflake


外部:云端文件
非结构化数据存放于阶段

启用 DIRECTORY
CREATE STAGE snowy_peak_files_stage
DIRECTORY = (ENABLE = TRUE);
刷新目录元数据(ALTER STAGE)
ALTER STAGE snowy_peak_files_stage REFRESH;

SQL
SELECT
file_name
, size
, last_modified
FROM DIRECTORY(@snowy_peak_files_stage);
SQL
SELECT GET_PRESIGNED_URL(@snowy_peak_files_stage, 'avalanche_forecast.pdf', 3600);
传入阶段、文件路径和有效期(秒)
适用于无 Snowflake 登录的合作方
Snowflake 架构