In this post I attempt to unravel the structure of Tableau Workbook files (TWB & TWBX). I explain some use cases where you might need to dig into the underlying structure of the workbooks. Additionally, I’ll introduce some available tools for modifying the structure. Lastly, I will explain how to retrieve the Tableau Admin Views TWB file.
Continue reading “Unravel Tableau Workbook Structure (TWB/TWBX)”Category: Uncategorized
Lessons from migrating Oracle to Redshift – Data types
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”
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”
HTML based emails from Python (ssmtp)
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)”
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”
Business Intelligence Tech Tips 