Management Data Warehouse stored procedures (Transact-SQL)
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (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)