Dynamic RegExp pattern matching in Redshift

Recently I needed to match regular expressions patterns in Redshift, where both the string and the regular expression were dynamic values provided from table columns. Unfortunately REGEXP_COUNT and other similar functions in Redshift, do not support columns as the regular expression. Therefore I decided to solve this with a UDF.

Continue reading “Dynamic RegExp pattern matching in Redshift”

Utilizing Oracle Basic Compression With Partitions

Oracle basic compression is a free built-in feature, which can be used to reduce data size. This feature is only recommended for use with read-only data due to various limitations. In this blog post, I describe my own solution on how to use Oracle basic compression with a read-write aggregate table.

Continue reading “Utilizing Oracle Basic Compression With Partitions”