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

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	helpviewer_keywords	dev_langs	monikerRange
Management Data Warehouse stored procedures (Transact-SQL)	Management Data Warehouse stored procedures (Transact-SQL)	markingmyname	maghan	randolphwest	08/21/2024	sql	system-objects	reference	management data warehouse, data collector stored procedures	TSQL	>=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)