2 réponses
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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
répondu il y a 4 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a 5 mois
- demandé il y a 5 mois
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 10 mois