topic Re: Target End-points (Databricks) columns are defined default as NOT NULL columns in Qlik Replicate

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

PriQlikDBA — Mon, 29 Jun 2026 19:05:02 GMT

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)

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

Rahul_Kale — Tue, 30 Jun 2026 12:03:51 GMT

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.

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

DesmondWOO — Mon, 06 Jul 2026 07:06:52 GMT

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