Why Does My Connector Take a Long Time to Sync?

Question

Why does my connector take a long time to sync?

Environment

Connector: Twilio

Answer

Your syncs may take longer than usual for any of the three following reasons:

The FLOW_HISTORY Table

To sync data to the FLOW_HISTORY table, we must send a separate API request for each Flow Execution, which may impact your sync time if you have a large dataset.

The CONVERSION Table

Due to Twilio's API limitations, we must sync all conversations from the past seven days during each sync. Therefore, if you have a large volume of conversations within seven days, your syncs may take longer than expected.

The CONFERENCE Table

To sync data to the CONFERENCE table, we must send a separate API request for each Voice Conference, which may impact your sync time if you have more conferences than usual within 24 hours.

To remove any of the above tables from your existing connector schema, do the following:

1. In your Fivetran dashboard, go to your Twilio connector page.
2. Select the Schema tab.
3. Uncheck the tables you want to remove from your schema.
4. Click Save changes.