Skip to content

Instantly share code, notes, and snippets.

@kovid-r

kovid-r/postgresql_redshift_migration_dms_sample_task.sql

Created August 16, 2021 07:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save kovid-r/6772c96225d33404f57fbae13c217065 to your computer and use it in GitHub Desktop.
Save kovid-r/6772c96225d33404f57fbae13c217065 to your computer and use it in GitHub Desktop.
Download ZIP
Sample Load task using DMS for data exported from PostgreSQL to S3, now being imported to Redshift from S3.
Raw
postgresql_redshift_migration_dms_sample_task.sql
COPY /* partner:DMS
{
"Version": "DMS 3.4.4.R1",
"MigrationType": "FullLoad",
"TaskId": "8LRKTDSLNUWKF33K3OUY1NPA23HF3TISTS2BTNX"
}
*/ "public"."test" FROM 's3://dms-bucket/redshift.../.../1/LOAD00000001.csv'
credentials 'aws_iam_role=arn:aws:iam::123412344321:role/dms-access-for-endpoint' delimiter ','
NULL as 'awsdms_null' ESCAPE ACCEPTINVCHARS AS '?' GZIP
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment