Microsoft Azure SQL Data Warehouse V2 Target Properties

You can use a Microsoft Azure SQL Data Warehouse object as a target in a synchronization task. When you use Microsoft Azure SQL Data Warehouse target objects, you can select a standard object as the primary target. You can configure Microsoft Azure SQL Data Warehouse target properties on the Target page of the Synchronization Task wizard.

Target Property	Description
Connection	Name of the target connection.
Target Object	Name of the target object. Select the primary target object.
Create Target	Creates a target. Enter a name for the target object and select the source fields that you want to use. By default, all source fields are used.
Display technical names instead of labels	Displays technical names instead of business names.
Display source fields in alphabetical order	Displays source fields in alphabetical order instead of the order returned by the source system.

Advanced Target Property	Description
Azure Blob Container Name	Name of the container in Microsoft Azure Storage to use for staging before writing to Microsoft Azure SQL Data Warehouse.
Field Delimiter	Character used to separate fields in the file. Default is 0x1e. You can select the following field delimiters from the list: ~ ` \| . TAB 0x1e
Update Column	The key columns to upsert or update data to or delete data from Microsoft Azure SQL Data Warehouse.
Number of Concurrent Connections to Blob Store	Number of threads to use to move data to the staging area in Microsoft Azure Blob Storage. Default is 4.
Truncate Table	Truncates the target data before inserting the data to the target. This option is applicable for insert operation.
Pre-SQL	Pre-SQL command that must be run before reading data from the source.
Post-SQL	Post-SQL command that must be run after writing data to the target.
On Pre-Post SQL Error	Determines the behavior when a task that includes pre-SQL or post-SQL commands encounters errors. You can select any of the following options: - Continue. The task continues regardless of errors. - Stop. The task stops when errors occur while executing pre-SQL or post-SQL commands.
Quote Character	Specifies the quote character to skip when you write data to Microsoft Azure SQL Data Warehouse. When you write data to Microsoft Azure SQL Data Warehouse and the source table contains the specified quote character, the task fails. Change the quote character value to a value that does not exist in the source table.
Success File Directory	NA
Error File Directory	NA