--- title: "Jesper Bagge (@ramworks) | Hashnode" description: "Let’s full outer join stuff to other stuff! Read the latest articles by Jesper Bagge on Hashnode." url: "https://hashnode.com/@ramworks" --- @ramworks # Jesper Bagge @ramworks · Lund, Sweden · Joined June 2023 Let’s full outer join stuff to other stuff! ### [Peek(ing) through windows](https://fullouterjoin.dev/peeking-through-windows?utm_source=hashnode&utm_medium=feed) It's something everyone should do 5 min read · [fullouterjoin.dev](https://fullouterjoin.dev/peeking-through-windows?utm_source=hashnode&utm_medium=feed) [Jul 3, 2024](https://hashnode.com/posts/peeking-through-windows/66851bb3a8227b0674b678dc) ### [Automagic schema inference killed the data engineer](https://fullouterjoin.dev/automagic-schema-inference-killed-the-data-engineer?utm_source=hashnode&utm_medium=feed) 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... 2 min read · [fullouterjoin.dev](https://fullouterjoin.dev/automagic-schema-inference-killed-the-data-engineer?utm_source=hashnode&utm_medium=feed) [Mar 19, 2024](https://hashnode.com/posts/automagic-schema-inference-killed-the-data-engineer/65f96b5e41b545fa26dc1c96) ### [Pivoting reports into tables](https://fullouterjoin.dev/pivoting-reports-into-tables?utm_source=hashnode&utm_medium=feed) Pivoting data in ClickHouse is fun and everyone should do it 3 min read · [fullouterjoin.dev](https://fullouterjoin.dev/pivoting-reports-into-tables?utm_source=hashnode&utm_medium=feed) [Jun 29, 2023](https://hashnode.com/posts/pivoting-reports-into-tables/649d45da5361dbeff7d8ece9) ### [Let your table have the same structure as your JSON](https://fullouterjoin.dev/let-your-table-have-the-same-structure-as-your-json?utm_source=hashnode&utm_medium=feed) Use Arrays and Tuples to keep nested data nested 2 min read · [fullouterjoin.dev](https://fullouterjoin.dev/let-your-table-have-the-same-structure-as-your-json?utm_source=hashnode&utm_medium=feed) [Jun 27, 2023](https://hashnode.com/posts/let-your-table-have-the-same-structure-as-your-json/649b35ca49db02c02d65f922)