IHSI SyNSIP

Statistical Production Console

ICAE Gold tier promotion · Embargo management · CNSI sign-off workflow

Production DAG: Manual Trigger Only

Sign-off Status

No Sign-off for Q3 2026

DAG will raise AirflowFailException without sign-off

Last Gold Promotion

Q2 2026 — ICAE Quarterly

2026-08-10 14:30 · v-004750 · 47,218 records

Embargo Queue

2datasets awaiting DG release

ICAE Q2 2026 · GDP FY 2025

ICAE Production Pipeline — DAG Control

icae_production_pipeline · schedule_interval=None · Manual trigger only

Manual Only
1Pending

require_statistician_signoff

PythonOperator — checks staging approval DB for DSE sign-off for the target period. Raises AirflowFailException if none found.

2Pending

dbt_run_gold_models

KubernetesPodOperator — runs dbt models tagged icae+gold. Applies lag(4) YoY growth, ISIC mapping, SNA 2008 conformance.

3Pending

notify_publication_ready

PythonOperator — notifies DG and CNSI that ICAE is promoted to Gold tier. Embargo clock starts.

Sign-off required — complete the Statistician Sign-off tab first

ICAE Quarterly Series — Published Gold Tier

gold.fact_icae_quarterly · YoY growth via lag(4) over partition by isic_code · SNA 2008 conformant

v_fact_icae_quarterly_releasedGold
lag(4) — same quarter prior year · ISIC aggregate

Trigger Production DAG

Critical Production Action

This will trigger icae_production_pipeline which promotes data to the Gold tier. This action is irreversible — corrections require a new version_id (FR-03-05).

DAG IDicae_production_pipeline
ScheduleNone (manual only)
Sign-off Status✓ Recorded
Target TierGold

Release Embargo