Contact reporting workflow
Planning example. Stacksync support for the required connection and record operations needs a technical review.
Starting event: A change to the selected Proposed contact table in Snowflake (choose its name) or Contacts record needs a defined result in the other system.
- Start with Snowflake Proposed contact table in Snowflake (choose its name) and Wrike Contacts. Use the record-matching and field-ownership rules from your mapping worksheet.
- Resolve the organization relationship and any owner or consent references required by the destination.
- Test a normal update and one failed or repeated update in the supported direction. Keep both record IDs with the test results.
Expected result: Test an email change, two records sharing an email, and a person associated with multiple organizations.
If it fails: Hold ambiguous matches for review and reconcile the person ID before retrying; preserve the consent decision already recorded by its owner.
Task or work item reporting workflow
Planning example. Stacksync support for the required connection and record operations needs a technical review.
Starting event: A change to the selected Proposed task or work item table in Snowflake (choose its name) or Tasks record needs a defined result in the other system.
- Start with Snowflake Proposed task or work item table in Snowflake (choose its name) and Wrike Tasks. Use the record-matching and field-ownership rules from your mapping worksheet.
- Resolve project, user, and parent-item references before the task.
- Test a normal update and one failed or repeated update in the supported direction. Keep both record IDs with the test results.
Expected result: Test a reassignment, an unsupported status transition, a deleted parent, and a due date across time zones.
If it fails: Reconcile the destination state before retrying a transition to avoid reopening completed work.
Define an explicit handoff between Snowflake and Wrike
This is an evaluation scenario; connector and operation support require confirmation.
Starting event: A business event involving a selected business dataset needs a defined response involving Tasks or Contacts.
- Document what the source event means and which destination record or action should respond. A similar name does not establish a shared entity.
- Retain separate IDs and choose whether the destination is a report, a new work item, or a change to an existing record.
- Assign an approval owner and a duplicate-detection rule before running an action. Use a custom workflow only after its endpoint support is confirmed.
Expected result: An example input has an unambiguous destination and expected result; repeated delivery produces only the intended change.
If it fails: Resolve missing identity or ambiguous business meaning before retrying; route unsupported operations to the implementation owner.