·
1 commit
to main
since this release
🎉 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
idto<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.