Learn about the connectors section of your Fivetran dashboard.
In the Connectors section of your dashboard, you can view all the connectors that sync to your destinations, add new connectors, and see in-depth information about individual connectors. You can also upload CSV files to your destination.
You can add multiple connectors to an account. Only users who have particular user roles can add new connectors. Read more about user permissions in our account management documentation.
Add a new connectorlink
- In the top right corner of the Connectors tab in your Fivetran dashboard, click Add Connector.
- Select your source from the drop-down menu.
- Click Continue Setup to launch the connector setup form.
- Follow the detailed instructions in the embedded setup guide on the right.
- Fill in the required fields (the fields vary by source).
- Click Save & Test. Fivetran will take it from here and sync your data from your source.
On the Connectors tab, you can see the following information for each connector:
- Name: The name of your connector.
- Source: The data source that the connector syncs data from.
- Destination: The destination that the connector syncs to.
- Status: The connector's status. Learn more in the Connector status section.
- Last synced: The last time we synced the connector.
By default, your connectors are ordered from the most recent sync to the least recent sync. To reorder the connectors list by name, source, destination, status, or last sync time, click the column header.
You can filter by source, destination, and status. You can apply multiple filters at the same time.
You can also search the connectors list by connector name.
You can organize the connector list into groups by clicking the grouping icon beside the Source, Destination, or Status column header.
You can collapse and expand groups by clicking the icon on the right from the grouping icon.
You can sort the groups by clicking the sorting icon in the grouping column and sort connectors within each group by clicking the sorting item in a non-grouping column.
Create saved viewslink
You can create a saved view to find connectors easily.
- Filter and order the Connectors list to create your chosen view.
- Above the Connectors list, click Save this view. Your view is now saved.
Once you've created a saved view, you can click Go to saved view to apply your chosen settings to the Connectors list at any time.
IMPORTANT: You can only have one saved view at a time. When you save a new view, it replaces the existing view.
Pin favorite connectorslink
You can use the star icon to pin your favorite connectors to the top of your Connectors list for easy access. You can favorite multiple connectors at the same time.
To remove a connector from your favorites, deselect the star next to its name.
The Status column displays one of the following statuses:
- Active: The connector is actively syncing your data according to your sync schedule.
- Broken: The connector is not working because of a problem with the connector or its associated destination. To learn how to fix the problem, click the connector and read the error message in the Alerts section.
- Delayed: The connector's sync is delayed. When determining whether a connector is delayed, we now consider the average duration of its syncs, its sync frequency, and the delay notification setting you specified on your connector's Setup tab.
- Incomplete: The connector’s setup is not complete. To finish the setup, click the connector name and follow the prompts in your dashboard.
- Paused: The connector has been turned off. To unpause your connector, click the connector and set the toggle in the top right corner to ENABLED.
If you want to only view connectors with certain statuses, filter the Connectors list by status:
NOTE: You can select multiple statuses at the same time.
Next to your connector's status, you may see a small icon. Hover over the icon to see its description. Each icon indicates one of the following connector states:
- Syncing: The connector is currently syncing data.
- Historical: The connector is currently performing a historical sync. This could be an initial sync or a historical re-sync.
You can view your connector's schemas on the Schema tab of your Fivetran dashboard. Learn more in our connector schemas documentation.
You can troubleshoot your connector's sync using the Logs tab in your dashboard or using external log services.
To troubleshoot a connector's sync using the dashboard, select the connector from your dashboard. If you have just one instance of that connector, you will see a connector detail page.
If you have more than one instance of a connector (for example, if you have multiple Google Sheets connectors), their schema names are listed after you select the connector. Select a schema name to see the detail page for a particular instance of a connector.
Sync History chartlink
You can use the Sync History chart to identify failed syncs and see what's going wrong.
Go to your Sync History chart on the Status page of your Fivetran dashboard. Find the failed sync and hover over the stage bar to view the reason why your sync failed:
User Actions listlink
The User Actions list shows any actions taken on your connector in the last 30 days and identifies the user who made them. If your sync fails, use this list to see if a user action coincides with the failure, find the person who made that change, and have them reverse it.
View the User Actions list on the Connector Status page of your Fivetran dashboard, just below the Sync History chart.
Each user action has an action name to help you quickly see what your users are doing:
|User Action Name||Action Description|
|Connection Created||User created a new connector|
|Credentials Edited||User edited your connector's credentials|
|Sync Frequency Updated||User changed the frequency of your syncs|
|Delay Notification Updated||User updated your preferences about sync delay notifications|
|Connection Paused||User paused your connector|
|Connection Resumed||User resumed your connector|
|Historical Re-sync Triggered||User triggered a re-sync of all your data|
|Historical Table Re-sync Triggered||User triggered a re-sync for a specific table|
|Manual Update Triggered||User triggered a manual update for your connector|
|Warning Dismissed||User dismissed a warning message|
|Connection Manually Tested||User tested your connection|
Connector logs show all the major operations of your Fivetran connector. Use your logs to learn more about your failed syncs.
View your connector logs in the Logs tab on the Connector Details page of your Fivetran dashboard. You can view the past day, hour, or week's worth of log records.
Each log record has an event name to help you quickly see what's happening in your connector:
|Connector Event Name||Event Description|
|api_call||API call to source service|
|sql_query||SQL query executed on source database|
|create_schema||Schema created in destination|
|change_schema_config||Schema configuration updated|
|migrate_schema_config||Schema configuration migration created|
|schema_migration_start||Schema migration started|
|schema_migration_success||Schema migration succeeded|
|schema_migration_failure||Schema migration failed|
|schema_migration_end||Schema migration ended|
|create_table||Table created in destination|
|drop_table||Table dropped in destination|
|alter_table||Column(s) in destination table added/modified/dropped|
|connection_successful||Connection established with source system|
|connection_failure||Connection not established with source system|
|sync_stats||Current sync metadata|
|json_value_too_long||JSON value truncated because it was too long for destination|
You can search connector logs by keyword or filter by log type (schema change events, errors, and warnings). Click the black arrow next to a log record to expand it.