We are trying to migrate data from AWS Aurora Postgres (v13.4) to another AWS Aurora Postgres database (Serverless v2) but the data migration fails for tables wherein we add a column filter. Our table names and column names are in the upper camel case. I checked the logs it shows the following error:
2022-04-27T09:31:12 [TRANSFORMATION ]E: Failed to init filter for column CompanyId [20014] (manipulator.c:605)
2022-04-27T09:31:12 [TRANSFORMATION ]W: The metadata transformations defined for table 'public.Tenants' were not performed as at least one of the transformation expressions contains an error (manipulator.c:147)
Here is the mapping rule:
{
"rules": [
{
"rule-type": "selection",
"rule-id": "046273916",
"rule-name": "046273916",
"object-locator": {
"schema-name": "public",
"table-name": "Tenants"
},
"rule-action": "include",
"filters": [
{
"filter-type": "source",
"column-name": "CompanyId",
"filter-conditions": [
{
"filter-operator": "eq",
"value": "xxxxxx"
}
]
}
]
},
{
"rule-type": "selection",
"rule-id": "042087387",
"rule-name": "042087387",
"object-locator": {
"schema-name": "public",
"table-name": "Plans"
},
"rule-action": "include",
"filters": []
}
]
}