Teardown · alinma_bff, authz, search

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

alinma_bff (alinma-bff) — 126 objects

Subscriptions (0)

—

Sinks (32)

drop alinma_bff.advisor_kpis_sink sink

drop alinma_bff.advisor_kpi_period_series_sink sink

drop alinma_bff.party_clients_sink sink

drop alinma_bff.unlinked_account_pairs_sink sink

drop alinma_bff.team_to_tasks_sink sink

drop alinma_bff.orders_sink sink

drop alinma_bff.notes_sink sink

drop alinma_bff.portfolios_sink sink

drop alinma_bff.clients_sink sink

drop alinma_bff.team_to_accounts_sink sink

drop alinma_bff.accounts_sink sink

drop alinma_bff.team_to_portfolios_sink sink

drop alinma_bff.marketplace_exposure_by_node_asset_sink sink

drop alinma_bff.report_position_date_boundaries_sink sink

drop alinma_bff.report_holdings_daily_sink sink

drop alinma_bff.report_twrr_daily_sink sink

drop alinma_bff.report_allocation_twrr_daily_sink sink

drop alinma_bff.report_allocation_daily_sink sink

drop alinma_bff.team_to_parties_sink sink

drop alinma_bff.report_flows_daily_sink sink

drop alinma_bff.marketplace_asset_taxonomy_sink sink

drop alinma_bff.expiring_identifiers_sink sink

drop alinma_bff.user_team_memberships_sink sink

drop alinma_bff.marketplace_exposure_by_asset_sink sink

drop alinma_bff.team_to_clients_sink sink

drop alinma_bff.report_pnl_daily_sink sink

drop alinma_bff.transactions_sink sink

drop alinma_bff.tasks_sink sink

drop alinma_bff.report_position_daily_sink sink

drop alinma_bff.marketplace_assets_sink sink

drop alinma_bff.opportunity_resources_sink sink

drop alinma_bff.marketplace_client_to_account_groups_sink sink

Indexes (0)

—

Materialized views (94)

drop alinma_bff.party_advisor_kpis_mv mv

drop alinma_bff.advisor_kpis_mv mv

drop alinma_bff.advisor_kpi_period_series_mv mv

drop alinma_bff.party_advisor_kpi_period_adds_mv mv

drop alinma_bff.advisor_kpi_counts_mv mv

drop alinma_bff.advisor_kpi_user_bucket_adds_mv mv

drop alinma_bff.advisor_kpi_values_mv mv

drop alinma_bff.advisor_kpi_period_account_value_series_mv mv

drop alinma_bff.advisor_kpi_period_pnl_series_mv mv

drop alinma_bff.advisor_kpi_period_balance_series_mv mv

drop alinma_bff.book_of_business_party_clients_mv mv

drop alinma_bff.unlinked_account_pairs_mv mv

drop alinma_bff.party_advisor_kpi_counts_mv mv

drop alinma_bff.party_advisor_kpi_values_mv mv

drop alinma_bff.party_advisor_kpi_recent_portfolio_users_mv mv

drop alinma_bff.party_advisor_kpi_period_values_mv mv

drop alinma_bff.advisor_kpi_period_fee_series_mv mv

drop alinma_bff.advisor_kpi_user_accounts_mv mv

drop alinma_bff.orders_mv mv

drop alinma_bff.advisor_kpi_account_value_buckets_mv mv

drop alinma_bff.advisor_kpi_portfolio_pnl_buckets_mv mv

drop alinma_bff.advisor_kpi_portfolio_balance_buckets_mv mv

drop alinma_bff.party_task_counts_mv mv

drop alinma_bff.account_primary_client_mv mv

drop alinma_bff.notes_mv mv

drop alinma_bff.book_of_business_portfolios_mv mv

drop alinma_bff.book_of_business_clients_mv mv

drop alinma_bff.party_advisor_kpi_recent_customer_users_mv mv

drop alinma_bff.party_advisor_kpi_user_accounts_mv mv

drop alinma_bff.party_advisor_kpi_user_portfolios_mv mv

drop alinma_bff.advisor_kpi_user_portfolios_mv mv

drop alinma_bff.order_execution_summaries_mv mv

drop alinma_bff.advisor_kpi_account_value_monthly_mv mv

drop alinma_bff.advisor_kpi_portfolio_pnl_growth_mv mv

drop alinma_bff.advisor_kpi_portfolio_pnl_monthly_mv mv

drop alinma_bff.advisor_kpi_portfolio_balance_monthly_mv mv

drop alinma_bff.advisor_kpi_portfolio_growth_mv mv

drop alinma_bff.party_task_unique_mv mv

drop alinma_bff.party_fee_totals_mv mv

drop alinma_bff.party_aum_mv mv

drop alinma_bff.party_account_owner_candidates_mv mv

drop alinma_bff.portfolio_owners_mv mv

drop alinma_bff.party_portfolio_counts_mv mv

drop alinma_bff.client_aum_mv mv

drop alinma_bff.book_of_business_accounts_mv mv

drop alinma_bff.party_advisor_kpi_user_customers_mv mv

drop alinma_bff.party_advisor_kpi_direct_user_portfolios_mv mv

drop alinma_bff.advisor_kpi_user_clients_mv mv

drop alinma_bff.advisor_kpi_portfolio_fee_buckets_mv mv

drop alinma_bff.advisor_kpi_portfolio_fee_mv mv

drop alinma_bff.marketplace_exposure_by_node_asset_mv mv

drop alinma_bff.order_execution_fee_lines_mv mv

drop alinma_bff.advisor_kpi_account_values_mv mv

drop alinma_bff.advisor_kpi_account_value_daily_mv mv

drop alinma_bff.advisor_kpi_portfolio_pnl_daily_mv mv

drop alinma_bff.advisor_kpi_portfolio_pnl_month_ends_mv mv

drop alinma_bff.report_position_date_boundaries_mv mv

drop alinma_bff.advisor_kpi_portfolio_balance_month_ends_mv mv

drop alinma_bff.advisor_kpi_portfolio_daily_mv mv

drop alinma_bff.party_active_customer_parties_mv mv

drop alinma_bff.party_current_account_membership_mv mv

drop alinma_bff.party_active_portfolio_involvements_mv mv

drop alinma_bff.report_holdings_daily_mv mv

drop alinma_bff.report_twrr_daily_mv mv

drop alinma_bff.investment_holdings_latest_mv mv

drop alinma_bff.advisor_kpi_entity_bucket_adds_mv mv

drop alinma_bff.report_allocation_twrr_daily_mv mv

drop alinma_bff.account_portfolios_mv mv

drop alinma_bff.account_owners_mv mv

drop alinma_bff.account_latest_facts_mv mv

drop alinma_bff.account_task_counts_mv mv

drop alinma_bff.report_allocation_daily_mv mv

drop alinma_bff.client_contact_counts_mv mv

drop alinma_bff.client_fee_totals_mv mv

drop alinma_bff.client_reference_identifiers_mv mv

drop alinma_bff.client_task_counts_mv mv

drop alinma_bff.report_flows_daily_mv mv

drop alinma_bff.marketplace_asset_taxonomy_mv mv

drop alinma_bff.party_reference_identifiers_mv mv

drop alinma_bff.client_portfolio_counts_mv mv

drop alinma_bff.order_executions_bounded_mv mv

drop alinma_bff.expiring_identifiers_mv mv

drop alinma_bff.advisor_kpi_account_product_class_mv mv

drop alinma_bff.marketplace_exposure_by_asset_mv mv

drop alinma_bff.portfolio_task_counts_mv mv

drop alinma_bff.portfolio_reference_identifiers_mv mv

drop alinma_bff.report_pnl_daily_mv mv

drop alinma_bff.book_of_business_transactions_mv mv

drop alinma_bff.tasks_mv mv

drop alinma_bff.report_position_daily_mv mv

drop alinma_bff.party_active_customer_relationships_mv mv

drop alinma_bff.party_contact_counts_mv mv

drop alinma_bff.account_reference_identifiers_mv mv

drop alinma_bff.marketplace_assets_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

authz — 32 objects

Subscriptions (12)

drop authz.authz_active_clients_to_teams_sub subscription

drop authz.authz_active_clients_goals_sub subscription

drop authz.authz_active_orders_sub subscription

drop authz.authz_active_parties_to_accounts_sub subscription

drop authz.authz_active_accounts_to_clients_sub subscription

drop authz.authz_active_portfolio_policies_to_portfolios_sub subscription

drop authz.authz_active_portfolios_to_teams_sub subscription

drop authz.authz_active_clients_portfolios_sub subscription

drop authz.authz_active_parties_to_portfolios_sub subscription

drop authz.authz_active_party_memberships_sub subscription

drop authz.authz_active_teams_memberships_sub subscription

drop authz.authz_active_account_to_portfolios_sub subscription

Sinks (0)

—

Indexes (0)

—

Materialized views (19)

drop authz.team_to_tasks_mv mv

drop authz.team_to_accounts_mv mv

drop authz.active_clients_to_teams_mv mv

drop authz.active_portfolios_to_teams_mv mv

drop authz.active_party_memberships_mv mv

drop authz.team_to_portfolios_mv mv

drop authz.active_accounts_to_clients_mv mv

drop authz.active_account_to_portfolios_mv mv

drop authz.active_portfolio_policies_to_portfolios_mv mv

drop authz.active_clients_goals_mv mv

drop authz.active_clients_portfolios_mv mv

drop authz.active_orders_mv mv

drop authz.active_parties_to_accounts_mv mv

drop authz.active_entity_to_teams_mv mv

drop authz.active_teams_memberships_mv mv

drop authz.active_parties_to_portfolios_mv mv

drop authz.team_to_parties_mv mv

drop authz.user_team_memberships_mv mv

drop authz.team_to_clients_mv mv

Tables (1)

drop authz.subscription_progress table

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.user_team_memberships_sink sink

drop search.team_to_parties_sink sink

drop search.team_to_clients_sink sink

Indexes (0)

—

Materialized views (11)

drop search.items_mv mv

drop search.party_items_mv mv

drop search.party_identifier_edges_mv mv

drop search.active_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.olap_reference_identifier_terms_mv mv

drop search.party_reference_identifier_terms_mv mv

drop search.active_parties_mv mv

drop search.party_active_relationships_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

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