SQL Data Warehouse and Parallel Data Warehouse Catalog Views

APPLIES TO: noSQL Server noAzure SQL Database yesAzure Synapse Analytics (SQL DW) yesParallel Data Warehouse

This topic lists the SQL Data Warehouse and Parallel Data Warehouse catalog views.

SQL Data Warehouse and Parallel Data Warehouse Catalog Views

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

SQL Data Warehouse Catalog Views

The following catalog views apply to SQL Data Warehouse only:

sys.pdw_materialized_view_column_distribution_properties (Transact-SQL) (Preview)

sys.pdw_materialized_view_distribution_properties (Transact-SQL) (Preview)

sys.pdw_materialized_view_mappings (Transact-SQL) (Preview)

sys.workload_management_workload_classifier_details (Transact-SQL)

sys.workload_management_workload_classifiers (Transact-SQL)

sys.workload_management_workload_groups (Transact-SQL) (Preview)

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)