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

1개 답변
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
답변함 2년 전
  • 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

  • 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

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠