Hi Community,
I created a table in redshift with table definition as
CREATE TABLE loc (
id int NOT NULL identity(1, 1),
locdsc character varying(200),
loccode character varying(50),
PRIMARY KEY (loccode))
I created an alteryx flow to load data into the above created table with the option "Append existing". In the designer I see the data for locdsc & loccode fields but when I check the redshift table locdsc field has all nulls. There is no null data in any of the fields.
when I switch the order of fields in the table definition as below
CREATE TABLE loc (
id int NOT NULL identity(1, 1) ENCODE az64,
loccode character varying(50) NOT NULL ENCODE lzo,
locdsc character varying(200) ENCODE lzo,
PRIMARY KEY (loccode))
Alteryx flow fails with an error message saying cannot insert null values into a non-null field.
Thanks