2回答
- 新しい順
- 投票が多い順
- コメントが多い順
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
回答済み 4年前
関連するコンテンツ
- AWS公式更新しました 1年前
- AWS公式更新しました 4年前