store_features_hourly

incrementalstorehourly

Hourly demand and inventory features per store. Used by the store-level ranking model.

warehouse.analytics.store_features_hourly

Use this feature group

select
  store_id,
  feature_hour,
  orders_count_1h,
  demand_score
from warehouse.analytics.store_features_hourly

SELECT *
FROM {{ ref('store_features_hourly') }}

Features in store_features_hourly
Name	Type	Column type	Null %	Distinct	Null behavior	Status	Declared ML consumers
`orders_count_1h` Orders placed at this store in the trailing hour	numeric	`integer`	1.2%	33,215	zero	—	`store_ranking_model_v1`
`demand_score` Smoothed demand intensity, 0-1	numeric	`float`	0.10%	73,812	mean	—	`store_ranking_model_v1`

None.

Declared manually via used_by on individual features.