Snowflake 架构
Emily Melhuish
Technical Curriculum Developer, Snowflake



VARIANT 列中的文本)SQL
SELECT SNOWFLAKE.CORTEX.PARSE_DOCUMENT(
@snowy_peak_files_stage,
'patrol_report.pdf',
{'mode': 'LAYOUT'}
):content::STRING AS report_text;
VARIANT):用 : 与 :: 提取文本PARSE_DOCUMENT:处理文件的常见第一步COMPLETE
SELECT SNOWFLAKE.CORTEX.COMPLETE(
'claude-3-5-sonnet',
'Summarise this patrol report and flag any safety actions required:'
|| report_text
) AS summary;
SUMMARIZE
SELECT SNOWFLAKE.CORTEX.SUMMARIZE(report_text) AS report_digest
FROM snowy_peak_patrol_reports;
COMPLETE
SELECT SNOWFLAKE.CORTEX.COMPLETE(
'claude-3-5-sonnet',
'Summarise this patrol report and flag any safety actions required:'
|| report_text
) AS summary;
SUMMARIZE
SELECT SNOWFLAKE.CORTEX.SUMMARIZE(report_text) AS report_digest
FROM snowy_peak_patrol_reports;
Cortex Search
Cortex Analyst

CREATE OR REPLACE SNOWFLAKE.ML.FORECAST 创建预测模型CALL my_model!FORECAST() 生成未来周期Snowflake 架构