PowerCenter Modernization

Back Next

Databricks Delta advanced properties

The following tables lists the Databricks Delta properties that you can configure for a

Connection Map configuration

The following table describes the Databricks Delta connection properties:

Connection property	Description
Schema	The Databricks Delta 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 Databricks Delta source advanced properties:

Property name	Description
Schema Name	Overrides the schema specified in the connection. Default is $$dbd_schema .
Staging Location	Relative directory path to store the staging files. If the Databricks cluster is deployed on AWS, use the path relative to the Amazon S3 staging bucket. If the Databricks cluster is deployed on Azure, use the path relative to the Azure Data Lake Store Gen2 staging filesystem name. Default is $$dbd_staging_loc .

The following table describes the Databricks Delta target advanced properties:

Property Name	Description
Schema Name	Overrides the schema specified in the connection. Default is $$dbd_schema .
Staging Location	Relative directory path to store the staging files. If the Databricks cluster is deployed on AWS, use the path relative to the Amazon S3 staging bucket. If the Databricks cluster is deployed on Azure, use the path relative to the Azure Data Lake Store Gen2 staging filesystem name. Default is $$dbd_staging_loc .

The following table describes the Databricks Delta lookup transformation advanced properties:

Property Name	Description
Schema Name	Overrides the schema specified in the connection. Default is $$dbd_schema .
Staging Location	Relative directory path to store the staging files. If the Databricks cluster is deployed on AWS, use the path relative to the Amazon S3 staging bucket. If the Databricks cluster is deployed on Azure, use the path relative to the Azure Data Lake Store Gen2 staging filesystem name. Default is $$dbd_staging_loc .