Missing rows in user roles table during Salesforce to Snowflake sync

Summary

Salesforce to Snowflake sync is missing some rows in the user roles table despite running a full refresh overwrite. User suspects it’s not a permission issue as most data is syncing successfully. Running on helm.


Question

I have a salesforce to snowflake sync running and everything seems to be working except I’ve noticed that my user roles table is missing a couple rows. I don’t think it’s a permission issue because about 90% of the data is syncing over. I changed it to a full refresh overwrite and still no luck. Has anyone else had this? I’m running on helm right now



This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

["salesforce", "snowflake", "sync", "user-roles", "full-refresh", "missing-rows", "permission", "helm"]