Switchboard Docs
ReferenceSource Models

Overview

Copy-paste SQL model definitions for each data source.

Ready-made model definitions you can copy into your Data Layer to go from raw source data to business-ready reporting.

Two things to keep in mind when using these:

  • Models must be added in order from top to bottom within a page, so that later models can reference earlier ones.
  • Update each {{sources.…}} reference to match your own source names, and replace placeholders like {{ reporting_timezone }} with your account's values.