Frequently Asked Questions
01. Getting Started
In our documentation
Talk to your product specialist or submit a support ticket indicating the source you need and your request will get routed to the correct person. The more requests we get for a source, the higher we prioritize building the new connectors.
Fivetran supports multiple warehouses including Azure Synapse, BigQuery, MySQL, Panoply, Periscope, PostgreSQL, Redshift, Snowflake and SQL Server. Learn more about price, performance and features of five of the most popular data warehouses here.
See a list of supported warehouses here.
- Log into your warehouse, you will notice your Account name in the upper lefthand corner.
- Underneath the Account name in the upper lefthand corner you will see the name of your warehouse. Click on the arrow to view the dropdown menu.
- Select ‘Manage Account’ in the dropdown menu.
- Click the ‘+ Warehouse’ option.
- Enter your new warehouse name and select ‘Add warehouse.’
02. Data Extraction and Loading
As fast as every minute.
Yes, you can adjust the load time to run as frequent as every five minutes and as infrequent as every 24 hours.
While frequent data loads will give you more up-to-date data, there are a few reasons you wouldn’t want to load your data every five minutes, including:
- Higher API usage may cause you to hit a limit that could impact other systems that rely on that API.
- Higher cost of loading data into your warehouse.
- More frequent delays, resulting in increased delay notification emails. For instance, if the data source generally takes several hours to update but you choose five-minute increments, you may receive a delay notification every sync.
We generally recommend setting the incremental loads to every hour to help limit API calls.
No. Support can provide an update in progress upon request, but it will not include an estimated time of completion.
If you just set up your trial, it could take anywhere from a couple of hours to a couple of days to complete the historical sync depending on the size of your data source. If it has been several days, please submit a support ticket and we will look into it.
Most ad sources complete a historical sync in less than a day. However, the amount of data in the source and API rate limits may cause this to vary.
03. Transformations and Automated Schema Changes
Our pipelines are configured to handle new fields or tables added to your source gracefully, so you don’t need to make manual adjustments in the UI. We constantly monitor and stay ahead of API changes or deprecations so you don’t need to think about it.
No, the Fivetran team will update the connector. Fivetran is fully managed, including managing your destination schema in addition to staying ahead of API changes for all connectors. This is one of our core philosophies.
Yes, Fivetran can currently schedule SQL-based transformations to run in your destination on either a regular configured schedule or when new data loads. We also support integration with dbt (data build tool) to run your models.
04. Security and Data Audits
We take security very seriously. Learn more here
Fivetran has servers globally across different cloud providers. You can view all regions and cloud hosts here.
In rest and in transit. Learn more here.
Yes, you can block both specific tables and specific columns. This is especially helpful for sensitive information such as personally identifiable information (PII).
Yes. Learn more here.
Fivetran can only access your data with your approval.
Data is purged as soon as successfully written to the destination in most instances. Learn more here.
Yes, view our Trust Center for more details.
Yes, you can connect your logging system to Fivetran. Learn more here.
Find details on Fivetran audit tables here.
We recommend that you first check the Fivetran audit table (more information here). If you still do not see the data you need, please contact the Fivetran support team by submitting a support ticket.
For customers that run a lot of campaigns, we’ve seen syncs take more than 24 hours for AdWords and Facebook. In order to make the process faster, we only sync the most recent two years of data automatically. If you would like to see more history, submit a support ticket. Do remember, however, that these bigger historical syncs can take days and incremental updates will be paused in the interim.
05. Billing and Support
Fivetran pricing is volume based. You will be charged based on what you use, defined as the number of monthly active rows (MAR). The number of MAR is variable based on the data sources you connect and your specific business. Please contact us to receive help with a quote or use this blog resource to determine the cost yourself.
Submit a support ticket here.
It is defined as the number of distinct primary keys synced via the Fivetran plan calculated on a per-account basis. We only count rows once per Billing Period, even if they sync multiple times.
Start for free
Join the thousands of companies using Fivetran to centralize and transform their data.