By using AWS re:Post, you agree to the Terms of Use

spectrum ALTER EXTERNAL TABLE to add column

0

Is it possible to use ALTER EXTERNAL TABLE to add columns? or the whole table needs to be dropped & re-created with all partitions ?

Thanks

asked 2 years ago290 views
1 Answer
0

Hi yip2,

The Redshift doc clearly explains that you can alter an external table to add a column, but there are limitation to what other clauses and column properties can be included. See the doc. page here: https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_TABLE.html

I hope this answers your question.

Regards,
-Kurt

answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions