MaxScale - Mask every column in all tables of a DataBase and specify which not

35 Views Asked by At

What I am looking for is to mask all the columns (and new columns that could be added in the future to the tables in my DB).

So for that I want to know if there is a way to mask everything and specify which column names to be excluded of masking.

I looked into the documentation and didn't find something related so I dont know if this functionality exists.

What I have tried is the following:

{
    "rules": [
        {
            "replace": {
                "database":"myDB",
        "match":"\\s+(.*)"
            },
            "with": {
                "fill": "X"
            }
        }
    ]
}

But I get the error:

Error: Server at http://myhost:4919 responded with 400 Bad Request to `POST filters`
{
    "errors": [
        {
            "detail": "A masking rule 'replace' does not have the mandatory 'column' key or it's not a valid Json string."
        }
    ]
}
0

There are 0 best solutions below