Share metadata for last 180 days

After the 180‑day data‑sharing load is complete, communicate the details to Unravel so Unravel can configure and start polling data.

Share delta metadata from Step 1 to current date.

Calculate the delta days using the dates when you ran Step 1 and when you plan to run Step 3:

delta days = (Step 3 date − Step 1 date) + 1

For example, if Step 1 ran on 02‑Jan and Step 3 runs on 04‑Jan, delta days = (4 − 2) + 1 = 3. Use that delta days value in the following procedure calls (replace 3 in this example with your calculated value).

CALL REPLICATE_ACCOUNT_USAGE('UNRAVEL_SHARE','SCHEMA_4827_T', 3);
CALL REPLICATE_HISTORY_QUERY('UNRAVEL_SHARE','SCHEMA_4827_T', 3);
CALL WAREHOUSE_PROC('UNRAVEL_SHARE','SCHEMA_4827_T');
CALL CREATE_QUERY_PROFILE('UNRAVEL_SHARE', 'SCHEMA_4827_T', '1', '3');
CALL create_shared_db_metadata('UNRAVEL_SHARE','SCHEMA_4827_T');

After the delta data sharing in Step 3, communicate to Unravel. Unravel will initiate delta data loading.

Run the following statements to create and resume Snowflake tasks for continuous sharing, using schedules that meet your requirements.

CREATE OR REPLACE TASK replicate_metadata WAREHOUSE = UNRAVELDATA SCHEDULE = 'USING CRON 0 3,9,15,21 * * * UTC'
AS
CALL REPLICATE_ACCOUNT_USAGE('UNRAVEL_SHARE','SCHEMA_4827_T',2);

CREATE OR REPLACE TASK replicate_history_query
 WAREHOUSE = UNRAVELDATA
 SCHEDULE = '60 MINUTE'
AS
CALL REPLICATE_HISTORY_QUERY('UNRAVEL_SHARE','SCHEMA_4827_T',2);

CREATE OR REPLACE TASK createProfileTable
 WAREHOUSE = UNRAVELDATA
 SCHEDULE = '60 MINUTE'
AS
CALL create_query_profile('UNRAVEL_SHARE', 'SCHEMA_4827_T', '1', '2');

CREATE OR REPLACE TASK replicate_warehouse_and_realtime_query
 WAREHOUSE = UNRAVELDATA
 SCHEDULE = '720 MINUTE'
AS
BEGIN
    CALL warehouse_proc('UNRAVEL_SHARE','SCHEMA_4827_T');
END;

CREATE OR REPLACE TASK shared_db_metadata_task
 WAREHOUSE = UNRAVELDATA
 SCHEDULE = '720 MINUTE'
AS
BEGIN
    CALL create_shared_db_metadata('UNRAVEL_SHARE','SCHEMA_4827_T');
END;

/**
  (Resume all TASKS)
**/
ALTER TASK replicate_metadata RESUME;
ALTER TASK replicate_history_query RESUME;
ALTER TASK createProfileTable RESUME;
ALTER TASK replicate_warehouse_and_realtime_query RESUME;
ALTER TASK shared_db_metadata_task RESUME;

When continuous data sharing is stable and validated, communicate to Unravel. Unravel will make the SaaS account live.