Snowflake-arkitektur
Emily Melhuish
Technical Curriculum Developer, Snowflake


Extern: Filer i molnet
Ostrukturerad data lagras i en stage

ENABLE DIRECTORY
CREATE STAGE snowy_peak_files_stage
DIRECTORY = (ENABLE = TRUE);
Uppdatera katalogmetadata (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);
Ange stage, filsökväg och livstid i sekunder
Användbart för partners utan Snowflake-inloggning
Snowflake-arkitektur