Troubleshooting Mirror Sync with Snowflake and Mixpanel Event Sync Issues
I'm using mirror sync with snowflake and I see the data history sync is done but the mixpanel synced events is still 0
Hi Tal, Please stand by as I search the Mixpanel knowledge base for an AI-powered answer. I normally take about 15 seconds or so. In case AI cannot answer your question, feel free to reach out to Mixpanel support at mixpanel.com/get-support. If you have follow-up questions for this thread, please tag me again with your question: @kapa.ai <follow-up question> đź‘‹
Feel free to ask a follow-up question once I've answered by mentioning me with @kapa.ai
Based on the information provided in the knowledge sources, there could be a few reasons why you're seeing 0 synced events in Mixpanel even though the data history sync with Snowflake using mirror sync is complete. Here are some potential explanations and things to check: 1. Data Delay: According to the Data Pipelines FAQ, it can take up to 24 hours for data to sync from Mixpanel to your destination. This delay applies to late-arriving data as well.2. Sync Frequency: Check your sync frequency settings. If you've just set up the sync, it might take some time for the first sync to complete and for the data to appear in Mixpanel. The Sync Frequency documentation outlines various options, including hourly, daily, and weekly syncs.3. Data Sync Configuration: Ensure that Data Sync is enabled for your pipeline. This feature helps keep the data fresh and minimizes missing data points.4. Mirror Sync Considerations: Review the Mirror sync considerations for Snowflake. Make sure that change tracking is enabled on your Snowflake table or view:
```LBKSLBKS Also, ensure that your sync hasn't gone longer than the data retention period set by DATA_RETENTION_TIME_IN_DAYS or MAX_DATA_EXTENSION_TIME_IN_DAYS (default is 14 days).LBKS5. Schema Changes: If you've made any schema changes to your Snowflake table, be aware that some changes might not be reflected in historical data due to how Snowflake streams work with Mirror sync.LBKS6. Verify Data in Snowflake: Double-check that the data you expect to see in Mixpanel is actually present in your Snowflake table and that it meets the required schema for events in Mixpanel.LBKSIf you've checked all these points and still don't see any synced events, it might be worth contacting Mixpanel support for further assistance. They can help investigate any potential issues with your specific setup.kapa.ai is still learning and improving, please let me know how I did by reacting below.
ℹ️ Tip: Mention @kapa.ai in the thread for follow-ups or DM the app for 1-to-1 help.