Teardown · ai_hub_bff, alpheya_agent, alpheya_experience_bff, authz, ibor, insights, opportunity, search

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

ai_hub_bff (ai-hub-bff) — 10 objects

Subscriptions (0)

—

Sinks (9)

drop ai_hub_bff.opportunity_resources_sink sink

drop ai_hub_bff.team_to_accounts_sink sink

drop ai_hub_bff.team_to_portfolios_sink sink

drop ai_hub_bff.ai_hub_clients_sink sink

drop ai_hub_bff.clients_sink sink

drop ai_hub_bff.team_to_clients_sink sink

drop ai_hub_bff.ai_hub_team_to_clients_sink sink

drop ai_hub_bff.ai_hub_user_team_memberships_sink sink

drop ai_hub_bff.user_team_memberships_sink sink

Indexes (0)

—

Materialized views (1)

drop ai_hub_bff.book_of_business_clients_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

alpheya_agent (alpheya-agent) — 18 objects

Subscriptions (0)

—

Sinks (12)

drop alpheya_agent.party_position_by_asset_sink sink

drop alpheya_agent.party_position_by_asset_type_sink sink

drop alpheya_agent.team_to_tasks_sink sink

drop alpheya_agent.team_to_accounts_sink sink

drop alpheya_agent.team_to_portfolios_sink sink

drop alpheya_agent.team_to_parties_sink sink

drop alpheya_agent.fx_rates_eod_sink sink

drop alpheya_agent.tasks_sink sink

drop alpheya_agent.user_team_memberships_sink sink

drop alpheya_agent.transactions_sink sink

drop alpheya_agent.party_clients_sink sink

drop alpheya_agent.portfolios_sink sink

Indexes (0)

—

Materialized views (6)

drop alpheya_agent.party_position_by_asset_mv mv

drop alpheya_agent.party_position_by_asset_type_mv mv

drop alpheya_agent.fx_rates_eod_mv mv

drop alpheya_agent.tasks_mv mv

drop alpheya_agent.transactions_mv mv

drop alpheya_agent.book_of_business_party_clients_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

alpheya_experience_bff (alpheya-experience-bff) — 67 objects

Subscriptions (0)

—

Sinks (23)

drop alpheya_experience_bff.opportunity_resources_sink sink

drop alpheya_experience_bff.report_allocation_twrr_daily_sink sink

drop alpheya_experience_bff.report_twrr_daily_sink sink

drop alpheya_experience_bff.report_pnl_daily_sink sink

drop alpheya_experience_bff.report_holdings_daily_sink sink

drop alpheya_experience_bff.report_position_date_boundaries_sink sink

drop alpheya_experience_bff.report_allocation_daily_sink sink

drop alpheya_experience_bff.report_position_daily_sink sink

drop alpheya_experience_bff.clients_sink sink

drop alpheya_experience_bff.party_clients_sink sink

drop alpheya_experience_bff.report_flows_daily_sink sink

drop alpheya_experience_bff.advisor_kpis_sink sink

drop alpheya_experience_bff.portfolios_sink sink

drop alpheya_experience_bff.accounts_sink sink

drop alpheya_experience_bff.transactions_sink sink

drop alpheya_experience_bff.team_to_tasks_sink sink

drop alpheya_experience_bff.team_to_accounts_sink sink

drop alpheya_experience_bff.team_to_portfolios_sink sink

drop alpheya_experience_bff.tasks_sink sink

drop alpheya_experience_bff.team_to_parties_sink sink

drop alpheya_experience_bff.team_to_clients_sink sink

drop alpheya_experience_bff.user_team_memberships_sink sink

drop alpheya_experience_bff.orders_sink sink

Indexes (0)

—

Materialized views (44)

drop alpheya_experience_bff.report_allocation_twrr_daily_mv mv

drop alpheya_experience_bff.report_twrr_daily_mv mv

drop alpheya_experience_bff.report_pnl_daily_mv mv

drop alpheya_experience_bff.report_holdings_daily_mv mv

drop alpheya_experience_bff.report_position_date_boundaries_mv mv

drop alpheya_experience_bff.report_allocation_daily_mv mv

drop alpheya_experience_bff.report_position_daily_mv mv

drop alpheya_experience_bff.book_of_business_clients_mv mv

drop alpheya_experience_bff.book_of_business_party_clients_mv mv

drop alpheya_experience_bff.report_flows_daily_mv mv

drop alpheya_experience_bff.client_fee_totals_mv mv

drop alpheya_experience_bff.party_fee_totals_mv mv

drop alpheya_experience_bff.advisor_kpis_mv mv

drop alpheya_experience_bff.book_of_business_portfolios_mv mv

drop alpheya_experience_bff.client_aum_mv mv

drop alpheya_experience_bff.book_of_business_accounts_mv mv

drop alpheya_experience_bff.party_aum_mv mv

drop alpheya_experience_bff.advisor_kpi_values_mv mv

drop alpheya_experience_bff.book_of_business_transactions_mv mv

drop alpheya_experience_bff.advisor_kpi_account_values_mv mv

drop alpheya_experience_bff.investment_holdings_latest_mv mv

drop alpheya_experience_bff.advisor_kpi_counts_mv mv

drop alpheya_experience_bff.advisor_kpi_user_accounts_mv mv

drop alpheya_experience_bff.party_task_counts_mv mv

drop alpheya_experience_bff.party_task_unique_mv mv

drop alpheya_experience_bff.portfolio_owners_mv mv

drop alpheya_experience_bff.party_portfolio_counts_mv mv

drop alpheya_experience_bff.account_owners_mv mv

drop alpheya_experience_bff.account_portfolios_mv mv

drop alpheya_experience_bff.party_active_customer_parties_mv mv

drop alpheya_experience_bff.party_active_portfolio_involvements_mv mv

drop alpheya_experience_bff.client_contact_counts_mv mv

drop alpheya_experience_bff.tasks_mv mv

drop alpheya_experience_bff.portfolio_task_counts_mv mv

drop alpheya_experience_bff.party_reference_identifiers_mv mv

drop alpheya_experience_bff.client_reference_identifiers_mv mv

drop alpheya_experience_bff.client_task_counts_mv mv

drop alpheya_experience_bff.account_task_counts_mv mv

drop alpheya_experience_bff.portfolio_reference_identifiers_mv mv

drop alpheya_experience_bff.account_reference_identifiers_mv mv

drop alpheya_experience_bff.orders_mv mv

drop alpheya_experience_bff.party_active_customer_relationships_mv mv

drop alpheya_experience_bff.client_portfolio_counts_mv mv

drop alpheya_experience_bff.account_latest_facts_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

authz — 28 objects

Subscriptions (10)

drop authz.authz_active_teams_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_accounts_to_clients_sub subscription

drop authz.authz_active_portfolios_to_teams_sub subscription

drop authz.authz_active_party_memberships_sub subscription

drop authz.authz_active_account_to_portfolios_sub subscription

drop authz.authz_active_orders_sub subscription

drop authz.authz_active_parties_to_accounts_sub subscription

Sinks (0)

—

Indexes (0)

—

Materialized views (17)

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.team_to_portfolios_mv mv

drop authz.active_party_memberships_mv mv

drop authz.active_entity_to_teams_mv mv

drop authz.team_to_parties_mv mv

drop authz.active_accounts_to_clients_mv mv

drop authz.team_to_clients_mv mv

drop authz.user_team_memberships_mv mv

drop authz.active_parties_to_portfolios_mv mv

drop authz.active_parties_to_accounts_mv mv

drop authz.active_clients_portfolios_mv mv

drop authz.active_account_to_portfolios_mv mv

drop authz.active_teams_memberships_mv mv

drop authz.active_orders_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 — 151 objects

Subscriptions (0)

—

Sinks (69)

drop insights.twrr_by_currency_sink sink

drop insights.pnl_by_currency_sink sink

drop insights.pnl_by_asset_sink sink

drop insights.twrr_by_asset_sink sink

drop insights.twrr_by_asset_type_sink sink

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

drop insights.pnl_by_taxonomy_sink sink

drop insights.pnl_by_region_sink sink

drop insights.pnl_by_asset_class_sink sink

drop insights.pnl_by_sector_sink sink

drop insights.twrr_sink sink

drop insights.pnl_summary_sink sink

drop insights.position_by_currency_sink sink

drop insights.position_by_asset_sink sink

drop insights.position_by_asset_type_sink sink

drop insights.position_by_asset_class_sink sink

drop insights.position_by_region_sink sink

drop insights.position_by_sector_sink sink

drop insights.position_by_taxonomy_node_sink sink

drop insights.flow_summary_sink sink

drop insights.flow_by_asset_type_sink sink

drop insights.flow_by_sector_sink sink

drop insights.flow_by_taxonomy_node_sink sink

drop insights.flow_by_asset_class_sink sink

drop insights.flow_by_region_sink sink

drop insights.position_summary_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.flow_by_transaction_type_sink sink

drop insights.account_to_account_groups_sink sink

drop insights.benchmark_twrr_by_taxonomy_node_sink sink

drop insights.benchmark_twrr_by_sector_sink sink

drop insights.benchmark_twrr_by_region_sink sink

drop insights.benchmark_twrr_by_asset_class_sink sink

drop insights.benchmark_twrr_by_currency_sink sink

drop insights.benchmark_twrr_by_asset_type_sink sink

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

drop insights.benchmark_twrr_by_asset_sink sink

drop insights.user_to_account_groups_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.transactions_sink sink

drop insights.investment_accounts_ft_sink sink

drop insights.private_asset_valuations_sink sink

drop insights.asset_distributions_sink sink

drop insights.benchmark_values_by_taxonomy_node_sink sink

drop insights.benchmark_values_by_region_sink sink

drop insights.benchmark_values_by_sector_sink sink

drop insights.benchmark_values_by_asset_class_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.portfolios_sink sink

drop insights.clients_sink sink

drop insights.accounts_sink sink

drop insights.assets_sink sink

drop insights.benchmark_values_by_asset_sink sink

drop insights.account_to_portfolios_sink sink

Indexes (0)

—

Materialized views (82)

drop insights.twrr_by_currency_mv mv

drop insights.pnl_by_currency_mv mv

drop insights.pnl_by_asset_mv mv

drop insights.twrr_by_asset_mv mv

drop insights.twrr_by_asset_type_mv mv

drop insights.pnl_by_asset_type_mv mv

drop insights.twrr_by_distribution_mv mv

drop insights.pnl_by_distribution_mv mv

drop insights.twrr_mv mv

drop insights.pnl_summary_mv mv

drop insights.position_by_currency_mv mv

drop insights.position_by_asset_mv mv

drop insights.position_by_asset_type_mv mv

drop insights.position_by_distribution_mv mv

drop insights.flow_summary_mv mv

drop insights.flow_by_asset_type_mv mv

drop insights.flow_by_distribution_mv mv

drop insights.position_summary_mv mv

drop insights.asset_distributions_week_binned_mv mv

drop insights.flow_by_asset_mv mv

drop insights.flow_by_currency_mv mv

drop insights.flow_asset_values_mv mv

drop insights.position_asset_values_mv mv

drop insights.abor_settlement_positions_mv mv

drop insights.flow_by_transaction_type_mv mv

drop insights.flow_values_mv mv

drop insights.position_values_mv mv

drop insights.account_to_account_groups_membership_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_binned_mv mv

drop insights.position_snapshot_mv mv

drop insights.account_to_account_groups_mv mv

drop insights.holding_values_latest_mv mv

drop insights.benchmark_twrr_by_distribution_mv mv

drop insights.benchmark_twrr_by_currency_mv mv

drop insights.benchmark_twrr_by_asset_type_mv mv

drop insights.settled_position_valuations_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.holding_values_mv mv

drop insights.benchmark_twrr_by_asset_mv mv

drop insights.user_to_account_groups_mv mv

drop insights.settled_cost_basis_latest_mv mv

drop insights.client_account_group_types_mv mv

drop insights.party_account_group_types_mv mv

drop insights.settled_position_series_mv mv

drop insights.settled_cash_series_mv mv

drop insights.orphan_accruals_mv mv

drop insights.holding_values_with_accruals_mv mv

drop insights.asset_twrr_mv mv

drop insights.asset_latest_price_mv mv

drop insights.user_account_membership_mv mv

drop insights.settled_cost_basis_carried_mv mv

drop insights.client_account_via_portfolio_mv mv

drop insights.party_account_direct_mv mv

drop insights.client_account_direct_mv mv

drop insights.party_account_via_portfolio_mv mv

drop insights.portfolio_account_group_types_mv mv

drop insights.transactions_merged_mv mv

drop insights.investment_account_purchasing_power_mv mv

drop insights.private_asset_valuations_mv mv

drop insights.asset_distributions_sink_input_mv mv

drop insights.benchmark_values_by_distribution_mv mv

drop insights.accruals_agg_mv mv

drop insights.asset_price_with_lag_mv mv

drop insights.user_to_clients_mv mv

drop insights.benchmark_twrr_mv mv

drop insights.asset_prices_snapshot_mv mv

drop insights.asset_latest_yield_to_maturity_mv mv

drop insights.settled_cost_basis_dedup_mv mv

drop insights.portfolio_to_account_groups_mv mv

drop insights.user_to_portfolios_mv mv

drop insights.client_to_account_groups_mv mv

drop insights.open_accounts_mv mv

drop insights.private_asset_holdings_mv mv

drop insights.active_transaction_status_id_mv mv

drop insights.benchmark_values_by_currency_mv mv

drop insights.fx_rates_snapshot_mv mv

drop insights.asset_distributions_for_consumers_mv mv

drop insights.holding_values_raw_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

opportunity — 27 objects

Subscriptions (0)

—

Sinks (0)

—

Indexes (0)

—

Materialized views (27)

drop opportunity.opportunity_resources_mv mv

drop opportunity.signal_portfolio_unrealized_loss_mv mv

drop opportunity.signal_portfolio_fx_exposure_mv mv

drop opportunity.signal_portfolio_extreme_holding_mv mv

drop opportunity.signal_portfolio_extreme_sector_mv mv

drop opportunity.signal_portfolio_allocation_drift_mv mv

drop opportunity.portfolio_unrealized_loss_delta_mv mv

drop opportunity.signal_account_balance_increase_mv mv

drop opportunity.signal_account_balance_decrease_mv mv

drop opportunity.portfolio_fx_exposure_delta_mv mv

drop opportunity.portfolio_extreme_holding_breaches_mv mv

drop opportunity.signal_portfolio_balance_increase_mv mv

drop opportunity.signal_portfolio_balance_decrease_mv mv

drop opportunity.portfolio_extreme_sector_breaches_mv mv

drop opportunity.portfolio_allocation_drift_breaches_mv mv

drop opportunity.account_balance_delta_mv mv

drop opportunity.portfolio_balance_delta_mv mv

drop opportunity.portfolio_idle_cash_breaches_mv mv

drop opportunity.portfolio_cash_ratio_mv mv

drop opportunity.signal_account_bond_maturity_mv mv

drop opportunity.deposit_maturity_breaches_mv mv

drop opportunity.account_bond_maturity_breaches_mv mv

drop opportunity.signal_portfolio_days_since_transaction_mv mv

drop opportunity.portfolio_days_since_transaction_breaches_mv mv

drop opportunity.portfolio_last_transaction_mv mv

drop opportunity.opportunity_metadata_mv mv

drop opportunity.opportunity_conditions_mv mv

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_reference_identifier_terms_mv mv

drop search.olap_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-ai-hub-int.ai-hub-rwm.svc.cluster.local