This post is a first in a set of posts, which discuss various lessons learned from migrating a BI infrastructure from Oracle to Redshift

This particular post discusses the migration of Oracle data types to Redshift, obstacles, tips and some important function usage differences

Continue reading “Lessons from migrating Oracle to Redshift – Data types” →

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” →

In this post I provide a simple Python code which utilizes ssmtp with MIME in order to send an HTML based email with an embedded image.
Continue reading “HTML based emails from Python (ssmtp)” →

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” →