Tableau Relationships: Performance – Speed and Cardinality
It may happen that we work with really big tables that are not just a few rows but millions or even billions of rows. Tableau’s VizQL’s SQL (what a beginning of a sentence!) has to query all these tables, and that takes time. When we are dealing with seconds of loading time (latency) or even […]
Tableau Relationships: Performance – A Few Introductions
From here on out (at least for a few posts), we will have a look into the Performance Options of Relationships that are shown when we design a relation between two tables. If you have no idea what I am talking about, chances are that you have never expanded the options. You’ll find them in […]
Upserting Data in Matillion
In my last blog, I showed you how to iterate through a variable to bring multiple tables into the raw layer of your data warehouse. Today, I’m going to build on that concept by creating a DIM table and performing an UPSERT. Now, to start, I won’t go over the process of building the DIM […]
Tableau Relationships: Extracts
The new data model brought us the Logical Layer, from which we can draw specific tables without being forced to load the data from all the related tables. Remember, with traditional joins, all sheets that worked with that join had to load the full data set from that joined table regardless if we were only […]
A Definitive Guide to Python Stored Procedures in the Snowflake UI
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their own Snowflake environment. I would understand if you wanted to […]
Tableau Relationships: LODs
LODs (Level of Detail expressions) are not the easiest topic in Tableau, though they are a glorious one! It took me some time to get the hang of it, but today I don’t want to miss them. What they do – in a nutshell – is move the level of aggregation somewhere that is not […]
Tableau Relationships: Tips and Tricks
There are quite a few tips and tricks out there for Relationships in Tableau; just not nearly as many as for every other topic in Tableau, which is a shame. Nevertheless, this article is supposed to grow over time, and we start with something very simple! Root Swapping What Is a Root Table? Like with […]
A Definitive Guide to Python UDFs in the Snowflake UI
Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake Summit in June 2022, Snowpark for Python was officially released into Public Preview, which means anybody is able to get started using Python in their own Snowflake environment. I would understand if you wanted to […]
Tableau Relationships: Basics – The Ground Rules
Until Tableau version 2020.1, whenever we had two or more tables that we wanted to connect with each other, we had to either join them or blend them. If you aren’t sure about joins, please take a minute and get yourself up to speed. We will need them later on, or rather we need to […]
InterWorks Keeping an Eye Out at Eyeo Festival
The Eyeo Festival can probably be best described by the way in which it was named, which you can find in a Medium article from one of the festival’s founders: “I came up with the name, Eyeo, which doesn’t mean anything specific, but riffs on the idea of eye-opening and I/O at the same time. […]
