Performing set operations union, intersect, minus with looker bi tool
Performing set operations UNION, INTERSECT, MINUS with Looker BI tool
Posts by Year
2021
Dbt supercharges sql with macros
dbt supercharges SQL with macros
Releasing core dwh version
Releasing CORE DWH version
Performing custom ‘not empty’ tests
Performing custom ‘not empty’ tests
Generating concatenate and surrogate keys
Generating concatenate and surrogate keys
Establishing integration tests and ci
Establishing integration tests and CI
Covering models with schema tests
Basic tests are:
Populating dwh staging area
Models prefixed with stg _comprise the so-called staging area. Source tables are green-coloured, staging tables are blue on the picture below (click to expan...
Configuring data sources for dbt
sources.yml describes how to reach tables created by ELT service
Core dwh – building a common foundation
Plugging source data is pretty simple. You just subscribe to a plan, authorize your accounts, configure pipelines and it just works by filling tables with ne...
Building reliable product from the start
The whole solution consists of several integral parts.
Next generation of marketing analytics
Next generation of marketing analytics
Technology enthusiast digest
Technology Enthusiast Digest
2020
Compressing Redshift columnar data even further with proper encodings
Basics Amazon Redshift is database aimed primarily on analytics and OLAP queries. One of its key features is storing data in columnar format, in other word...