Azure data sync tasks
An Azure data sync task is a Data Accelerator for Azure asset that you use to synchronize data between a source and a target. For example, an Azure data sync task can read data from your customer service database and write the data into Azure Data Warehouse.
You can use one of the following task operations:
- Insert
- Inserts all source rows into the target except for rows that already exist in the target.
- Update
- Updates rows in the target that exist in the source.
- Upsert
- Updates all rows in the target that also exist in the source and inserts all new source rows in to the target.
- Delete
- Deletes all rows from the target that exist in the source.
You can run an Azure data sync task manually or you can schedule the task to run at a specific time or interval such as hourly, daily, or weekly.
You can save multiple tasks and organize them in projects.