Skip to content
Advertisement

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.

1. Tried

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

Reviewed Solutions

Advertisement

Answer

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement