| Actor | Fragment | Worker | State |
|---|
CREATE VIEW alinma_bff.unlinked_account_pairs_sink__rwm_shim AS
SELECT
COALESCE(
id,
ID_FROM_STRING_WITH_PREFIX('unlinked_account_pair', security_account_id || ':' || cash_account_id)
) AS id,
security_account_id,
security_account,
cash_account_id,
cash_account,
registered_by
FROM alinma_bff.unlinked_account_pairs_mv AS unlinked_account_pairs_mv_next