stg_postgres__promotions

staging view

Promotions, with active-window flag.

Definition

The promo / discount catalog. `discount_type` ∈ {percent, flat, free_shipping}; `discount_value` is the percent (5–30), the flat dollar amount, or 0 for free-shipping. `is_window_open` derives from `ends_at` for live-eligibility filters.

11 of 11

Column

Description

Tests · PII

promotion_id

Primary key — UInt64.

3 tests

code

Display code shown to customers (e.g. `PROMO-0017-ABCD`).

2 tests

description

Marketing-facing description. Nullable.

discount_type

`percent`, `flat`, or `free_shipping`.

1 test

discount_value

Percent (5–30), flat-dollar amount, or 0 for free shipping. Decimal(10,2).

starts_at

Validity window start. DateTime64(6).

ends_at

Validity window end. Null = no expiry.

max_redemptions

Cap on total redemptions. Null = unlimited.

is_window_open

Derived — `ends_at IS NULL OR ends_at > now64()`. True ⇒ currently eligible.

source_created_at

Row insert timestamp from the source DB. DateTime64(6).

airbyte_extracted_at

When Airbyte extracted this row from postgres-source.