Connections > Microsoft Azure Synapse SQL connection > Microsoft Azure Synapse SQL target properties
  

Microsoft Azure Synapse SQL target properties

You can use a Microsoft Azure Synapse SQL object as a target in a data loader task.
When you create a data loader task to write data to Microsoft Azure Synapse SQL, specify the Microsoft Azure Synapse SQL target properties and advanced options.
The following table describes the Microsoft Azure Synapse SQL target properties:
Property
Description
Connection
Name of the target connection.
Select a connection or create a new connection.
Target Name Prefix
Optional prefix for the target table names.
If you enter a prefix, the target table names will be written as <prefix><source object>.
For example, if you enter pfx1_ as the prefix, then data from source object src1 will be written to target table pfx1_src1.
Azure Blob Container Name
Applies to Azure Blob storage.
The name of the container in Microsoft Azure Blob Storage.
The container name can't not contain special characters.
ADLS FileSystem Name
Applies to ADLS Gen2 storage.
The name of the file system in Microsoft Azure Data Lake Storage Gen2.
The file system name can't contain special characters.
You can also enter the path of the directory under the file system. Use only a forward slash to specify the directory path.