DWRPT is the Data Warehouse Reporting database on ETL01. It holds schema-prefixed pre-joined SQL views consumed by Juicebox, the DAS AI agents, and potentially the CDP. Juicebox cannot perform SQL JOINs — all multi-source data must be pre-joined here before exposure.
Application Schemas
SL
Social Logic
Social media and survey management.
Accounts
MRSReviewRequest
Reviews
SurveyResponseGen2
Surveys
ML
MediaLogic
Campaign performance, vehicle data, VDP analytics.
CampaignLevelPerformance
VehiclePerformanceDaily
VDPData_Google
VDPData_Google2
RL
ReviewLogic / RepLogic
Lead management and reactivation.
Leads
Leads_Reactivations
Smart_Follow
CDXP
CDXP Platform
Core CDP/CRM platform views — most extensive schema.
BlueSky_Overview
BlueSky_Recommendations
CDXPCustomers
CDXPTransactionsOverview
DataMiningTool
LeadPerformance
Marketing_Summary
MarketingPerformance
MatchBacks
NEW_RECIPIENTS
TRANSACTION_SUMMARY
ZipCode_Geo
All View Prefixes (from SSMS)
| Prefix |
Schema |
Purpose |
Notable Views |
| AL | Application Layer | Primary reporting views root namespace | — |
| ALGVACampaign* | GVA Campaigns | Campaign data by VIN | — |
| ALJuiceReporting_* | Juice Reporting | BSR equity views for Juicebox | — |
| ALMAIA* | MAIA Campaigns | MAIA campaign data | — |
| ALML* | MediaLogic | Campaign level, vehicle perf, VDP data | Google, Google2 |
| ALTikTok* | TikTok | TikTok campaign data | — |
| ALv_CDXP_* | CDXP | BlueSky, customer, transaction, marketing, lead, geo data | BlueSky_Overview, CDXPCustomers, MarketingPerformance, MatchBacks |
| ALv_ML_* | MediaLogic | Campaign and vehicle daily | CampaignLevelPerformance, VehiclePerformanceDaily |
| ALv_RL_* | ReviewLogic | Lead reactivations, smart follow | Leads, Leads_Reactivations, Smart_Follow |
| ALv_SL_* | Social Logic | Review requests, survey responses | Accounts, Reviews, Surveys |
| ALv_SurveySendSummary | Core | Survey send tracking | — |
| ALVDPData_ML_* | VDP Data | Vehicle detail page analytics | Google, Google2 |
| core_v_* | Core | Shared cross-app views | AllTimePerformance, Reviews, SocialAdsCampaign, Surveys |
| dbo.* | Default | Unschema'd legacy views | RL_Leads, RL_Leads_dev |
| zuora.* | Zuora Billing | Billing account data | AccountStage |
CDP Implications
-
›
DWRPT is the correct integration layer — access to DWRPT gives more value than access to Juicebox. Schemas are organized to prevent cross-app conflation.
-
›
Common Client ID is the cross-source join key, recently implemented. Cleanliness issues discovered — must be audited before CDP identity resolution design.
-
›
DAS AI agents already query DWRPT directly — via execute_sql against mssqlclient at ai.das-technology.com. CDP AI should reuse this path, not build parallel infrastructure.
-
›
Read access requested — Ron Mulder is the DAS contact responsible for granting DWRPT access to the Conflict team. High priority blocker.