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

spectrum ALTER EXTERNAL TABLE to add column


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


asked 2 years ago290 views
1 Answer

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:

I hope this answers your question.


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