Bulk update contacts using SQL Server data

Updates multiple contacts by reading IDs and new values from a SQL Server SELECT statement or stored procedure. Column names or aliases must match contact properties (e.g. Id, email). The driver uses the HubSpot bulk API to apply the updates.

UPDATE Contacts
SOURCE (
  'MSSQL',
  'Data Source=localhost;Initial Catalog=Test;Integrated Security=true',
  'SELECT Id, email FROM StagingContacts'
)