Azure Synapse Analytics and Analytics Platform System (PDW) catalog views
Applies to: Azure Synapse Analytics Analytics Platform System (PDW)
This topic lists the Azure Synapse Analytics and Analytics Platform System (PDW) catalog views.
Azure Synapse Analytics and Analytics Platform System (PDW) catalog views
The following catalog views apply to both Azure Synapse Analytics and Analytics Platform System (PDW):
sys.pdw_column_distribution_properties (Transact-SQL)
sys.pdw_distributions (Transact-SQL)
sys.pdw_index_mappings (Transact-SQL)
sys.pdw_loader_backup_run_details (Transact-SQL)
sys.pdw_loader_backup_runs (Transact-SQL)
sys.pdw_nodes_column_store_dictionaries (Transact-SQL)
sys.pdw_nodes_column_store_row_groups (Transact-SQL)
sys.pdw_nodes_column_store_segments (Transact-SQL)
sys.pdw_nodes_columns (Transact-SQL)
sys.pdw_nodes_indexes (Transact-SQL)
sys.pdw_nodes_partitions (Transact-SQL)
sys.pdw_nodes_pdw_physical_databases (Transact-SQL)
sys.pdw_nodes_tables (Transact-SQL)
sys.pdw_replicated_table_cache_state (Transact-SQL)
sys.pdw_table_distribution_properties (Transact-SQL)
sys.pdw_table_mappings (Transact-SQL)
Azure Synapse Analytics catalog views
The following catalog views apply to Azure Synapse Analytics only:
sys.pdw_materialized_view_column_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_distribution_properties (Transact-SQL)
sys.pdw_materialized_view_mappings (Transact-SQL) (Preview)
sys.pdw_permanent_table_mappings (Transact-SQL)
sys.workload_management_workload_classifier_details (Transact-SQL)
sys.workload_management_workload_classifiers (Transact-SQL)
sys.workload_management_workload_groups (Transact-SQL)
Analytics Platform System (PDW) catalog views
The following catalog views apply to Analytics Platform System (PDW) only:
sys.pdw_database_mappings (Transact-SQL)
sys.pdw_diag_event_properties (Transact-SQL)
sys.pdw_diag_events (Transact-SQL)
sys.pdw_diag_sessions (Transact-SQL)
sys.pdw_health_alerts (Transact-SQL)
sys.pdw_health_component_groups (Transact-SQL)
sys.pdw_health_component_properties (Transact-SQL)
sys.pdw_health_component_status_mappings (Transact-SQL)
sys.pdw_health_components (Transact-SQL)
sys.pdw_loader_run_stages (Transact-SQL)
See also
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om