Performing set operations UNION, INTERSECT, MINUS with Looker BI tool
Posts by Year
dbt supercharges SQL with macros
Releasing CORE DWH version
Performing custom ‘not empty’ tests
Generating concatenate and surrogate keys
Establishing integration tests and CI
Basic tests are:
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...
sources.yml describes how to reach tables created by ELT service
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...
The whole solution consists of several integral parts.
Next generation of marketing analytics
Technology Enthusiast Digest
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...