Skip to content

Latest commit

 

History

History
14 lines (11 loc) · 1.52 KB

CHANGELOG.md

File metadata and controls

14 lines (11 loc) · 1.52 KB
Raw

dbt_salesforce_marketing_cloud v0.1.0

🎉 This is the initial release of this package! 🎉

📣 What does this dbt package do?

This package models Salesforce Marketing Cloud data from Fivetran's connector. It uses data in the format described by this ERD.

The main focus of the package is to transform the core object tables into analytics-ready models:

  • Materializes Salesforce Marketing Cloud staging tables which leverage data in the format described by this ERD. The staging tables clean, test, and prepare your Salesforce Marketing Cloud data from Fivetran's connector for analysis by doing the following:
  • Primary keys are renamed from id to <table name>_id.
  • Adds column-level testing where applicable. For example, all primary keys are tested for uniqueness and non-null values.
  • Provides insight into your Salesforce Marketing Cloud data across the following grains:
    • Email, send, event, link, list, and subscriber
  • Generates a comprehensive data dictionary of your Salesforce Marketing Cloud data through the dbt docs site.