PowerCenter Modernization

Back Next

Microsoft Azure Synapse SQL advanced properties

The following tables lists the Microsoft Azure Synapse SQL properties that you can configure for a

Connection Map configuration

The following table describes the Microsoft Azure Synapse SQL connection properties:

Connection property	Description
Schema	The Microsoft Azure Synapse SQL schema name to be used when creating the object. Th schema name is similar to the schema name specified in the SCHEMAMAP.properties file. Default is schema_changeit .

The following table describes the Microsoft Azure Synapse SQL source advanced properties:

Property name	Description
Schema Name Override	Overrides the schema specified in the connection. Default is $$syn_schema .
Azure Blob Container Name	The name of the container in Microsoft Azure Blob Storage. The container name must not contain special characters. Default is $$blob_container_name .
ADLS FileSystem Name	Required if you select ADLS Gen2 storage in the connection properties. The name of the file system in Microsoft Azure Data Lake Storage Gen2. The file system name must not contain special characters. You can also specify the path of the directory under the file system. Use only a forward slash to specify the directory path. Default is $$adls_folder_name .

The following table describes the Microsoft Azure Synapse SQL target advanced properties:

Property name	Description
Schema Name Override	Overrides the schema specified in the connection. Default is $$syn_schema .
Azure Blob Container Name	The name of the container in Microsoft Azure Blob Storage. The container name must not contain special characters. Default is $$blob_container_name .
ADLS FileSystem Name	Required if you select ADLS Gen2 storage in the connection properties. The name of the file system in Microsoft Azure Data Lake Storage Gen2. The file system name must not contain special characters. You can also specify the path of the directory under the file system. Use only a forward slash to specify the directory path. Default is $$adls_folder_name .

The following table describes the Microsoft Azure Synapse SQL lookup transformation advanced properties:

Property name	Description
Schema Name Override	Overrides the schema specified in the connection. Default is $$syn_schema .
Azure Blob Container Name	The name of the container in Microsoft Azure Blob Storage. The container name must not contain special characters. Default is $$blob_container_name .
ADLS FileSystem Name	Required if you select ADLS Gen2 storage in the connection properties. The name of the file system in Microsoft Azure Data Lake Storage Gen2. The file system name must not contain special characters. You can also specify the path of the directory under the file system. Use only a forward slash to specify the directory path. Default is $$adls_folder_name .