CREATE MATERIALIZED VIEW insights.account_to_account_groups_binned_mv AS
SELECT
atag.account_id,
atag.account_group_id,
atag.effective_start_date,
atag.effective_end_date,
atag.base_currency,
atag.opening_date,
atag.source_entity_type,
spine.dim_value_month
FROM insights.account_to_account_groups_mv AS atag
JOIN (
SELECT DISTINCT
account_id,
CAST(DATE_TRUNC('MONTH', dim_value_date) AS DATE) AS dim_value_month
FROM insights.holding_values_mv
) AS spine
ON spine.account_id = atag.account_id
AND spine.dim_value_month >= CAST(DATE_TRUNC('MONTH', atag.effective_start_date) AS DATE)
AND (
atag.effective_end_date IS NULL
OR spine.dim_value_month < atag.effective_end_date
)