ReferenceSource Models
Impact Models
Copy-and-paste Impact model templates for partner reporting.
Copy and Paste these Impact Models into your Data Layer to quickly go from raw data souces -> business ready Impact Reporting. Please note:
- Models must be added chronological order from top to bottom (so that they can reference each other).
- When adding your own models you must update the reference to include your source names.
Base
impact_partners_base
select
id as partner_id --PK
, date_created :: timestamp as created_at
, name as partner_name
, state as status
, partner_type
, description
, address_address_1
, address_address_2
, address_city
, address_state
, address_postal_code
, website
, phone_number
, promotional_method as promotional_method_json
from {{sources.impact.partner}}
where _fivetran_deleted is falseOutput
impact_partners_output
select
partner_id --PK
, created_at
, partner_name
, status
, partner_type
, description
, address_address_1
, address_address_2
, address_city
, address_state
, address_postal_code
, website
, phone_number
from {{models.impact_partners_base}}