How to add SUPER column to existing AWS Redshift table?

GOAL

• I would like to add a Redshift SUPER column to and existing redshift table.
• I need this to store JSON data there

CODE

This is how Normally I would add a new column.

ALTER TABLE products 
ADD COLUMN created_at NOT NULL;

1. Tried

CREATE TABLE temp_test_persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

ALTER TABLE temp_test_persons ADD COLUMN newSuperColumn SUPER NOT NULL; 

Error running query: ALTER TABLE ADD COLUMN defined as NOT NULL must have a non-null default expression

Reviewed Solutions

• Alter column data type in Amazon Redshift
• AWS Redshift – Add IDENTITY column to existing table
• Adding column to existing tables
• Add dynamic column to existing MySQL table?
• SQLAlchemy: How to add column to existing table?
• adding columns to an existing table
• add column to existing table postgres
• How to add not null unique column to existing table
• Adding columns to existing csv file using super-csv
• UCanAccess: Add column to existing table
• Adding columns to existing redshift table
• How to add column to existing table in laravel?
• Add column to existing table in rds
• oracle add column to existing table

Answer

ALTER TABLE temp_test_persons 
ADD COLUMN newSuperColumn SUPER;