Clari Forecast Warehouse Pipeline

Overview

Move forecast data through a three-stage pipeline: immutable landing, validated normalization, and reconciled publication. Preserve Clari identifiers and export context so every dashboard value can be traced back to one job and request.

Prerequisites

• Forecast ID, hierarchy scope, fiscal-period convention, and requested data types
• Landing storage with encryption, retention, and access controls
• Warehouse schema owner and reconciliation tolerances

Instructions

Step 1: Define the snapshot key

Use forecast ID, requested time period, scope, currency, data types, and export timestamp as the immutable business key.

Step 2: Reserve export capacity