Edit

Share via

Azure Synapse Analytics and Analytics Platform System (PDW) catalog views

  • Article

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

Catalog Views (Transact-SQL)