awslabs / awslabs/amazon-redshift-utils

blacklisted table parameter use LIKE or ILIKE instead of IN

Open
#401 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.