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
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