https://prefect.io
Join Slack
Hi all, does anyone know how using a Fivetran task changes the Fivetran sync schedule of your connec...
# ask-community
m
Hi 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
Hey @Madison Schott, I am not so familiar with Fivetran but I guess you might be right reading the source there is this section.
Does that look like what you’re mentioning?
m
I 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
Ah yeah it does
@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
yea, you have to do it through the api, I think
you'll set schedule_type to auto
hang on - let me see
so, 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
@Marvin archive "Using Fivetran task modifies sync schedule"
👍 1
m
4 Views
Open in Slack
PreviousNext
Powered by

Prefect Community

Bring your towel and join one of the fastest growing data communities. Welcome to our second-generation open source orchestration platform, a completely rethought approach to dataflow automation.

Powered by