Databases
2018
- When Live Beats an ExtractMar 14
When using Tableau, taking an extract is always better than using a live query, right? Well, no. Let’s take a look at a few cases.
- The Query Behind the VizFeb 13
How do I get at the queries that Tableau generates? Let me show you three ways.
- Custom SQL in Tableau: Subqueries and SQL InjectionFeb 5
I recently answered a question about why some (perfectly correct) SQL wasn’t working in Tableau. So why would a perfectly reasonable custom query fail? And what’s the link to SQL injection? Read on!
- Row-Level Security: A Cautionary TaleJan 29
Row-level security is a common requirement for people trying to control access to data. Let’s explore a common way to implement row-level security on top of a relational database and see why it may not be as secure as it looks.
- Tableau Data Sources: Live vs ExtractJan 12
A look at another aspect of Tableau that people often find confusing: the difference between live and extracted data sources. And again, we’re going to take a bit of a database perspective to clarify the situation.
- Dimensions and Measures: A SQL PerspecitiveJan 7
Going through Boot Camp after joining Tableau and learning about dimensions and measures, I remember finding the descriptions rather confusing. Let’s clear this up.