By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

DMS service for aurora postgres doesnt accept a view as source for full load process

1

Hi We are creating a DMS task that we were expecting to use a view in a Aurora Postgres service as data source, for a single use table migration. But it seems that views arent actually supported in this specific source case .... any reason for this? Theres a column which serves as primary key for that view

Below is the message when creating the DMS task Error in mapping rules. Rule with ruleId = 042389161 failed validation. view selection is not available for aurora-postgresql source type

In the meantime, im looking towards AWS Glue to do the procedure, and in the "worst" case, create a procedure to do the task / load process

Any tips would be great for the ones that may fall for the same case

best regards

Topics
Migration & ModernizationDatabaseAnalytics
Tags
AWS Database Migration ServiceGeneral Database MigrationsAurora PostgreSQLAWS Glue
Language
English
AWS-User-8279819
asked 2 years ago866 views
1 Answer
0

Is this for a one-shot migration or you intend to do this often (or continuously?) If this is a one-shot, as a work around you can create a table from this view and move that new table with DMS.

AWS
AWS-ADolganov
answered 2 years ago
  • AWS-User-8279819
    2 years ago

    currently, one shot, but unless mysql and postgres became better than aurora, i cant stop thinking that this is a truly useful feature. The cost to materialize a view is too high

  • rePost-User-7017882
    2 years ago

    I have the same problem when replicating data from Aurora postgres to Aurora Postgres using DMS with views. The workaround of creating first the tables seems ok but has performance impact. Documentation indicates that the views are supported but no success

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content