When a Fivetran sync fails, there could be various reasons behind it. Here are the top three troubleshooting steps to help you identify and resolve the issue:
1. Check the Error Message: The first step is to review the error message provided by Fivetran. Log in to your Fivetran dashboard, go to the sync status, and check for any error messages or logs related to the failed sync. The error message often provides valuable insights into what might have gone wrong.
2. Look for Connection Issues: Verify that the source and destination connections are valid and working as expected. Ensure that you have the correct credentials and permissions to access the data sources and the destination data warehouse.
3. Check Source Data Availability: Make sure that the data source you are trying to sync from is available and accessible. If it’s an API-based connection, check if the API is responding correctly and if there are no changes in the API’s endpoints or authentication methods.
Remember that troubleshooting may vary depending on the specific data sources, transformations, and destinations you are using. Following these steps should help you pinpoint the problem and get your sync back up and running.