2 Respostas
- Mais recentes
- Mais votos
- Mais comentários
0
Hi larryq,
I'll refer you to the doc. page that has most of what you need here: https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_TABLE_NEW.html
If the PostgreSQL DB is the true source for this data then I recommend the following:
- BIGSERIAL -> BIGINT as they are both INT8. If you source the rows from PostgreSQL you don't need the auto generating value creation of BIGSERIAL in Redshift. Otherwise Redshift has the IDENTITY column attribute to generate values.
- JSON -> VARCHAR. Of course you'll have to use Redshift's JSON function to do anything with the JSON data.
Regards,
-Kurt
respondido há 4 anos
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há um ano