Amazon web services – Redshift table joins using Similar To
I have this query that runs in Redshift: Select A.* From TableA A join TableB B on A.Col like B.Pattern Where the Pattern column in TableB looks like: ('%foo%', '%bar%', ...) TableB has hundreds of pattern rules and is used…