Azure Synapse Analytics and Parallel Data Warehouse Catalog Views

Applies to: yesAzure Synapse Analytics yesParallel Data Warehouse

This topic lists the Azure Synapse Analytics and Parallel Data Warehouse catalog views.

Azure Synapse Analytics and Parallel Data Warehouse Catalog Views

The following catalog views apply to both Azure Synapse Analytics and Parallel Data Warehouse:

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)

Parallel Data Warehouse Catalog Views

The following catalog views apply to Parallel Data Warehouse 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)