Teardown · authz, insights, insights-intraday, opportunity, search

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

authz — 26 objects

Subscriptions (9)

drop authz.authz_active_teams_memberships_sub subscription

drop authz.authz_active_parties_to_accounts_sub subscription

drop authz.authz_active_portfolios_to_teams_sub subscription

drop authz.authz_active_clients_to_teams_sub subscription

drop authz.authz_active_account_to_portfolios_sub subscription

drop authz.authz_active_accounts_to_clients_sub subscription

drop authz.authz_active_parties_to_portfolios_sub subscription

drop authz.authz_active_clients_portfolios_sub subscription

drop authz.authz_active_party_memberships_sub subscription

Sinks (0)

—

Indexes (0)

—

Materialized views (16)

drop authz.team_to_tasks_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_accounts_mv mv

drop authz.active_teams_memberships_mv mv

drop authz.active_clients_portfolios_mv mv

drop authz.active_entity_to_teams_mv mv

drop authz.active_account_to_portfolios_mv mv

drop authz.active_parties_to_portfolios_mv mv

drop authz.team_to_clients_mv mv

drop authz.user_team_memberships_mv mv

drop authz.team_to_parties_mv mv

drop authz.active_parties_to_accounts_mv mv

drop authz.team_to_portfolios_mv mv

drop authz.active_accounts_to_clients_mv mv

Tables (1)

drop authz.subscription_progress table

Sources (0)

—

Functions (0)

—

insights — 174 objects

Subscriptions (0)

—

Sinks (77)

drop insights.pnl_by_asset_type_sink sink

drop insights.twrr_by_asset_type_sink sink

drop insights.twrr_by_sector_sink sink

drop insights.twrr_by_region_sink sink

drop insights.twrr_by_asset_class_sink sink

drop insights.twrr_by_taxonomy_node_sink sink

drop insights.pnl_by_taxonomy_sink sink

drop insights.pnl_by_asset_class_sink sink

drop insights.pnl_by_region_sink sink

drop insights.pnl_by_sector_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_sink sink

drop insights.pnl_summary_sink sink

drop insights.position_by_asset_type_sink sink

drop insights.position_by_sector_sink sink

drop insights.position_by_taxonomy_node_sink sink

drop insights.position_by_asset_class_sink sink

drop insights.position_by_region_sink sink

drop insights.position_by_asset_sink sink

drop insights.position_by_currency_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.flow_summary_sink sink

drop insights.flow_by_asset_type_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_summary_sink sink

drop insights.flow_by_currency_sink sink

drop insights.flow_by_asset_sink sink

drop insights.intraday_position_summary_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_position_valuations_sink sink

drop insights.settled_cash_balances_sink sink

drop insights.account_groups_sink sink

drop insights.party_to_account_groups_sink sink

drop insights.settled_position_series_sink sink

drop insights.benchmark_twrr_by_currency_sink sink

drop insights.benchmark_twrr_by_asset_class_sink sink

drop insights.benchmark_twrr_by_sector_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_type_sink sink

drop insights.user_to_account_groups_sink sink

drop insights.client_to_account_groups_sink sink

drop insights.holding_values_sink sink

drop insights.transactions_sink sink

drop insights.benchmark_twrr_by_asset_sink sink

drop insights.asset_distributions_sink sink

drop insights.benchmark_values_by_asset_class_sink sink

drop insights.benchmark_values_by_region_sink sink

drop insights.benchmark_values_by_sector_sink sink

drop insights.benchmark_values_by_taxonomy_node_sink sink

drop insights.portfolio_to_account_groups_sink sink

drop insights.investment_accounts_ft_sink sink

drop insights.private_asset_valuations_sink sink

drop insights.benchmark_values_by_currency_sink sink

drop insights.asset_twrr_sink sink

drop insights.private_asset_holdings_sink sink

drop insights.benchmark_twrr_sink sink

drop insights.accounts_sink sink

drop insights.account_to_portfolios_sink sink

drop insights.portfolios_sink sink

drop insights.account_groups_ft_sink sink

drop insights.assets_sink sink

drop insights.benchmark_values_by_asset_sink sink

drop insights.clients_sink sink

Indexes (0)

—

Materialized views (97)

drop insights.pnl_by_asset_type_mv mv

drop insights.twrr_by_asset_type_mv mv

drop insights.twrr_by_distribution_mv mv

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

drop insights.pnl_summary_mv mv

drop insights.position_by_asset_type_mv mv

drop insights.position_by_distribution_mv mv

drop insights.position_by_asset_mv mv

drop insights.position_by_currency_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.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_summary_mv mv

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

drop insights.position_asset_values_mv mv

drop insights.holding_values_shadow_diff_mv mv

drop insights.flow_values_mv mv

drop insights.flow_by_transaction_type_mv mv

drop insights.intraday_position_asset_values_mv mv

drop insights.abor_settlement_positions_mv mv

drop insights.position_values_mv mv

drop insights.holding_values_journal_mv mv

drop insights.account_to_account_groups_txn_binned_mv mv

drop insights.position_snapshot_mv mv

drop insights.account_to_account_groups_membership_mv mv

drop insights.intraday_position_values_mv mv

drop insights.account_to_account_groups_settlement_binned_mv mv

drop insights.account_to_account_groups_binned_mv mv

drop insights.holding_values_journal_orphan_accruals_mv mv

drop insights.holding_values_journal_with_accruals_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.settled_cash_balances_mv mv

drop insights.cash_values_journal_density_mv mv

drop insights.account_groups_mv mv

drop insights.party_to_account_groups_mv mv

drop insights.holding_values_latest_mv mv

drop insights.settled_position_series_mv mv

drop insights.settled_cash_series_mv mv

drop insights.benchmark_twrr_by_currency_mv mv

drop insights.benchmark_twrr_by_distribution_mv mv

drop insights.benchmark_twrr_by_asset_type_mv mv

drop insights.settled_cost_basis_series_mv mv

drop insights.settled_cost_basis_latest_mv mv

drop insights.user_to_account_groups_mv mv

drop insights.client_account_group_types_mv mv

drop insights.party_account_group_types_mv mv

drop insights.holding_values_mv mv

drop insights.transactions_merged_mv mv

drop insights.benchmark_twrr_by_asset_mv mv

drop insights.intraday_asset_prices_latest_mv mv

drop insights.intraday_fx_rates_latest_mv mv

drop insights.asset_distributions_sink_input_mv mv

drop insights.benchmark_values_by_distribution_mv mv

drop insights.settled_cost_basis_carried_mv mv

drop insights.user_account_membership_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.party_account_via_portfolio_mv mv

drop insights.investment_account_purchasing_power_mv mv

drop insights.private_asset_valuations_mv mv

drop insights.orphan_accruals_mv mv

drop insights.holding_values_with_accruals_mv mv

drop insights.benchmark_values_by_currency_mv mv

drop insights.active_transaction_status_id_mv mv

drop insights.asset_twrr_mv mv

drop insights.asset_latest_price_mv mv

drop insights.intraday_asset_prices_5min_mv mv

drop insights.private_asset_holdings_mv mv

drop insights.client_to_account_groups_mv mv

drop insights.intraday_fx_rates_5min_mv mv

drop insights.asset_distributions_for_consumers_mv mv

drop insights.settled_cost_basis_dedup_mv mv

drop insights.benchmark_twrr_mv mv

drop insights.user_to_clients_mv mv

drop insights.user_to_portfolios_mv mv

drop insights.open_accounts_mv mv

drop insights.intraday_holdings_latest_mv mv

drop insights.portfolio_to_account_groups_mv mv

drop insights.fx_rates_snapshot_mv mv

drop insights.accruals_agg_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)

—

opportunity — 19 objects

Subscriptions (0)

—

Sinks (0)

—

Indexes (0)

—

Materialized views (19)

drop opportunity.opportunity_resources_mv mv

drop opportunity.signal_portfolio_unrealized_loss_mv mv

drop opportunity.signal_portfolio_allocation_drift_mv mv

drop opportunity.signal_portfolio_extreme_sector_mv mv

drop opportunity.signal_portfolio_extreme_holding_mv mv

drop opportunity.signal_portfolio_fx_exposure_mv mv

drop opportunity.portfolio_unrealized_loss_delta_mv mv

drop opportunity.signal_account_balance_decrease_mv mv

drop opportunity.signal_account_balance_increase_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.portfolio_extreme_holding_breaches_mv mv

drop opportunity.portfolio_fx_exposure_delta_mv mv

drop opportunity.account_balance_delta_mv mv

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

drop search.user_team_memberships_sink sink

drop search.team_to_parties_sink sink

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