awslabs / amazon-redshift-utils

Amazon Redshift Utils contains utilities, scripts and view which are useful in a Redshift environment
Apache License 2.0
2.76k stars 1.25k forks source link

Add scenario for migrating schema with all tables contained #719

Open zhiweio opened 2 months ago

zhiweio commented 2 months ago

Description of changes:

Add scenario for migrating schema with all tables contained.

Migrate single schema:

{
  "unloadSource": {
    "schemaName": "public"
  },
  "copyTarget": {
    "schemaName": "public"
  }
}

Migrate multiple schemas:

{
  "unloadSource": {
    "schemaNames": [
      "model",
      "public"
    ]
  },
  "copyTarget": {
    "schemaNames": [
      "model",
      "public"
    ]
  }
}

By submitting this pull request, I confirm that you can use, modify, copy, and redistribute this contribution, under the terms of your choice.