Databricks shared this video from the Data & AI Summit Europe on adding historical analysis on Salesforce data.

Fivetran makes it easy to automate data ingestion particularly for operational data sources such as Salesforce, Zendesk, and Oracle Eloqua, no matter how source schemas and APIs change.

Achieving historical analysis is cumbersome, time-consuming, and costly to build and maintain manually. A common approach is to include snapshots, which only take into account changes at a given time. Plus, the additional storage requirements can become unwieldy to manage.

Type 2 Slowly Changing Dimension (SCD) allows you to track any change at any point in time.

This session shows how Fivetran History Mode, which uses Type 2 SCD, can be easily configured and then switched on with 1-click and synchronized for a desired time period. This accelerates time to insights, making it easy to both automate data ingestion and historical analysis.

In this episode, Frank offers some encouragement for people hoping for a better year in 2021.This episode was originally recorded on an impromptu livestream and, in a delightful surprise, Andy was able to join.


Press the play button below to listen here or visit the show page at