Azure Synapse Analytics and Parallel Data Warehouse Catalog Views

Applies to: yesAzure Synapse Analytics yesAnalytics 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)