To automatically schedule all imports to happen at 05:00 UTC:
CREATE OR REPLACE TASK import_snapshots_task
WAREHOUSE = 'COMPUTE_WH'
SCHEDULE = 'USING CRON 0 5 * * * UTC'
AS
BEGIN
CALL import_releases_simplified();
CALL import_actors();
CALL import_users();
CALL import_shops();
CALL import_products();
CALL import_subscriptions();
END;
<aside> <img src="/icons/drafts_blue.svg" alt="/icons/drafts_blue.svg" width="40px" />
In this case, we use the default warehouse for Beat’s Snowflake instance, called COMPUTE_WH
. You may need to adapt this to a warehouse you have access to.
</aside>