RAW Schema Profiles — Brainforge Internal Snowflake
Profiled: 2026-03-02
Purpose: Document raw table schemas, grain, and transformation guidance for the delivery/finance analytics dbt layer.
Overview
| Source | Schema | Tables | Ingestion | Last Profiled |
|---|---|---|---|---|
| QuickBooks | RAW.POLYTOMIC_QUICKBOOKS | 9 | Polytomic | 2026-03-02 |
| HubSpot | RAW.POLYTOMIC_HUBSPOT | 2 | Polytomic | 2026-03-02 |
| Clockify | RAW.CLOCKIFY | 2 | Custom/sync | 2026-03-02 |
| Operating | RAW.OPERATING_IO | 9 | Operating.io sync | 2026-03-02 |
Related: cross-client source notes
For vendor-level context (SPINS, Shopify, Amazon, etc.) across engagements—not only Brainforge internal RAW schemas—see ../source-systems/README.md.
Profile Documents
Transformation Layer Guidance
Phase 1 (Delivery)
- Staging:
stg_clockify_time_entries,stg_operating_time_entries - Mart:
mart_delivery_time_effort(unified time by person/project/date)
Phase 2 (Finance)
- Staging:
stg_quickbooks_*,stg_hubspot_* - Marts:
mart_finance_account_monthly(journal lines rolled to month/account with optional category mapping)mart_finance_summary(month-level revenue/COGS/opex + AR/AP + cash signals)