| Actor | Fragment | Worker | State |
|---|---|---|---|
| 54088 | 2473 | 3 | running |
| 54089 | 2473 | 3 | running |
| 54090 | 2474 | 3 | running |
| 54091 | 2474 | 3 | running |
CREATE MATERIALIZED VIEW insights.fx_rates_snapshot_mv AS
SELECT
source_currency_code,
target_currency_code,
rate
FROM (
SELECT
source_currency_code,
target_currency_code,
rate,
ROW_NUMBER() OVER (PARTITION BY source_currency_code, target_currency_code ORDER BY date DESC) AS rn
FROM asset_service.foreign_exchange_rates_eod_ft
)
WHERE
rn = 1