Skip to main content

Event Data Sync Issues in Vitally

Errors syncing event data from Snowflake to Vitally due to timestamp filtering, missing required fields, or duplicate account ID columns.

Cassie avatar
Written by Cassie
Updated over 2 weeks ago

Problem Description:

Users may encounter issues when pulling event data from Snowflake into Vitally. While the sample query runs successfully, data may not appear in Vitally, even after attempting to create a custom object.

Potential Reasons for the Issue:

  1. Incremental Sync Constraints:

  • If the sync has never been run before, there might be no initial reference timestamp.

  1. Incorrect Filtering Conditions:

  • Filtering with $LAST_SYNC_TIMESTAMP may cause events to be excluded.

  • If the WHERE clause is removed but data still doesn’t appear, additional constraints might be affecting the query.

  1. Missing Required Fields:

  • Custom objects require specific columns:

  • timestamp for event occurrence time.

  • object_id as a unique identifier.

  • external_account_ids or external_organization_ids to associate with an account or organization.

  • name to label the object.

  • If any of these fields are empty or unmapped, Vitally may fail to sync them.

  1. Unexpected Sync Errors:

  • Errors displayed in the UI could indicate that required fields are not properly mapped under Accounts, Users, Events, or Custom Objects.

  1. Duplicate Account ID Columns:

  • Having multiple account ID columns in the dataset may cause sync failures.6. Misconfigured Integration Settings:

  • Incorrect integration IDs, such as an invalid Salesforce ID, may prevent events from syncing correctly.


Step-by-Step Solutions:

1. Verify Timestamp Conditions

  • Check the event created date in Snowflake.

  • Ensure the filtering conditions are met if any are set.

  • If the object has never been synced before, try removing the $LAST_SYNC_TIMESTAMP filter and rerun the sync.

2. Review Required Fields for Custom Objects

  • Ensure the following fields are included in the query:

    • timestamp

    • object_id

    • external_account_ids or external_organization_ids

    • name

  • Map all required fields in the Vitally interface.

3. Investigate UI Errors

  • If an error appears at the top of the screen, check if any required fields remain unmapped in:

    • Accounts

    • Users

    • Events

    • Custom Objects

  • Ensure no empty fields exist in these categories.

4. Check for Duplicate Columns

  • Look for duplicate Account ID columns in the dataset.

  • Ensure only one external_account_ids field is present.

5. Re-run the Sync

  • After making necessary adjustments, run the sync again.

  • Verify if events and custom objects now appear in Vitally.

Correcting IDs and Resyncing Events

If you suspect that a Salesforce ID for the integration was configured incorrectly, follow these steps to fix the issue:

  1. Copy the query for the event type you want to resync.

  2. Remove the event from the integration in Vitally.

  3. Update the integration with the corrected ID.

  4. Refresh your browser to ensure updates are reflected.

  5. Recreate the event source for the affected event type.

  6. Paste the previously copied query back into the event source settings.

  7. Save and update the integration.


Additional Tips:

  • Reference Vitally Documentation:

  • Check Sync Logs:

  • Use Vitally’s sync logs to determine if records were processed successfully.

  • Test with a Smaller Dataset:

  • Run queries with a limited dataset to isolate potential issues.- Ensure Correct API Call Usage:

  • Use a Track Call instead of a Group Call to accurately log and sync events. Group Calls are used only for updating trait data, not event information.

  • Always include the full external ID for the entity (e.g., organization or domain) when making a Track Call.


FAQs:

Q: How do I resolve issues caused by incorrect Salesforce IDs?

A: Reconfigure the Salesforce ID and follow the steps to resync events, ensuring all affected sources are updated.

Q: Why are my events not syncing correctly despite updating integration traits?

A: Ensure you are using a Track Call instead of a Group Call for event syncing and include the full external ID in the call.

Q: My data is not appearing in Vitally. What should I check first?

A: Verify that the filters conditions are being met. If syncing for the first time, remove the timestamp filter.

Q: Why are some events missing in Vitally?

A: Check if all required fields (timestamp, object_id, external_account_ids, name) are present and mapped correctly.

Q: What does the sync error at the top of the screen mean?

A: It likely indicates missing required fields. Review field mappings in Accounts, Users, Events, or Custom Objects.

Q: My custom object sync is failing. What could be the issue?

A: Ensure that all required fields are correctly defined and that there are no duplicate Account ID columns.

Q: How can I confirm if my sync worked?

A: Check Vitally’s sync logs to see if events and custom objects were successfully imported.

Did this answer your question?