Fivetran provides connectors, in which we can change the sync mode based on our requirements once initial sync is completed. Let’s have a look at the options that Fivetran provides more in detail from this blog. Basically, after the initial sync, all tables will be in the live mode which can be changed. There are three sync modes available;

  1. Live mode
  2. History mode
  3. Legacy Mode

Little more about, Automatic re-sync/ Modes of Sync

Live Mode: In Live mode when a record is updated in your source, Fivetran updates the corresponding record that exists in your data warehouse in its next sync. Likewise, when a record is deleted in your source application and return deletes as changes then Fivetran delete the corresponding record in the warehouse.

How data sync works in Fivetran?
Live mode

History mode: It is activated on a table basis, in history mode Fivetran keeps all versions of the record using the type 2 slowly changing dimension format. To keep all versions of the record, Fivetran adds three columns to each record in that table.

How data sync works in Fivetran?
History Mode

Legacy mode: It is the hybrid of Live and History Mode. Once you activate history mode for a table, you cannot return to legacy mode. You can only switch to live mode. In legacy mode, when a record is deleted in your source, Fivetran soft delete it in the warehouse by setting the system column fivetran_deleted = TRUE.

How data sync works in Fivetran?
Legacy Mode

Conclusion

Fivetran makes extraction and loading possible with few clicks and lets you concentrate on your analytics than worry about building your data.

References:

  1. https://fivetran.com/docs/getting-started/free-trial-setup-guide
  2. https://fivetran.com/docs/getting-started/feature/history-mode

Read more blogs from Fivetran category here and know more about Visual BI’s Self Service BI offering here.


Corporate HQ:
5920 Windhaven Pkwy, Plano, TX 75093

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com


Copyright © Visual BI Solutions Inc.

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Share This!

Share this with your friends and colleagues!