Target End-points (Databricks) columns are defined default as NOT NULL columns

[PriQlikDBA]

Source: DB2 for zOS

Target: Databricks

Qlik Replicate by default create table in Databricks as NOT NULLABLE column. How to change the column attributes from default NOT NULL to NULL columns (by default or for specific task)

[Rahul_Kale]

Hello @PriQlikDBA ,

Thank you for reaching out to the Qlik community,

Qlik Replicate does NOT provide a setting to globally force columns to NULLABLE when creating tables in Databricks. 
 

It derives nullability from the source, and DDL changes like NOT NULL → NULL are not propagated automatically. 

As a workaround for this, pre-create target tables with nullable columns or ALTER after load.

[DesmondWOO]

Hi @PriQlikDBA ,

In general, Qlik Replicate creates the target table according to your source table metadata. Please verify the source table metadata definition first.

In addition, which version of Qlik Replicate are you using?

Regards,
Desmond