Teardown · alinma_bff, alinma-bff-opportunities, authz, ibor, insights, opportunity, search

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

alinma_bff (alinma-bff) — 126 objects

Subscriptions (0)

—

Sinks (32)

drop alinma_bff.advisor_kpi_period_series_sink sink

drop alinma_bff.opportunity_resources_sink sink

drop alinma_bff.marketplace_exposure_by_node_asset_sink sink

drop alinma_bff.report_allocation_twrr_daily_sink sink

drop alinma_bff.report_pnl_daily_sink sink

drop alinma_bff.report_holdings_daily_sink sink

drop alinma_bff.marketplace_exposure_by_asset_sink sink

drop alinma_bff.report_twrr_daily_sink sink

drop alinma_bff.report_allocation_daily_sink sink

drop alinma_bff.report_position_date_boundaries_sink sink

drop alinma_bff.report_position_daily_sink sink

drop alinma_bff.clients_sink sink

drop alinma_bff.report_flows_daily_sink sink

drop alinma_bff.party_clients_sink sink

drop alinma_bff.advisor_kpis_sink sink

drop alinma_bff.portfolios_sink sink

drop alinma_bff.accounts_sink sink

drop alinma_bff.transactions_sink sink

drop alinma_bff.unlinked_account_pairs_sink sink

drop alinma_bff.orders_sink sink

drop alinma_bff.notes_sink sink

drop alinma_bff.team_to_tasks_sink sink

drop alinma_bff.marketplace_client_to_account_groups_sink sink

drop alinma_bff.team_to_accounts_sink sink

drop alinma_bff.marketplace_assets_sink sink

drop alinma_bff.team_to_portfolios_sink sink

drop alinma_bff.marketplace_asset_taxonomy_sink sink

drop alinma_bff.tasks_sink sink

drop alinma_bff.team_to_clients_sink sink

drop alinma_bff.team_to_parties_sink sink

drop alinma_bff.expiring_identifiers_sink sink

drop alinma_bff.user_team_memberships_sink sink

Indexes (0)

—

Materialized views (94)

drop alinma_bff.advisor_kpi_period_series_mv mv

drop alinma_bff.party_advisor_kpis_mv mv

drop alinma_bff.advisor_kpi_period_pnl_series_mv mv

drop alinma_bff.party_advisor_kpi_period_values_mv mv

drop alinma_bff.advisor_kpi_portfolio_pnl_buckets_mv mv

drop alinma_bff.advisor_kpi_period_balance_series_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_buckets_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.marketplace_exposure_by_node_asset_mv mv

drop alinma_bff.report_allocation_twrr_daily_mv mv

drop alinma_bff.advisor_kpi_portfolio_balance_monthly_mv mv

drop alinma_bff.advisor_kpi_portfolio_growth_mv mv

drop alinma_bff.report_pnl_daily_mv mv

drop alinma_bff.report_holdings_daily_mv mv

drop alinma_bff.marketplace_exposure_by_asset_mv mv

drop alinma_bff.report_twrr_daily_mv mv

drop alinma_bff.report_allocation_daily_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.report_position_date_boundaries_mv mv

drop alinma_bff.report_position_daily_mv mv

drop alinma_bff.advisor_kpi_period_fee_series_mv mv

drop alinma_bff.advisor_kpi_portfolio_fee_buckets_mv mv

drop alinma_bff.advisor_kpi_portfolio_fee_mv mv

drop alinma_bff.book_of_business_clients_mv mv

drop alinma_bff.report_flows_daily_mv mv

drop alinma_bff.client_fee_totals_mv mv

drop alinma_bff.advisor_kpi_period_account_value_series_mv mv

drop alinma_bff.book_of_business_party_clients_mv mv

drop alinma_bff.advisor_kpis_mv mv

drop alinma_bff.book_of_business_portfolios_mv mv

drop alinma_bff.client_aum_mv mv

drop alinma_bff.book_of_business_accounts_mv mv

drop alinma_bff.advisor_kpi_account_value_buckets_mv mv

drop alinma_bff.party_aum_mv mv

drop alinma_bff.advisor_kpi_values_mv mv

drop alinma_bff.party_advisor_kpi_values_mv mv

drop alinma_bff.book_of_business_transactions_mv mv

drop alinma_bff.advisor_kpi_account_value_monthly_mv mv

drop alinma_bff.investment_holdings_latest_mv mv

drop alinma_bff.advisor_kpi_account_values_mv mv

drop alinma_bff.party_advisor_kpi_period_adds_mv mv

drop alinma_bff.unlinked_account_pairs_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_account_value_daily_mv mv

drop alinma_bff.orders_mv mv

drop alinma_bff.party_advisor_kpi_counts_mv mv

drop alinma_bff.party_task_counts_mv mv

drop alinma_bff.party_advisor_kpi_recent_portfolio_users_mv mv

drop alinma_bff.account_primary_client_mv mv

drop alinma_bff.notes_mv mv

drop alinma_bff.advisor_kpi_user_accounts_mv mv

drop alinma_bff.order_execution_summaries_mv mv

drop alinma_bff.party_fee_totals_mv mv

drop alinma_bff.party_advisor_kpi_user_accounts_mv mv

drop alinma_bff.party_task_unique_mv mv

drop alinma_bff.party_advisor_kpi_recent_customer_users_mv mv

drop alinma_bff.party_advisor_kpi_user_portfolios_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.advisor_kpi_user_portfolios_mv mv

drop alinma_bff.marketplace_assets_mv mv

drop alinma_bff.order_execution_fee_lines_mv mv

drop alinma_bff.advisor_kpi_user_clients_mv mv

drop alinma_bff.party_current_account_membership_mv mv

drop alinma_bff.account_portfolios_mv mv

drop alinma_bff.account_owners_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.party_active_customer_parties_mv mv

drop alinma_bff.party_active_portfolio_involvements_mv mv

drop alinma_bff.marketplace_asset_taxonomy_mv mv

drop alinma_bff.advisor_kpi_entity_bucket_adds_mv mv

drop alinma_bff.portfolio_reference_identifiers_mv mv

drop alinma_bff.tasks_mv mv

drop alinma_bff.party_contact_counts_mv mv

drop alinma_bff.portfolio_task_counts_mv mv

drop alinma_bff.order_executions_bounded_mv mv

drop alinma_bff.advisor_kpi_account_product_class_mv mv

drop alinma_bff.account_latest_facts_mv mv

drop alinma_bff.account_reference_identifiers_mv mv

drop alinma_bff.account_task_counts_mv mv

drop alinma_bff.client_contact_counts_mv mv

drop alinma_bff.client_portfolio_counts_mv mv

drop alinma_bff.client_reference_identifiers_mv mv

drop alinma_bff.client_task_counts_mv mv

drop alinma_bff.party_active_customer_relationships_mv mv

drop alinma_bff.party_reference_identifiers_mv mv

drop alinma_bff.expiring_identifiers_mv mv

Tables (0)

—

Sources (0)

—

Functions (0)

—

alinma-bff-opportunities — 0 objects

Subscriptions (0)

—

Sinks (0)

—

Indexes (0)

—

Materialized views (0)

—

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

drop authz.active_clients_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_orders_mv mv

drop authz.active_parties_to_accounts_mv mv

drop authz.active_portfolio_policies_to_portfolios_mv mv

drop authz.active_clients_goals_mv mv

drop authz.active_entity_to_teams_mv mv

drop authz.active_clients_portfolios_mv mv

drop authz.team_to_clients_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

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_asset_sink sink

drop insights.pnl_by_asset_sink sink

drop insights.twrr_by_currency_sink sink

drop insights.pnl_by_currency_sink sink

drop insights.pnl_by_asset_type_sink sink

drop insights.twrr_by_asset_type_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.pnl_by_sector_sink sink

drop insights.twrr_by_region_sink sink

drop insights.twrr_by_sector_sink sink

drop insights.twrr_by_taxonomy_node_sink sink

drop insights.twrr_by_asset_class_sink sink

drop insights.pnl_summary_sink sink

drop insights.position_by_asset_sink sink

drop insights.position_by_currency_sink sink

drop insights.position_by_asset_type_sink sink

drop insights.twrr_sink sink

drop insights.position_by_asset_class_sink sink

drop insights.position_by_sector_sink sink

drop insights.position_by_region_sink sink

drop insights.position_by_taxonomy_node_sink sink

drop insights.position_summary_sink sink

drop insights.flow_by_asset_type_sink sink

drop insights.flow_by_taxonomy_node_sink sink

drop insights.flow_by_sector_sink sink

drop insights.flow_by_asset_class_sink sink

drop insights.flow_by_region_sink sink

drop insights.flow_summary_sink sink

drop insights.flow_by_currency_sink sink

drop insights.flow_by_asset_sink sink

drop insights.flow_by_transaction_type_sink sink

drop insights.abor_settlement_positions_sink sink

drop insights.account_to_account_groups_sink sink

drop insights.settled_cash_balances_sink sink

drop insights.settled_position_valuations_sink sink

drop insights.party_to_account_groups_sink sink

drop insights.account_groups_sink sink

drop insights.holding_values_sink sink

drop insights.benchmark_twrr_by_region_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_sector_sink sink

drop insights.benchmark_twrr_by_currency_sink sink

drop insights.benchmark_twrr_by_asset_type_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_twrr_by_asset_sink sink

drop insights.transactions_sink sink

drop insights.investment_accounts_ft_sink sink

drop insights.private_asset_valuations_sink sink

drop insights.portfolio_to_account_groups_sink sink

drop insights.asset_twrr_sink sink

drop insights.asset_distributions_sink sink

drop insights.benchmark_values_by_sector_sink sink

drop insights.benchmark_values_by_asset_class_sink sink

drop insights.benchmark_values_by_taxonomy_node_sink sink

drop insights.benchmark_values_by_region_sink sink

drop insights.private_asset_holdings_sink sink

drop insights.benchmark_values_by_currency_sink sink

drop insights.benchmark_twrr_sink sink

drop insights.portfolios_sink sink

drop insights.assets_sink sink

drop insights.account_to_portfolios_sink sink

drop insights.accounts_sink sink

drop insights.benchmark_values_by_asset_sink sink

drop insights.clients_sink sink

Indexes (0)

—

Materialized views (82)

drop insights.twrr_by_asset_mv mv

drop insights.pnl_by_asset_mv mv

drop insights.twrr_by_currency_mv mv

drop insights.pnl_by_currency_mv mv

drop insights.pnl_by_asset_type_mv mv

drop insights.twrr_by_asset_type_mv mv

drop insights.pnl_by_distribution_mv mv

drop insights.twrr_by_distribution_mv mv

drop insights.pnl_summary_mv mv

drop insights.position_by_asset_mv mv

drop insights.position_by_currency_mv mv

drop insights.position_by_asset_type_mv mv

drop insights.twrr_mv mv

drop insights.position_by_distribution_mv mv

drop insights.position_summary_mv mv

drop insights.asset_distributions_week_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.position_asset_values_mv mv

drop insights.flow_by_currency_mv mv

drop insights.flow_asset_values_mv mv

drop insights.flow_by_asset_mv mv

drop insights.position_values_mv mv

drop insights.flow_by_transaction_type_mv mv

drop insights.flow_values_mv mv

drop insights.abor_settlement_positions_mv mv

drop insights.account_to_account_groups_binned_mv mv

drop insights.position_snapshot_mv mv

drop insights.account_to_account_groups_txn_binned_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_mv mv

drop insights.holding_values_latest_mv mv

drop insights.settled_cash_balances_mv mv

drop insights.settled_position_valuations_mv mv

drop insights.party_to_account_groups_mv mv

drop insights.account_groups_mv mv

drop insights.holding_values_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_cash_series_mv mv

drop insights.settled_position_series_mv mv

drop insights.settled_cost_basis_latest_mv mv

drop insights.user_to_account_groups_mv mv

drop insights.party_account_group_types_mv mv

drop insights.client_account_group_types_mv mv

drop insights.orphan_accruals_mv mv

drop insights.holding_values_with_accruals_mv mv

drop insights.benchmark_twrr_by_asset_mv mv

drop insights.transactions_merged_mv mv

drop insights.settled_cost_basis_carried_mv mv

drop insights.investment_account_purchasing_power_mv mv

drop insights.private_asset_valuations_mv mv

drop insights.user_account_membership_mv mv

drop insights.party_account_direct_mv mv

drop insights.party_account_via_portfolio_mv mv

drop insights.client_account_via_portfolio_mv mv

drop insights.client_account_direct_mv mv

drop insights.portfolio_account_group_types_mv mv

drop insights.accruals_agg_mv mv

drop insights.asset_twrr_mv mv

drop insights.asset_latest_price_mv mv

drop insights.asset_distributions_sink_input_mv mv

drop insights.benchmark_values_by_distribution_mv mv

drop insights.active_transaction_status_id_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.benchmark_twrr_mv mv

drop insights.fx_rates_snapshot_mv mv

drop insights.asset_latest_yield_to_maturity_mv mv

drop insights.user_to_portfolios_mv mv

drop insights.open_accounts_mv mv

drop insights.asset_prices_snapshot_mv mv

drop insights.user_to_clients_mv mv

drop insights.client_to_account_groups_mv mv

drop insights.holding_values_raw_mv mv

drop insights.asset_price_with_lag_mv mv

drop insights.asset_distributions_for_consumers_mv mv

drop insights.portfolio_to_account_groups_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_extreme_holding_mv mv

drop opportunity.signal_portfolio_fx_exposure_mv mv

drop opportunity.signal_portfolio_allocation_drift_mv mv

drop opportunity.signal_portfolio_extreme_sector_mv mv

drop opportunity.portfolio_unrealized_loss_delta_mv mv

drop opportunity.portfolio_extreme_holding_breaches_mv mv

drop opportunity.portfolio_fx_exposure_delta_mv mv

drop opportunity.signal_account_balance_increase_mv mv

drop opportunity.signal_account_balance_decrease_mv mv

drop opportunity.portfolio_allocation_drift_breaches_mv mv

drop opportunity.portfolio_extreme_sector_breaches_mv mv

drop opportunity.signal_portfolio_balance_increase_mv mv

drop opportunity.signal_portfolio_balance_decrease_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_clients_sink sink

drop search.user_team_memberships_sink sink

drop search.team_to_parties_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