Which connector?:

SurveyMonkey

Additional details:

We currently use the SurveyMonkey connector with an automated sync scheduled every 6 hours.

Certain surveys, specifically our Brand Tracker surveys, undergo a monthly data-cleaning process during which low-quality responses are permanently deleted from SurveyMonkey. However, since Fivetran syncs these responses before the cleanup is completed, the deleted responses may continue to exist in our Snowflake destination, resulting in discrepancies between SurveyMonkey and our downstream reporting.

We'd like to explore whether it's possible to configure survey-specific sync schedules or date-based ingestion filters, allowing us to ingest data from selected surveys only after their monthly cleaning process is complete, while maintaining the existing 6-hour sync schedule for all other surveys.

Alternatively, is there a way to automatically reconcile deleted responses after the monthly cleanup without requiring a manual historical re-sync?

Ideally, we're looking for an automated solution that ensures our destination reflects the finalized SurveyMonkey data without disrupting the existing sync process.