awslabs / awslabs/amazon-redshift-utils
blacklisted table parameter use LIKE or ILIKE instead of IN
Open
- Dominant language
- Python
- Stars
- 2.8k
- Forks
- 1.2k
- PR merge metrics
- No merged PRs in 30d
Description
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
Contributor guide
Research direction
Locate the Analyze Vacuum Utility and inspect how blacklisted table parameters are matched. Confirm that prefix and suffix patterns can match table names using LIKE, ILIKE, or SIMILAR TO rather than only IN, then exercise the utility's existing validation or execution path.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100