时间戳

首页 > 解决方案 > Load data from an existing View to table in Snowflake and shcedule it to run everyday - incremental

snowflake-cloud-data-platform - Load data from an existing View to table in Snowflake and shcedule it to run everyday - incremental

问题描述

I'm new to snowflake and I have to Load data from an existing View to table in Snowflake and also, need to shcedule it to run everyday - incremental.

How to achieve it in snowflake.Suggestions required.

标签： snowflake-cloud-data-platformsnowflake-schema

解决方案

你需要

  • 创建一个存储过程，从视图中插入/合并到表中，实现您需要应用的任何业务逻辑
  • 创建一个运行 SP 的任务
  • 为任务添加计划

推荐阅读