amazon-redshift-utils
amazon-redshift-utils copied to clipboard
blacklisted table parameter use LIKE or ILIKE instead of IN
cannot blacklist / whitelist based on prefix or suffix. for blacklisting a table I would like to be able to add a table prefix% which matches any table name with the matching prefix or %suffix for a matching suffix I.e. use the ILIKE or LIKE or SIMILAR TO clause as opposed to IN for Analyze Vacuum Utility
Yeah this makes sense. We have a regex search on schemas but not on the tables themselves. Happy to take a PR for this or perhaps can look at it over the holidays.