Skip to main content

Community

Connector Improvement: Option to set sync frequency to more then 24 hours

Completed

Please sign in to leave a comment.

Comments

4 comments

  • Official comment
    Alexander User

    Thanks, Karan! This functionality is available through the REST API - check it out here. I'm curious to learn more about your use case. We typically recommend customers sync data frequently. We only charge for the changes so the effect on your bill is minimal and the benefit to data freshness and sync reliability is important. For that reason, we plan to continue making this functionality available through the REST API but not in the user interface, where we try to keep things simple and guide people to good choices for most people.

    Hi Alexander,

    If we go with API approach to run a sync job, will the standard sync disabled? 

    My requirement is to run 1st and 15th of every month. As Fivetran doesn't support cron expressions, I will be using external tools to call Fivetran API (https://api.fivetran.com/v1/connectors/{connector_id}/force).

    In this case, I want to disable standard sync so that it won't run daily once. Is it possible?

     

    Thanks

    Sravani

  • Alexa Maturana-Lowe User

    Yes Sravani Jagarlamudi - This section of the docs outlines how this will work. https://fivetran.com/docs/rest-api/connectors#usecasehowtotriggersyncsonlywhenyouneedthem

    Whilst it's clear we can manually trigger syncs longer than 24h with a CRON job, it would be great to see longer sync built-in to Fivetran.

    I imagine common use cases would be:

    • 2 days
    • 3 days
    • Daily, weekly (skip weekends)
    • Weekly (e.g. once on Monday)