Documentation

Documentation

  • Getting Started
  • Core Concepts
  • Using Fivetran
    • Fivetran IPs
    • Fivetran Dashboard
    • Features
      • Column Blocking and Hashing
      • Local Data Processing for Fivetran Managed Service
      • Regional Failover
  • Usage-Based Pricing
  • Connectors
  • Applications
  • Databases
  • Files
  • Events
  • Functions
  • Destinations
  • Partner-Built
  • Transformations
  • Logs
  • Security
  • REST API
  • Local Data Processing (HVR 6)
  • Release Notes
RSS
Release notes RSS
HVR 5 Documentation
HVR 5 Documentation
  • Support
  • Sign In
Edit on GitHub

Featureslink

Updated 7 days ago


Capture deleteslink

Fivetran captures deletes whenever we can detect them so that you can run analyses on data that may no longer exist in your source system. Some sources provide us with direct information about deletes. When sources don’t provide us with direct information about deletes, we try to infer them.

When you delete data in the source, Fivetran soft-deletes it in the destination. In the destination table, we add an extra column named _fivetran_deleted and set its value to TRUE for the rows deleted in the source. The exact mechanism by which we capture deletes varies by connector type.

Databaseslink

We can detect and capture deletes for most databases because we perform log-based replication (and logs contain deletes) for most databases. The major exception is PostgreSQL XMIN based replication, which is non-log-based. PostgreSQL WAL replication, however, does capture deletes.

Applicationslink

Some application APIs provide dedicated endpoints that return deletes, and we capture deletes for those applications. However, most application APIs don’t return deletes as changes, so we cannot detect and therefore don’t capture those deletes. That means there may be data in your destination from those applications which has been deleted in the source.

Inferred deletes through re-syncslink

If Fivetran re-syncs an entire table, we assume that any record that wasn’t updated must have been deleted, and mark it _fivetran_deleted = TRUE in the destination. In the case of connectors where re-syncing doesn't take long, and we have identified deletes would provide analytical value, we periodically re-sync the entire connector and use this data to infer deletes.

We re-sync in the evenings and on weekends to minimize performance impact. The drawback of this method is that all deletes from a particular period are rolled together -- we don’t know exactly when data was deleted, only that it was deleted in the interval between updates. However, if a source doesn’t provide us direct information about deletes, inferred deletes are the next best thing.


Custom datalink

As part of complete schema replication, Fivetran replicates custom data whenever it exists and is accessible. Not all sources that have custom data expose it in a way we can access.

Custom data includes custom objects, tables, and fields that you have configured in the source system to better suit your business needs. Custom objects are specific to your source, for example, custom Salesforce objects that match your business process. Custom tables are database tables that allow you to store information unique to your organization. Standard tables can also have custom fields, which are specific to an organization.

There is no special action you need to take to make sure we replicate your custom data. It will happen automatically for the systems that enable it.


Data blockinglink

Data blocking lets you omit certain tables or columns from replicating to your destination. Table blocking and column blocking are only available for some of our connectors. If either is available for your connector, you will see the option in your Schema tab. For connectors which support the feature, you can choose which tables or fields within a table to sync and which to block from syncing.

Data blocking avoids exposing sensitive information, like Personally Identifiable Information (PII), in your destination. It also saves you time and storage space, because Fivetran only syncs relevant data to your destination.

Read our detailed documentation about column blocking.


Column hashinglink

Column hashing anonymizes sensitive data in your destination without sacrificing its analytical value. Column hashing is only available for some of our connectors. If this feature is available for your connector, you will see the option in your Schema tab. For connectors that support the feature, you can select which column(s) within a table to hash.

Column hashing avoids exposing sensitive information, like PII, in your destination. Because hashing anonymizes your PII, this feature makes you compliant with the General Data Protection Regulation (GDPR).

Read our detailed documentation about column hashing.


Re-synclink

Sometimes the data in your destination and your source get out of sync and you need to overwrite all or some of the existing data in your destination to make it consistent with the source. Depending on the connector, you can re-sync all or part of your data from your source to your destination.

Full re-synclink

A full re-sync completely overwrites the data in your destination with new data from your source. While it’s a powerful option for fixing a destination out of sync with its source, a full re-sync also pauses incremental updates. A full re-sync can take hours to days for some connectors, either because of the amount of data or because of limits imposed by the source. You can initiate a full re-sync from your connector details page.

Fivetran can re-sync data from any source, but we have disabled the option to run a full re-sync for Marketo because re-syncing it takes an extremely long time. If you want to run a full re-sync for Marketo, contact our support team.

Table re-synclink

Table re-sync lets you overwrite the data in a specific table, so you can fix data integrity issues in selected tables without re-syncing the entire connector. Just like a full re-sync, re-syncing a table pauses incremental updates until the sync completes. However, table re-sync is much faster since single tables tend to have far less data.


Historylink

Fivetran uses the type 2 slowly changing dimension format to retain table history in the destination for selected tables. You can use that historical data to analyze how your data changed over time.

We use the following approaches to retain historical data:

  • For connectors where Fivetran defines the schema, we track history for a predefined connector-specific set of tables. We select those tables based on the analytical value of their historical data. You cannot change which tables track history.

  • For connectors where Fivetran just replicates the schema, we give you the option to select which tables track history. You can switch any supported table to history mode to track its history.


API configurablelink

The Fivetran REST API provides several endpoints that let you perform key management actions which were previously available only through the dashboard.

  • The User Management API lets you list, invite, edit, and delete your users.
  • The Group Management API lets you understand the groups and connectors within those groups.
  • The Connector Management API lets you create, edit, and manage a subset of your connectors.

Read our detailed documentation about the Fivetran REST API.


Priority-first synclink

Priority-first syncs fetch your most recent data first so that it's quickly ready for you to use.

During your initial sync, Fivetran updates your destination with your most recent data. How many days of recent data we fetch and which tables we sync on a priority-first basis vary by connector type.

In each subsequent sync, we continue to update your most recent data first as part of a forward sync. We then fetch your historical data in small increments as part of a backward sync. The backward sync duration varies by connector type.

The forward and backward syncs are two different steps. After we complete the forward sync, we reschedule the connector with a notification on the Fivetran dashboard. The backward sync occurs immediately after we complete the forward sync. This allows us to push the data fetched during the forward sync into the destination, before initiating the backward sync.

The forward and backward syncs are displayed as colored bars in the Sync History chart on the Connector Status page of your Fivetran dashboard. You can click the backward sync bar to see what part of all available historical data for each table is fetched so far.

Priority-first sync is supported for the following connectors :

ConnectorPriority Fetch PeriodTables synced on a priority-first basisBackward Sync Duration
Adjust30 daysAll tables6 hours
Adobe Analytics15 daysAll reporting tables6 hours
AdRoll30 daysAll reporting tables6 hours
Amazon Ads30 daysAll reporting tables6 hours
Amazon Selling Partner7 daysFINANCE and ORDERS modules6 hours
Amplitude15 daysAll tables6 hours
Apple Search Ads30 daysAll reporting tables6 hours
BigCommerce2 daysCHANNEL, CUSTOMER, ORDERS, PRODUCT, PRICE_LIST, and SUBSCRIBER6 hours
Clearpay90 daysPAYMENT and its child tables6 hours
Criteo30 daysAll reporting tables6 hours
Duoplane7 daysPURCHASE_ORDER, PRODUCT and SHIPMENT6 hours
Eloqua7 daysCONTACT_ACTIVITY6 hours
Facebook Pages30 daysAll page insights tables6 hours
Front30 daysCONTACT, CONVERSATION, and their child tables6 hours
Google Analytics 36015 daysAll tables6 hours
Google Analytics 430 daysReporting tables6 hours
Google Analytics 4 Export1 dayAll tables6 hours
Google Display & Video 36030 daysAll tables6 hours
Google Search Ads 36015 daysAll tables6 hours
Google Search Console7 daysReporting tables6 hours
Help Scout15 daysCUSTOMER_HISTORY, CONVERSATION_HISTORY, and their child tables6 hours
HubSpot1 dayEMAIL_EVENT and its child tables6 hours
Instagram Business29 daysUSER_INSIGHTS6 hours
Iterable7 daysEVENT6 hours
Klaviyo7 daysEVENT6 hours
LinkedIn Ad Analytics30 daysAll reporting tables6 hours
Marketo7 daysAll activity (and dependent) tables, LEAD6 hours
Maxio Chargify7 daysEVENT, INVOICE, PRODUCTS_PRICE_POINT, PRODUCT and SUBSCRIPTION tables6 hours
Microsoft Advertising30 daysAll reporting tables6 hours
Mixpanel15 daysEVENT6 hours
Optimizely30 daysDECISION, CONVERSION, and their child tables6 hours
Outbrain30 daysAll reporting tables6 hours
Pardot14 daysEMAIL, VISIT, and VISITOR_ACTIVITY6 hours
Pendo7 daysACCOUNT_HISTORY, VISITOR_HISTORY, FEATURE_EVENT, PAGE_EVENT, GUIDE_EVENT, TRACK_TYPE_EVENT, POLL_EVENT, and EVENT6 hours
Pinterest Ads30 daysAll reporting tables6 hours
Recharge15 daysADDRESS, ADDRESS_DISCOUNT, ADDRESS_SHIPPING_LINE, CHARGE, CHARGE_DISCOUNT, CHARGE_LINE_ITEM, CHARGE_ORDER_ATTRIBUTE, CHARGE_SHIPPING_LINE, CHARGE_TAX_LINE, CHECKOUT, CHECKOUT_LINE_ITEM, CUSTOMER, DISCOUNT, METAFIELD, ONE_TIME_PRODUCT, ORDER, ORDER_LINE_ITEM, PAYMENT_METHOD, PLAN, SUBSCRIPTION, SUBSCRIPTION_HISTORY, and UTM_TAG tables6 hours
Reddit Ads30 daysAll reporting tables6 hours
Reltio7 daysENTITY table6 hours
Salesforce Commerce Cloud15 days CAMPAIGN, CATALOG, COUPON_REDEMPTION, CUSTOMER, ORDER, and PRODUCT6 hours
Salesforce Marketing Cloud1 dayEVENT, SUBSCRIBER, TRIGGERED_SEND, SEND, EMAIL, LIST_SUBSCRIBER, and LIST6 hours
Shopify15 daysABANDONED_CHECKOUT, COLLECTION, CUSTOMER, DRAFT_ORDER, ORDER, PRICE_RULE, PRODUCT, and TENDER_TRANSACTION6 hours
Snapchat Ads30 daysAll reporting tables6 hours
Stripe30 daysAll tables and their child tables except APPLE_PAY_DOMAIN, CHECKOUT_SESSION, CREDIT_NOTE, EARLY_FRAUD_WARNING, PLAN, and SKU6 hours
Taboola30 daysAll reporting tables6 hours
The Trade Desk30 daysAll reporting tables6 hours
TikTok Ads30 daysAll reporting tables6 hours
Twitter Organic30 daysORGANIC_TWEET_REPORT6 hours
Yahoo DSP30 daysAll reporting tables6 hours
Zendesk15 daysTICKET and its child tables6 hours

Syncing empty tables and columnslink

Fivetran can create empty tables and columns in your destination for the following connectors:

  • BigCommerce Beta
  • Google Ads
  • Microsoft Dynamics 365 CRM
  • MySQL
  • NetSuite SuiteAnalytics
  • Oracle
  • PostgreSQL
  • QuickBooks
  • Salesforce
  • Salesloft
  • SAP ERP on HANA Beta
  • ServiceNow
  • SQL Server
  • Stripe
  • The Trade Desk
  • Zuora

Syncing empty tables and columns ensures that any templated SQL queries in your destination that reference these objects continue to work.

NOTE: An empty schema is a schema that doesn't contain any tables. A schema that contains empty tables is not an empty schema. Fivetran doesn't sync empty schemas.


Private networkinglink

IMPORTANT: You must have a Business Critical plan to use private networking.

Private networking allows Fivetran to sync data from your source, write data to your destination, or both without exposing traffic to the public internet.

Fivetran supports the following private networking services:

  • AWS PrivateLink
  • Azure Private Link
  • Google Cloud Private Service Connect Beta

Local Data Processing for Fivetran Managed Service Private Previewlink

IMPORTANT: You must have a Business Critical plan to use this feature.

Local Data Processing enables you to utilize the data integration capabilities of Fivetran without your data going through Fivetran's cloud. Use this feature to create a pipeline for your business-critical data within the security of your on-premises or cloud environment.

Read our detailed documentation about Local Data Processing.


Regional Failover Private Previewlink

IMPORTANT: You must have a Business Critical plan to use this feature.

The Regional Failover feature enables you to ensure the availability of your data, connectors, and services in the event of a disaster or outage in the cloud region hosting the Fivetran services. Use this feature to failover your connectors and services to a secondary region when the primary region experiences a failure or becomes unavailable.

Read our detailed documentation about regional failover.


Fivetran data modelslink

Fivetran offers pre-built, data build tool (dbt) Core -compatible data models for our most popular connectors. Our data models standardize your data and generate tables that you can link to your BI and visualization tools.

You must have a dbt project to use our models. Each data model contains instructions on how to add the model to your dbt project. You do not need to enable Transformations for dbt Core* to use our models, but we recommend it.

To see our available data models and supported destinations, read our data model documentation.

* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.


Questions?

We're always happy to help with any other questions you might have! Send us an email.

    Thanks for your feedback!
    Was this page helpful?