version: 2

sources:
  - name: salesforce
    description: >
      Frozen one-off snapshot of the Salesforce `Revenue__c` object. Sourced from the legacy
      digital_bi Fivetran table `gcp-digital-bi.salesforce.revenue_c` (the only populated copy —
      the NexusCRM `Revenue__c` snapshot is empty at source, #15), extracted UNMANAGED to a no-expiry
      ad-hoc S3 bucket and loaded by the MANAGED s3_bulk_load `salesforce` unit (external mode,
      ADR 0018), which owns the raw-snapshot contract (ADR 0016). This is the same object BigQuery
      derives `salesforce_order_daily_view` from. Revenue is no longer recorded in Salesforce/NexusCRM
      (#16); go-forward revenue is the new business process tracked in #19.
    schema: salesforce_raw
    tables:
      - name: revenue
        identifier: salesforce_revenue_c_snapshots
        description: Salesforce custom object Revenue__c (rev-rec records) — historical freeze.