Using a Fivetran Accountlink
The Fivetran dashboard is the web-based control center for your Fivetran account. This page explains what you can do on your dashboard. The dashboard looks different based on your user permissions.
To access the Fivetran dashboard, you must have a Fivetran account that is connected to a destination. Refer to our free account trial documentation to learn how to set up your Fivetran account.
Note: If you have a Standard or Enterprise account, you can also manage your Fivetran account and its connectors using our REST API. See our REST API documentation for details.
Navigating the Dashboardlink
Go to [https://fivetran.com/dashboard](https://fivetran.com/dashboard). If your account has more than one destination connected, choose the destination you want to manage. This is your dashboard’s home page where you can control the integrations connected to the selected destination:
On your dashboard homepage, you can manage:
- BI tools
Note: Your available management actions depend on your user permissions.
If you are an account owner, you can also go from the dashboard home to the account management page.
On the account management page, you can:
- Add and remove destinations
- Manage users and their permissions
- Manage and create custom roles
- Manage account security settings
- View your billing and usage details
In the Connectors section of your dashboard, you can view all the connectors that sync to your destination, add new connectors, and see in-depth information about individual connectors.
You can add multiple connectors to an account. Only admin users and analyst users can add new connectors. Read more about user permissions in our account management documentation.
Add a new connectorlink
- In the top right corner of your Fivetran dashboard, click + Connector.
- Select your source from the drop-down menu 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.
You can troubleshoot your connector's sync using the dashboard or using external logs.
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 chart
The Sync History chart visualizes the status of your syncs, how long they took, and how much data was synced each time. Use it to identify failed syncs and see what's going wrong.
View your Sync History chart on the Connector Status page of your Fivetran dashboard. The chart breaks down your syncs into Extract, Process, and Load steps. You can view one hour, one day, or one week of sync history.
Each sync is represented by a colored bar. Hover over the sync bar to see your sync's type, duration, start and end time, status, extract time, process time, load time, and data volume.
The bar's color reflects the sync status:
|Green||Completed||Your sync finished running with no errors.|
|Blue||Incomplete||Your sync is currently running.|
|Purple||Rescheduled||Fivetran reschedules syncs in two situations:
|Gray||Unknown||Your sync has exhibited atypical behavior and has not completed for unknown reasons.|
|Red||Failed||Your sync could not finish running. The stage your sync failed in appears in light red (for example, the sync below failed in the Load stage).|
Hover over the stage bar to view the reason why your sync failed:
For connectors that support priority-first sync, the forward and backward syncs are displayed as separate adjacent colored sync bars. When you hover over the sync bar, you will see 'Priority-first sync' specified as the sync type in the popover displayed.
Click View in the popover to see the historical sync progress for each table. The details include the date up which the data has been fetched and the total number of days of available data history to be fetched.
User Actions list
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 one day, one hour, or one week 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||Updated schema sync configuration|
|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|
|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.
Sync frequency and schedulinglink
By default, Fivetran syncs your data from your source to your destination every 6 hours. If you want Fivetran to sync your data more or less often, you can adjust the sync frequency. The sync frequency determines how long after the start of each sync that another sync will be scheduled. For example, if your sync frequency is 30 minutes, your second sync will start 30 minutes after the start of your first sync. The Fivetran sync schedule starts every day at midnight in the destination timezone, plus an offset of 0 to 60 minutes that is shared by every connector in that destination. The offset ensures that all Fivetran connectors do not launch at once, which slows down the sync process.
Depending on your plan level, you can choose from the following sync frequencies:
- 5 minutes
- 15 minutes
- 30 minutes
- 1 hour
- 2 hours
- 3 hours
- 6 hours (default)
- 8 hours
- 12 hours
- 24 hours
Select your sync frequency on your connector's Setup tab:
Alternatively, you can create a custom sync schedule using the Fivetran REST API (Standard and Enterprise accounts only). Learn how in our REST API documentation.
If a sync is already running at the time of next scheduled start, Fivetran does not start a new sync until 5 minutes after the current sync has finished. Here's an example for a connector with a 15-minute sync frequency:
|Sync Number||Start Time||End Time||Notes|
|3||8:30 8:40||8:50||Sync 3 is postponed because Sync 2 is still running. Sync 3 then starts 5 minutes after the end of Sync 2.|
Fivetran supports custom sync scheduling for connectors that sync once a day. You can choose what time your daily syncs start if you don't want to use Fivetran's default midnight starting time. If you don't know how often your connector syncs, check the sync frequency on your connector's Setup tab in your Fivetran dashboard.
Syncing empty tables and columnslink
Most Fivetran connectors do not sync source tables and columns that have no data and don't create them in your destination. However, Fivetran can create empty tables and columns in your destination for some connectors. See our Features documentation for a list of supported connectors.
Note: Under no circumstances will we sync an empty schema.
Each account can have multiple destinations. Only account owners can add destinations. Read more about account management permissions in our account management documentation.
You can switch between destinations in the top left menu:
Add a new destinationlink
Note: If you're setting up the first destination for your trial account, refer to our free account trial documentation instead.
In the top left corner of your Fivetran dashboard, click your destination name to view the drop-down menu.
Scroll to the bottom of the drop-down menu and click Manage account.
In the Destinations tab, click +Destination.
On the Add Destination To Fivetran page, enter a short memorable name for your destination.
If you want Fivetran to create a destination for you, click Set up a Fivetran-managed warehouse. We will create a Managed BigQuery destination for you.
Select your destination from the available destination options.
Enter the destination-specific details. See our destination documentation for more information.
Click Save & Test.
External log services can retain connector log data longer than Fivetran. We retain connector logs for one week, so we recommend that you connect to an external log service if you want to access logs older than seven days. Logging services usually allow users to keep log data for several months at a minimum, though the specifics vary by provider.
Connect your external log service on the Logs page of your Fivetran dashboard.
Fivetran supports the following logging services:
Destination admins can add users to the destination in the Users section. Fivetran supports four user roles for destinations:
- Read Only
Each role has different levels of permission. Read more about destination permissions in our account management documentation.
There are two types of automatically-generated alerts in your Fivetran dashboard - Tasks and Warnings. View both on the Alerts page of your Fivetran dashboard.
We create a Task in your Fivetran dashboard when a problem on your end is breaking a connector or transformation in your account. When we create a new Task in your dashboard, we also generate a notification email. Click on the Task in your Fivetran dashboard or view your notification email to learn about the problem and read instructions about how to fix it.
Tasks fall into one of the following categories:
- Data source connection problem: Your data source is not connected correctly (for example, the setup tests in your Fivetran dashboard failed).
- Data source configuration problem: Your data source is not configured correctly for Fivetran to use (for example, the Fivetran user doesn't have adequate permissions to access your data).
- Data source file problem: Your source files are not configured correctly (for example, some of your tables have null primary keys).
- Destination connection problem: Your destination is not connected correctly (for example, you did not finish your destination set up in the Fivetran dashboard).
- Destination configuration problem: Your destination is not configured correctly for Fivetran to use (for example, you have exceeded your destination's storage quota).
We create a Warning in your Fivetran dashboard when there are issues with your connector that you may need to fix, but that are not disrupting your data syncs. Click on the Warning in your Fivetran dashboard to learn more about the issue and determine whether or not you need to take action.
Warnings fall into one of the following categories:
- Excluded files: We were unable to sync certain files (for example, you added a new table for which Fivetran does not have permissions yet).
- Excluded columns: We were unable to sync certain columns (for example, you are still using a column that has been deprecated by your application's API).
- Change tracking issues: We encountered incomplete change tracking data, which we use for our incremental syncs (for example, your database administrator turned off your change tracking mechanism).
Fivetran's dashboard automatically generates email notifications about problems with your connector. We also send manual email notifications under special circumstances.
You can also use audit tables to create your own notification system.
Automatic email notificationslink
Note: By default, all notifications will be enabled on your account. You will have notifications enabled for new services, all your data sources, and all your connectors.
We automatically send you email notifications in the following situations:
- New Task: When we generate a Task in your dashboard, we automatically send you an email with details about the Task. We resend this email every seven hours until the Task is completed.
- Sync delays: We automatically email you when your syncs are delayed. We consider a sync delayed when it takes more than four hours longer than normal to start. We define the normal sync interval as the average time between successful syncs over a rolling 14-day period.
You can customize your automatic notification settings on the Notifications page of your Fivetran dashboard.
To disable notifications for new services, deselect the Notifications enabled by default for new services box.
To disable notifications only for certain data sources or connectors, deselect the box next to the data source or connector names.
To disable all notifications, set the toggle in the top right corner to Disabled.
Manual email notificationslink
If there is a problem with your connector that Fivetran caused, we will manually email you to let you know what the problem is and what we are doing to fix it.
To get help from our support team, log in to your Fivetran account and go to our Zendesk-based support portal. You can open tickets, update your tickets, and track their progress and status. You can also find answers to frequently asked questions.
When working on a support ticket, we sometimes need access to your data to troubleshoot or fix your connectors or destination. We will send an email asking you to grant Fivetran access to your data for the next 21 days. The email contains a link to your Fivetran dashboard. After you follow the link, you can Allow access to your data, or Deny it.
NOTE: You do not have to grant Fivetran access to your data. However, doing so lets us troubleshoot or fix your connectors or destination faster.
Fivetran then adds a message to the support ticket, confirming that you approved or denied data access. You can revoke the data access before the 21-day access period has expired. To revoke the access, click Revoke Access in the ticket and then click Revoke in your Fivetran dashboard to confirm your action.
IMPORTANT: You need to have Edit access to the affected connectors or destination to be able to grant access to the data. If you do not have Edit access, you can add another user with Edit access to the support ticket and ask them to grant access.