Peek(ing) through windows
It's something everyone should do
Full Outer Join
I'm building an open source data & analytics stack around ClickHouse, dbt and Apache Superset
Latest articles
Automagic schema inference killed the data engineer
Todays lesson in working with legacy output is: data contracts, data contracts and data contracts. The great thing about shipping structured data as text files is it is so darn easy! Just store it as a CSV and boom: minimum overhead and just the righ...
Pivoting reports into tables
Pivoting data in ClickHouse is fun and everyone should do it
Let your table have the same structure as your JSON
Use Arrays and Tuples to keep nested data nested