Teardown · asset_service, insights

← cluster integration-testing teardown

Teardown — database integration-testing

Sinks stop writing immediately. MV state is discarded. Cannot be undone.

1 · Apps

authz ibor insights audit never deployed insights-intraday never deployed opportunity never deployed pershing-bff (pershing_bff) never deployed search never deployed

2 · Choose scope

All objects

Drops every object for each selected app: subscriptions, sinks, indexes, materialized views, tables, sources, and app-owned functions.

Materialized views only

Drops materialized views and the sinks, indexes, and subscriptions that depend on them. Tables and sources remain.

Sinks only

Drops sinks only. Materialized views, tables, and sources remain.

3 · Dry-run preview 167 objects · scope = all

asset_service — 12 objects

Subscriptions (0)

—

Sinks (0)

—

Indexes (0)

—

Materialized views (0)

—

Tables (11)

drop asset_service.assets_dm table

drop asset_service.taxonomy_dimensions_dm table

drop asset_service.asset_adjusted_prices_ft table

drop asset_service.benchmark_values_ft table

drop asset_service.foreign_exchange_rates_eod_ft table

drop asset_service.benchmark_constituents_ft table

drop asset_service.benchmarks_dm table

drop asset_service.asset_distributions_dm table

drop asset_service.asset_prices_eod_ft table

drop asset_service.taxonomy_nodes_dm table

drop asset_service.asset_snapshots_ft table

Sources (1)

drop asset_service.asset_service_source source

Functions (0)

—

insights — 155 objects

Subscriptions (0)

—

Sinks (69)

drop insights.pnl_by_sector_sink sink

drop insights.pnl_by_region_sink sink

drop insights.pnl_by_taxonomy_sink sink

drop insights.pnl_by_asset_class_sink sink

drop insights.twrr_by_taxonomy_node_sink sink

drop insights.twrr_by_region_sink sink

drop insights.twrr_by_sector_sink sink

drop insights.twrr_by_asset_class_sink sink

drop insights.pnl_by_asset_sink sink

drop insights.twrr_by_asset_sink sink

drop insights.twrr_by_currency_sink sink

drop insights.pnl_by_currency_sink sink

drop insights.twrr_by_asset_type_sink sink

drop insights.pnl_by_asset_type_sink sink

drop insights.position_by_region_sink sink

drop insights.position_by_asset_class_sink sink

drop insights.position_by_taxonomy_node_sink sink

drop insights.position_by_sector_sink sink

drop insights.position_by_asset_sink sink

drop insights.twrr_sink sink

drop insights.position_by_currency_sink sink

drop insights.pnl_summary_sink sink

drop insights.position_by_asset_type_sink sink

drop insights.position_summary_sink sink

drop insights.flow_by_transaction_type_sink sink

drop insights.flow_by_asset_class_sink sink

drop insights.flow_by_sector_sink sink

drop insights.flow_by_taxonomy_node_sink sink

drop insights.flow_by_region_sink sink

drop insights.flow_summary_sink sink

drop insights.flow_by_asset_type_sink sink

drop insights.holding_values_sink sink

drop insights.flow_by_asset_sink sink

drop insights.flow_by_currency_sink sink

drop insights.abor_settlement_positions_sink sink

drop insights.account_to_account_groups_sink sink

drop insights.benchmark_twrr_by_currency_sink sink

drop insights.benchmark_twrr_by_asset_type_sink sink

drop insights.benchmark_twrr_by_region_sink sink

drop insights.benchmark_twrr_by_sector_sink sink

drop insights.benchmark_twrr_by_taxonomy_node_sink sink

drop insights.benchmark_twrr_by_asset_class_sink sink

drop insights.benchmark_twrr_by_asset_sink sink

drop insights.settled_position_valuations_sink sink

drop insights.settled_cash_balances_sink sink

drop insights.party_to_account_groups_sink sink

drop insights.account_groups_sink sink

drop insights.asset_distributions_sink sink

drop insights.benchmark_values_by_asset_class_sink sink

drop insights.benchmark_values_by_sector_sink sink

drop insights.benchmark_values_by_taxonomy_node_sink sink

drop insights.benchmark_values_by_region_sink sink

drop insights.asset_twrr_sink sink

drop insights.investment_accounts_ft_sink sink

drop insights.private_asset_valuations_sink sink

drop insights.settled_position_series_sink sink

drop insights.user_to_account_groups_sink sink

drop insights.client_to_account_groups_sink sink

drop insights.benchmark_values_by_currency_sink sink

drop insights.benchmark_twrr_sink sink

drop insights.transactions_sink sink

drop insights.portfolio_to_account_groups_sink sink

drop insights.assets_sink sink

drop insights.private_asset_holdings_sink sink

drop insights.benchmark_values_by_asset_sink sink

drop insights.accounts_sink sink

drop insights.portfolios_sink sink

drop insights.clients_sink sink

drop insights.account_to_portfolios_sink sink

Indexes (0)

—

Materialized views (86)

drop insights.pnl_by_distribution_mv mv

drop insights.twrr_by_distribution_mv mv

drop insights.pnl_by_asset_mv mv

drop insights.twrr_by_asset_mv mv

drop insights.twrr_by_currency_mv mv

drop insights.pnl_by_currency_mv mv

drop insights.twrr_by_asset_type_mv mv

drop insights.pnl_by_asset_type_mv mv

drop insights.position_by_distribution_mv mv

drop insights.position_by_asset_mv mv

drop insights.twrr_mv mv

drop insights.position_by_currency_mv mv

drop insights.pnl_summary_mv mv

drop insights.position_by_asset_type_mv mv

drop insights.asset_distributions_week_binned_mv mv

drop insights.position_summary_mv mv

drop insights.position_asset_values_mv mv

drop insights.position_values_mv mv

drop insights.position_snapshot_mv mv

drop insights.account_to_account_groups_binned_mv mv

drop insights.flow_by_transaction_type_mv mv

drop insights.holding_values_latest_mv mv

drop insights.flow_by_distribution_mv mv

drop insights.flow_summary_mv mv

drop insights.flow_by_asset_type_mv mv

drop insights.holding_values_mv mv

drop insights.flow_by_asset_mv mv

drop insights.flow_asset_values_mv mv

drop insights.flow_by_currency_mv mv

drop insights.orphan_accruals_mv mv

drop insights.holding_values_with_accruals_mv mv

drop insights.abor_settlement_positions_mv mv

drop insights.flow_values_mv mv

drop insights.accruals_agg_mv mv

drop insights.account_to_account_groups_settlement_binned_mv mv

drop insights.account_to_account_groups_membership_mv mv

drop insights.account_to_account_groups_txn_binned_mv mv

drop insights.benchmark_twrr_by_currency_mv mv

drop insights.benchmark_twrr_by_asset_type_mv mv

drop insights.benchmark_twrr_by_distribution_mv mv

drop insights.holding_values_raw_mv mv

drop insights.account_to_account_groups_mv mv

drop insights.benchmark_twrr_by_asset_mv mv

drop insights.settled_position_valuations_mv mv

drop insights.settled_cash_balances_mv mv

drop insights.cash_values_journal_density_mv mv

drop insights.holding_values_journal_density_mv mv

drop insights.party_to_account_groups_mv mv

drop insights.account_groups_mv mv

drop insights.asset_distributions_sink_input_mv mv

drop insights.benchmark_values_by_distribution_mv mv

drop insights.asset_twrr_mv mv

drop insights.asset_latest_price_mv mv

drop insights.investment_account_purchasing_power_mv mv

drop insights.private_asset_valuations_mv mv

drop insights.settled_cash_series_mv mv

drop insights.settled_position_series_mv mv

drop insights.user_to_account_groups_mv mv

drop insights.settled_cost_basis_series_mv mv

drop insights.settled_cost_basis_latest_mv mv

drop insights.party_account_group_types_mv mv

drop insights.client_account_group_types_mv mv

drop insights.benchmark_values_by_currency_mv mv

drop insights.asset_distributions_for_consumers_mv mv

drop insights.asset_price_with_lag_mv mv

drop insights.benchmark_twrr_mv mv

drop insights.fx_rates_snapshot_mv mv

drop insights.asset_prices_snapshot_mv mv

drop insights.asset_latest_yield_to_maturity_mv mv

drop insights.transactions_merged_mv mv

drop insights.user_account_membership_mv mv

drop insights.settled_cost_basis_carried_mv mv

drop insights.party_account_via_portfolio_mv mv

drop insights.client_account_via_portfolio_mv mv

drop insights.party_account_direct_mv mv

drop insights.portfolio_account_group_types_mv mv

drop insights.client_account_direct_mv mv

drop insights.benchmark_values_by_asset_sink__rwm_shim mv

drop insights.active_transaction_status_id_mv mv

drop insights.client_to_account_groups_mv mv

drop insights.portfolio_to_account_groups_mv mv

drop insights.user_to_portfolios_mv mv

drop insights.settled_cost_basis_dedup_mv mv

drop insights.open_accounts_mv mv

drop insights.user_to_clients_mv mv

drop insights.private_asset_holdings_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

4 · Confirm

Type the database name to confirm expected: integration-testing

I understand this is destructive and downstream consumers will lose data.

‹ cancel

RWM Console cluster: risingwave.platform.svc.cluster.local