RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local

CREATE MATERIALIZED VIEW alinma_bff.party_advisor_kpi_counts_mv AS
WITH tagged AS (
  SELECT
    user_id,
    1 AS c,
    0 AS p,
    0 AS a
  FROM alinma_bff.party_advisor_kpi_user_customers_mv AS party_advisor_kpi_user_customers_mv_next
  UNION ALL
  SELECT
    user_id,
    0,
    1,
    0
  FROM alinma_bff.party_advisor_kpi_user_portfolios_mv AS party_advisor_kpi_user_portfolios_mv_next
  UNION ALL
  SELECT
    user_id,
    0,
    0,
    1
  FROM alinma_bff.party_advisor_kpi_user_accounts_mv AS party_advisor_kpi_user_accounts_mv_next
)
SELECT
  user_id,
  CAST(SUM(c) AS INT) AS clients_count,
  CAST(SUM(p) AS INT) AS portfolios_count,
  CAST(SUM(a) AS INT) AS accounts_count
FROM tagged
GROUP BY
  user_id