management-data-warehouse-stored-procedures-transact-sql.md

title	Management Data Warehouse Stored Procedures (Transact-SQL)
description	Management Data Warehouse stored procedures (Transact-SQL)
author	markingmyname
ms.author	maghan
ms.reviewer	randolphwest
ms.date	06/23/2025
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
helpviewer_keywords	management data warehouse, data collector stored procedures
dev_langs	TSQL
monikerRange	>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current

Management Data Warehouse stored procedures (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

The data collector stores data and data collector type information in the management data warehouse. The following stored procedures are used to update data and change the tables in the management data warehouse.

• core.sp_create_snapshot (Transact-SQL)
• core.sp_add_collector_type (Transact-SQL)
• core.sp_purge_data (Transact-SQL)
• core.sp_update_data_source (Transact-SQL)
• core.sp_remove_collector_type (Transact-SQL)

Related content

• Data collector stored procedures (Transact-SQL)