| title | SQL Data Warehouse and Parallel Data Warehouse Catalog Views | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/15/2017 | |
| ms.service | sql-data-warehouse | |
| ms.reviewer | jrasnick | |
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | ef6f58e2-0162-4bb2-951a-a786da7453e4 | |
| aauthor | ronortloff | |
| ms.author | rortloff | |
| manager | craigg | |
| monikerRange | >= aps-pdw-2016 || = azure-sqldw-latest || = sqlallproducts-allversions |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-pdw-md]
This topic lists the [!INCLUDEssSDW] and [!INCLUDEssPDW] catalog views.
All [!INCLUDEssSDW] and [!INCLUDEssPDW] catalog views begin with sys.pdw.
The following catalog views apply to both [!INCLUDEssSDW] and [!INCLUDEssPDW]:
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.
[!INCLUDEssPDW] Catalog Views
The following catalog views apply to [!INCLUDEssPDW] 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)