Hi all, does anyone know how using a Fivetran task...
# ask-communitym
Madison Schott
08/02/2021, 8:05 PMHi all, does anyone know how using a Fivetran task changes the Fivetran sync schedule of your connectors? Not sure if it's a coincidence but I just noticed that the tables I was testing using Prefect haven't been synced on my Fivetran UI in 6 days. Normally I have the schedule set to sync every 24 hours.
k
Kevin Kho
08/02/2021, 8:11 PM
Hey @Madison Schott, I am not so familiar with Fivetran but I guess you might be right reading the source there is this section.
Kevin Kho
08/02/2021, 8:12 PM
Does that look like what you’re mentioning?
m
Mark McDonald
08/02/2021, 8:17 PMI noticed this as well when I was playing with the task. It's not ideal, but sounds like a requirement on Fivetran's side
m
Madison Schott
08/02/2021, 9:05 PMAh yeah it does
Madison Schott
08/02/2021, 9:06 PM@Mark McDonald do you know if there's a way to reset it? I was testing but had to stop and now our data isn'y syncing
m
Mark McDonald
08/02/2021, 9:10 PMyea, you have to do it through the api, I think
Mark McDonald
08/02/2021, 9:10 PMyou'll set schedule_type to auto
Mark McDonald
08/02/2021, 9:10 PMhang on - let me see
Mark McDonald
08/02/2021, 9:14 PMit's basically the reverse of these instructions: https://fivetran.com/docs/rest-api/connectors#usecasehowtotriggersyncsonlywhenyouneedthem
Mark McDonald
08/02/2021, 9:14 PMso, it's something like this:
Copy code
import requests
connector_id = "some_connector"
connector_endpoint = f"<https://api.fivetran.com/v1/connectors/{connector_id}>"
requests.patch(connector_endpoint, params={"schedule_type": "auto"}, auth=(API_KEY, API_SECRET))👍 1
c
Chris White
08/02/2021, 11:09 PM
@Marvin archive "Using Fivetran task modifies sync schedule"
👍 1
m
Marvin
08/02/2021, 11:09 PM5 Views