SQL Data Warehouse and Parallel Data Warehouse Catalog Views

APPLIES TO: noSQL Server noAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

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

All SQL Data Warehouse and Parallel Data Warehouse catalog views begin with sys.pdw.

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)

sys.workload_management_workload_classifier_details (Transact-SQL) (Preview)

sys.workload_management_workload_classifiers (Transact-SQL) (Preview)

Note

Workload classification is available for preview on SQL Data Warehouse Gen2. Workload Management Classification and Importance preview is for builds with a release date of April 9th, 2019 or later. Users should avoid using builds earlier than this date for workload management testing. To determine if your build is workload management capable, run select @@version when connected to your SQL Data Warehouse instance.

SQL Data Warehouse Catalog Views

The following catalog views apply to SQL Data Warehouse only:

sys.pdw_materialized_view_column_distribution_properties (Transact-SQL) sys.pdw_materialized_view_distribution_properties sys.pdw_materialized_view_mappings

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)