Teardown · adib_rm, authz, ibor, insights, insights-intraday, search

← cluster adib_qa teardown

Teardown — database adib_qa

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

1 · Apps

adib-read-models (adib_rm) authz ibor insights insights-intraday search audit never deployed audit-platform (audit_platform) 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 262 objects · scope = all

adib_rm (adib-read-models) — 41 objects

Subscriptions (0)

—

Sinks (10)

drop adib_rm.sdk_home_overview_sink sink

drop adib_rm.sdk_home_overview_party_sink sink

drop adib_rm.sdk_portfolio_chart_sink sink

drop adib_rm.sdk_activity_enriched_sink sink

drop adib_rm.sdk_activity_enriched_party_sink sink

drop adib_rm.sdk_asset_enrichment_sink sink

drop adib_rm.holding_breaks_sink sink

drop adib_rm.settlement_orders_sink sink

drop adib_rm.cash_holds_sink sink

drop adib_rm.holding_candidates_sink sink

Indexes (0)

—

Materialized views (31)

drop adib_rm.sdk_home_overview_mv mv

drop adib_rm.sdk_home_overview_party_mv mv

drop adib_rm.client_portfolios_mv mv

drop adib_rm.party_portfolios_mv mv

drop adib_rm.party_top_allocations_mv mv

drop adib_rm.client_top_allocations_by_sector_mv mv

drop adib_rm.party_top_allocations_by_sector_mv mv

drop adib_rm.client_top_allocations_mv mv

drop adib_rm.party_top_allocations_by_asset_type_mv mv

drop adib_rm.client_top_allocations_by_asset_type_mv mv

drop adib_rm.sdk_portfolio_chart_mv mv

drop adib_rm.pnl_snapshot_mv mv

drop adib_rm.party_cash_tiles_mv mv

drop adib_rm.client_cash_tiles_mv mv

drop adib_rm.sdk_activity_enriched_mv mv

drop adib_rm.sdk_activity_enriched_party_mv mv

drop adib_rm.investment_account_balance_snapshot_journal_mv mv

drop adib_rm.activity_transaction_portfolios_mv mv

drop adib_rm.activity_transaction_account_portfolio_links_mv mv

drop adib_rm.sdk_asset_enrichment_mv mv

drop adib_rm.sdk_activity_transactions_merged_mv mv

drop adib_rm.activity_order_events_mv mv

drop adib_rm.holding_breaks_mv mv

drop adib_rm.settlement_orders_mv mv

drop adib_rm.cash_holds_mv mv

drop adib_rm.active_transaction_status_id_mv mv

drop adib_rm.sdk_order_execution_aggregates_mv mv

drop adib_rm.investment_account_balance_snapshot_mv mv

drop adib_rm.accounts_plain_mv mv

drop adib_rm.cash_product_type_ids_mv mv

drop adib_rm.portfolios_plain_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

authz — 28 objects

Subscriptions (11)

drop authz.authz_active_accounts_to_clients_sub subscription

drop authz.authz_active_portfolios_to_teams_sub subscription

drop authz.authz_team_to_parties_sub subscription

drop authz.authz_active_orders_sub subscription

drop authz.authz_active_teams_memberships_sub subscription

drop authz.authz_active_parties_to_accounts_sub subscription

drop authz.authz_active_party_direct_memberships_sub subscription

drop authz.authz_active_clients_portfolios_sub subscription

drop authz.authz_active_clients_to_teams_sub subscription

drop authz.authz_active_parties_to_portfolios_sub subscription

drop authz.authz_active_account_to_portfolios_sub subscription

Sinks (0)

—

Indexes (0)

—

Materialized views (16)

drop authz.team_to_accounts_mv mv

drop authz.team_to_portfolios_mv mv

drop authz.active_portfolios_to_teams_mv mv

drop authz.active_clients_to_teams_mv mv

drop authz.user_team_memberships_mv mv

drop authz.active_account_to_portfolios_mv mv

drop authz.active_party_direct_memberships_mv mv

drop authz.active_accounts_to_clients_mv mv

drop authz.active_clients_portfolios_mv mv

drop authz.team_to_parties_mv mv

drop authz.team_to_clients_mv mv

drop authz.active_orders_mv mv

drop authz.active_parties_to_accounts_mv mv

drop authz.active_teams_memberships_mv mv

drop authz.active_parties_to_portfolios_mv mv

drop authz.active_entity_to_teams_mv mv

Tables (1)

drop authz.subscription_progress table

Sources (0)

—

Functions (0)

—

ibor — 0 objects

Subscriptions (0)

—

Sinks (0)

—

Indexes (0)

—

Materialized views (0)

—

Tables (0)

—

Sources (0)

—

Functions (0)

—

insights — 176 objects

Subscriptions (0)

—

Sinks (76)

drop insights.pnl_by_taxonomy_sink sink

drop insights.pnl_by_sector_sink sink

drop insights.pnl_by_asset_class_sink sink

drop insights.pnl_by_region_sink sink

drop insights.twrr_by_region_sink sink

drop insights.twrr_by_taxonomy_node_sink sink

drop insights.twrr_by_sector_sink sink

drop insights.twrr_by_asset_class_sink sink

drop insights.twrr_by_asset_type_sink sink

drop insights.pnl_by_asset_type_sink sink

drop insights.twrr_by_asset_sink sink

drop insights.pnl_by_asset_sink sink

drop insights.pnl_by_currency_sink sink

drop insights.twrr_by_currency_sink sink

drop insights.intraday_position_by_currency_sink sink

drop insights.intraday_position_by_asset_sink sink

drop insights.intraday_position_by_asset_class_sink sink

drop insights.intraday_position_by_sector_sink sink

drop insights.intraday_position_by_region_sink sink

drop insights.intraday_position_by_asset_type_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_region_sink sink

drop insights.position_by_asset_type_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.intraday_position_summary_sink sink

drop insights.position_summary_sink sink

drop insights.flow_by_transaction_type_sink sink

drop insights.flow_by_asset_type_sink sink

drop insights.flow_by_asset_class_sink sink

drop insights.flow_by_taxonomy_node_sink sink

drop insights.flow_by_region_sink sink

drop insights.flow_by_sector_sink sink

drop insights.flow_summary_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.settled_position_valuations_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.account_groups_sink sink

drop insights.party_to_account_groups_sink sink

drop insights.settled_cash_balances_sink sink

drop insights.user_to_account_groups_sink sink

drop insights.benchmark_twrr_by_asset_sink sink

drop insights.client_to_account_groups_sink sink

drop insights.settled_position_series_sink sink

drop insights.asset_twrr_sink sink

drop insights.portfolio_to_account_groups_sink sink

drop insights.benchmark_values_by_asset_class_sink sink

drop insights.benchmark_values_by_sector_sink sink

drop insights.benchmark_values_by_region_sink sink

drop insights.benchmark_values_by_taxonomy_node_sink sink

drop insights.asset_distributions_sink sink

drop insights.transactions_sink sink

drop insights.private_asset_valuations_sink sink

drop insights.investment_accounts_ft_sink sink

drop insights.benchmark_twrr_sink sink

drop insights.private_asset_holdings_sink sink

drop insights.benchmark_values_by_currency_sink sink

drop insights.clients_sink sink

drop insights.assets_sink sink

drop insights.account_to_portfolios_sink sink

drop insights.benchmark_values_by_asset_sink sink

drop insights.portfolios_sink sink

drop insights.accounts_sink sink

Indexes (0)

—

Materialized views (100)

drop insights.pnl_by_distribution_mv mv

drop insights.twrr_by_distribution_mv mv

drop insights.twrr_by_asset_type_mv mv

drop insights.pnl_by_asset_type_mv mv

drop insights.twrr_by_asset_mv mv

drop insights.pnl_by_asset_mv mv

drop insights.pnl_by_currency_mv mv

drop insights.twrr_by_currency_mv mv

drop insights.intraday_position_by_currency_mv mv

drop insights.intraday_position_by_asset_mv mv

drop insights.intraday_position_by_distribution_mv mv

drop insights.intraday_position_by_asset_type_mv mv

drop insights.position_by_distribution_mv mv

drop insights.position_by_asset_type_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.intraday_position_summary_mv mv

drop insights.asset_distributions_week_binned_mv mv

drop insights.position_summary_mv mv

drop insights.intraday_position_asset_values_mv mv

drop insights.position_asset_values_mv mv

drop insights.position_snapshot_mv mv

drop insights.intraday_position_values_mv mv

drop insights.position_values_mv mv

drop insights.flow_by_transaction_type_mv mv

drop insights.holding_values_latest_mv mv

drop insights.account_to_account_groups_binned_mv mv

drop insights.flow_by_asset_type_mv mv

drop insights.flow_by_distribution_mv mv

drop insights.flow_summary_mv mv

drop insights.holding_values_mv mv

drop insights.flow_asset_values_mv mv

drop insights.flow_by_asset_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_txn_binned_mv mv

drop insights.account_to_account_groups_membership_mv mv

drop insights.holding_values_raw_mv mv

drop insights.account_to_account_groups_mv mv

drop insights.settled_position_valuations_mv mv

drop insights.holding_values_journal_density_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.account_groups_mv mv

drop insights.party_to_account_groups_mv mv

drop insights.settled_cash_balances_mv mv

drop insights.cash_values_journal_density_mv mv

drop insights.user_to_account_groups_mv mv

drop insights.settled_cost_basis_latest_mv mv

drop insights.settled_cost_basis_series_mv mv

drop insights.benchmark_twrr_by_asset_mv mv

drop insights.client_account_group_types_mv mv

drop insights.party_account_group_types_mv mv

drop insights.settled_cash_series_mv mv

drop insights.settled_position_series_mv mv

drop insights.user_account_membership_mv mv

drop insights.settled_cost_basis_carried_mv mv

drop insights.asset_latest_price_mv mv

drop insights.asset_twrr_mv mv

drop insights.intraday_fx_rates_latest_mv mv

drop insights.intraday_asset_prices_latest_mv mv

drop insights.portfolio_account_group_types_mv mv

drop insights.client_account_via_portfolio_mv mv

drop insights.party_account_direct_mv mv

drop insights.party_account_via_portfolio_mv mv

drop insights.client_account_direct_mv mv

drop insights.benchmark_values_by_distribution_mv mv

drop insights.asset_distributions_sink_input_mv mv

drop insights.transactions_merged_mv mv

drop insights.private_asset_valuations_mv mv

drop insights.investment_account_purchasing_power_mv mv

drop insights.user_to_portfolios_mv mv

drop insights.benchmark_values_by_asset_sink__rwm_shim mv

drop insights.benchmark_twrr_mv mv

drop insights.private_asset_holdings_mv mv

drop insights.settled_cost_basis_dedup_mv mv

drop insights.benchmark_values_by_currency_mv mv

drop insights.asset_price_with_lag_mv mv

drop insights.asset_latest_yield_to_maturity_mv mv

drop insights.intraday_fx_rates_5min_mv mv

drop insights.portfolio_to_account_groups_mv mv

drop insights.intraday_asset_prices_5min_mv mv

drop insights.asset_prices_snapshot_mv mv

drop insights.client_to_account_groups_mv mv

drop insights.open_accounts_mv mv

drop insights.user_to_clients_mv mv

drop insights.asset_distributions_for_consumers_mv mv

drop insights.active_transaction_status_id_mv mv

drop insights.fx_rates_snapshot_mv mv

drop insights.intraday_holding_event_times_mv mv

drop insights.intraday_holdings_latest_mv mv

drop insights.intraday_settled_baseline_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

insights-intraday — 0 objects

Subscriptions (0)

—

Sinks (0)

—

Indexes (0)

—

Materialized views (0)

—

Tables (0)

—

Sources (0)

—

Functions (0)

—

search — 17 objects

Subscriptions (0)

—

Sinks (6)

drop search.items_sink sink

drop search.team_to_accounts_sink sink

drop search.team_to_portfolios_sink sink

drop search.team_to_parties_sink sink

drop search.team_to_clients_sink sink

drop search.user_team_memberships_sink sink

Indexes (0)

—

Materialized views (11)

drop search.items_mv mv

drop search.party_items_mv mv

drop search.active_identifier_edges_mv mv

drop search.party_identifier_edges_mv mv

drop search.party_filter_tags_mv mv

drop search.party_holder_edges_mv mv

drop search.party_customer_parties_mv mv

drop search.party_active_relationships_mv mv

drop search.active_parties_mv mv

drop search.olap_reference_identifier_terms_mv mv

drop search.party_reference_identifier_terms_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

4 · Confirm

Type the database name to confirm expected: adib_qa

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

‹ cancel

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