# Deplhi CRM flow

This flow is responsible for ingesting data from Delphi CRM.

Drop location `s3://prod-delphi-crm/salesforce-marketing-cloud/`

The destination for data is Delphi Snowflake:

Snowflake:

| Property | Value                            |
|----------|----------------------------------|
| Account  | `Delphi`                         |
| Database | `DELPHI_CRM_DATA`                |
| Schema   | `RAW_SALESFORCE_MARKETING_CLOUD` |


# Reports

| report name        | staging raw table         | periodic |
|--------------------|---------------------------|----------|
| complaint_tracking | `SFMC_COMPLAINT_TRACKING` | daily    |
| held_emails     | `SFMC_HELD_EMAILS`     | daily    |
| mc_unsubscribe_data | `SFMC_MC_UNSUBSCRIBE_DATA` | daily    |