corpus.blog
41554 blogs · [ { "id": "01a087e4-ec92-71cc-b6d2-55ba6634e015", "title": "Beyond the Semantic Layer: Building a Context Layer for the Agentic Era", "url": "https://www.ssp.sh/blog/agentic-context-layer/", "published_at": "2026-06-11T06:00:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6f9bf89d", "title": "Plan Mode All the Time, Substrait over SQL, and the End of the DE Role ft. Chris Riccomini", "url": "https://www.ssp.sh/blog/how-to-use-ai-with-de-chris-riccomini/", "published_at": "2026-05-26T06:00:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba70712b36", "title": "The Dagster Almanack: From Complexity to Composability", "url": "https://www.ssp.sh/blog/dagster-almanack-open-data-platform/", "published_at": "2026-05-26T06:00:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7082eba8", "title": "Internal vs. External Storage? What's the Limit of External Tables", "url": "https://www.ssp.sh/blog/modern-external-tables-and-evolution/", "published_at": "2026-05-13T22:08:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7112806b", "title": "AI Reveals Why BI Still Matters", "url": "https://www.ssp.sh/blog/bi-is-not-dead-2026/", "published_at": "2026-04-21T06:41:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba711a61ed", "title": "Specs Over Vibes: Consistent AI Results ft. Mark Freeman", "url": "https://www.ssp.sh/blog/specs-over-vibes-interview-mark-freeman/", "published_at": "2026-04-07T22:08:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba71cb1af8", "title": "Building an Agent-Friendly, Local-First Analytics Stack with MotherDuck and Rill", "url": "https://www.ssp.sh/blog/agentic-friendly-local-first-analytics-stack/", "published_at": "2026-04-07T06:41:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7256331c", "title": "Why I Still Blog — and Why the Future of Blogging Is Connected", "url": "https://www.ssp.sh/blog/why-i-still-blog/", "published_at": "2026-03-06T19:00:17+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba72b17dad", "title": "Git for Data Applied: Comparing Git-like Tools That Separate Metadata from Data", "url": "https://www.ssp.sh/blog/git-for-data-tools/", "published_at": "2026-03-03T22:08:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba733e8389", "title": "Building an Obsidian RAG with DuckDB and MotherDuck", "url": "https://www.ssp.sh/blog/obsidian-rag-duckdb-sql/", "published_at": "2026-02-12T22:00:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba740514f9", "title": "Arch Linux (Omarchy) — 8 Months Later: The Good, the Bad, and the Fixable", "url": "https://www.ssp.sh/blog/linux-omarchy-the-good-bad-and-fixable/", "published_at": "2026-02-10T20:31:17+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba74af0756", "title": "Why Coinbase and Pinterest Chose StarRocks: Lakehouse-Native Design and Fast Joins at Terabyte Scale", "url": "https://www.ssp.sh/blog/starrocks-lakehouse-native-joins/", "published_at": "2026-02-09T06:41:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba681d967f", "title": "A Diary of a Data Engineer", "url": "https://www.ssp.sh/blog/diary-of-a-data-engineer/", "published_at": "2026-01-13T09:36:39+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba75495b6e", "title": "Well Being in Times of Algorithms", "url": "https://www.ssp.sh/blog/well-being-algorithms/", "published_at": "2025-12-22T07:31:17+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba75db9550", "title": "Opinionated Data Platforms vs. Open-Source: The Chef’s Choice for Your Data Platform", "url": "https://www.ssp.sh/blog/omakase-data-stack/", "published_at": "2025-12-10T07:04:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba76ca9396", "title": "Simplicity of a Database, but the Speed of a Cache: OLAP Caches for DuckDB", "url": "https://www.ssp.sh/blog/olap-cache-for-duckdb/", "published_at": "2025-12-09T07:04:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba76e611d7", "title": "Dlt+ClickHouse+Rill: Multi-Cloud Cost Analytics, Cloud-Ready", "url": "https://www.ssp.sh/blog/finops-dlt-clickhouse-rill/", "published_at": "2025-12-04T06:41:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7788ee85", "title": "Branch, Test, Deploy: A Git-Inspired Approach for Data", "url": "https://www.ssp.sh/blog/git-for-data-theory/", "published_at": "2025-12-03T07:04:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba77bb65d9", "title": "Multi-Cloud Cost Analytics: From Cost-Export to Parquet to Rill", "url": "https://www.ssp.sh/blog/cost-analyzer-aws-gcp/", "published_at": "2025-11-21T07:41:06+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a34d2ee38", "title": "Boredom is the New Luxury", "url": "https://www.ssp.sh/blog/owning-things-attention/", "published_at": "2025-11-18T07:13:54+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba78a30971", "title": "4 Senior Data Engineers Answer 10 Top Reddit Questions", "url": "https://www.ssp.sh/blog/data-engineers-roundtable-reddit/", "published_at": "2025-11-03T06:04:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba798e0549", "title": "Data Modeling for the Agentic Era: Semantics, Speed, and Stewardship", "url": "https://www.ssp.sh/blog/agentic-data-modeling/", "published_at": "2025-10-17T07:41:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba79bc0880", "title": "Beyond Basic ETL: Enterprise Data Capabilities Without the Complexity", "url": "https://www.ssp.sh/blog/beyond-basic-etl/", "published_at": "2025-10-13T14:41:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba79c534e6", "title": "Why I Don't Research; and Write from Experience", "url": "https://www.ssp.sh/blog/why-i-dont-research/", "published_at": "2025-09-17T05:34:47+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7a939706", "title": "Data Modeling Guide for Real-Time Analytics with ClickHouse", "url": "https://www.ssp.sh/blog/practical-data-modeling-clickhouse/", "published_at": "2025-09-05T07:41:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7aa856ca", "title": "Why Semantic Layers Matter—and How to Build One with DuckDB", "url": "https://www.ssp.sh/blog/semantic-layer-duckdb/", "published_at": "2025-08-24T06:04:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a356cb3a1", "title": "My Journey from macOS to Arch Linux with Omarchy", "url": "https://www.ssp.sh/blog/macbook-to-arch-linux-omarchy/", "published_at": "2025-08-07T18:40:00+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba68519149", "title": "Summer Data Engineering Roadmap", "url": "https://www.ssp.sh/blog/data-engineering-roadmap/", "published_at": "2025-08-06T12:04:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a35acfe9e", "title": "Why Are We Here on Earth? True Happiness, Giving Up Control, or the Trap of Worshipping Earthly Things?", "url": "https://www.ssp.sh/blog/why-are-we-here-on-earth/", "published_at": "2025-08-02T14:40:26+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba68ac27ee", "title": "The Data Engineering Toolkit: Infrastructure, DevOps, and Beyond", "url": "https://www.ssp.sh/blog/data-engineering-toolkit-devops-iac/", "published_at": "2025-07-10T08:34:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7b49adf0", "title": "Has Self-Serve BI Finally Arrived Thanks to AI?", "url": "https://www.ssp.sh/blog/self-service-bi-ai/", "published_at": "2025-07-09T07:00:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7b4f4be6", "title": "Universal Data Orchestrator in Action: Enterprise Best Practices", "url": "https://www.ssp.sh/blog/enterprise-universal-data-orchestrator-in-action/", "published_at": "2025-06-17T07:00:00+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7b5abe3e", "title": "The Open Lakehouse Stack: DuckDB and the Rise of Table Formats", "url": "https://www.ssp.sh/blog/open-table-lakehouse-with-duckdb/", "published_at": "2025-06-16T09:41:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba7b8e0c61", "title": "Self-Host & Tech Independence: The Joy of Building Your Own", "url": "https://www.ssp.sh/blog/self-host-self-independence/", "published_at": "2025-06-07T14:27:09+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a252bb98e", "title": "The Open Table Format Revolution: Why Hyperscalers Are Betting on Managed Iceberg", "url": "https://www.ssp.sh/blog/open-table-format-revolution/", "published_at": "2025-05-20T07:00:06+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a26220318", "title": "Configure, Don't Code: How Declarative Data Stacks Enable Enterprise Scale", "url": "https://www.ssp.sh/blog/declarative-data-stack-enterprise/", "published_at": "2025-05-20T06:41:06+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a26afc3e2", "title": "The Data Engineer's Guide to Efficient Log Parsing with DuckDB/MotherDuck", "url": "https://www.ssp.sh/blog/log-parsing-duckdb/", "published_at": "2025-04-21T09:41:06+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a26d510d7", "title": "The Universal Data Orchestrator: The Heartbeat of Data Engineering", "url": "https://www.ssp.sh/blog/universal-data-orchestrator/", "published_at": "2025-04-15T07:00:00+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a26f729cb", "title": "What «Shifting Left» Means and Why it Matters for Data Stacks", "url": "https://www.ssp.sh/blog/shifting-left/", "published_at": "2025-04-14T08:19:32+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a27cee06b", "title": "Vector Technologies for AI: Extending Your Existing Data Stack", "url": "https://www.ssp.sh/blog/vector-technologies-ai-data-stack/", "published_at": "2025-03-28T12:34:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a27ea8531", "title": "Scaling Beyond Postgres: How to Choose a Real-Time Analytical Database", "url": "https://www.ssp.sh/blog/scaling-beyond-postgres/", "published_at": "2025-03-11T13:19:32+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a27fc4ade", "title": "A Beginner’s Guide to Geospatial with DuckDB", "url": "https://www.ssp.sh/blog/duckdb-geospatial/", "published_at": "2025-02-26T12:34:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a36433547", "title": "Finding Flow: Escaping Digital Distractions Through Deep Work and Slow Living", "url": "https://www.ssp.sh/blog/finding-flow/", "published_at": "2025-02-14T17:40:00+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a284a7ea5", "title": "Why Pivot Tables Never Die", "url": "https://www.ssp.sh/blog/why-pivot-tables-never-die/", "published_at": "2025-02-03T14:19:32+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6955da1e", "title": "The Data Engineering Toolkit: Essential Tools for Your Machine", "url": "https://www.ssp.sh/blog/data-engineering-toolkit/", "published_at": "2025-01-22T15:34:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a293ef795", "title": "Designing a Declarative Data Stack: From Theory to Practice", "url": "https://www.ssp.sh/blog/designing-a-declarative-data-stack/", "published_at": "2024-12-20T14:19:32+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a296d5570", "title": "Semantic Layer and AI: The Future of Data Querying with Natural Language", "url": "https://www.ssp.sh/blog/semantic-layer-and-ai-natural-language-querying/", "published_at": "2024-12-19T15:34:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a298b3212", "title": "Universal Semantic Layer: Capabilities, Integrations, and Enterprise Benefits", "url": "https://www.ssp.sh/blog/universal-semantic-layer-capabilities/", "published_at": "2024-12-04T15:34:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2a83e589", "title": "Building with Bluesky: Inside the New Open Social Network", "url": "https://www.ssp.sh/blog/bluesky-open-social-network/", "published_at": "2024-11-27T06:34:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2b139f78", "title": "Exploring the Semantic Layer Through the Lens of MVC", "url": "https://www.ssp.sh/blog/semantic-layer-through-the-lens-of-mvc/", "published_at": "2024-11-19T15:34:08+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2b6b8a8e", "title": "15+ Companies Using DuckDB in Production: A Comprehensive Guide", "url": "https://www.ssp.sh/blog/duckdb-in-production/", "published_at": "2024-11-12T15:34:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba697d54fc", "title": "BI-as-Code and the New Era of GenBI", "url": "https://www.ssp.sh/blog/bi-as-code-and-genbi/", "published_at": "2024-11-05T15:19:32+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2bca955e", "title": "The Enterprise Case for DuckDB: 5 Key Categories and Why Use It", "url": "https://www.ssp.sh/blog/enterprise-case-duckdb-key-categories/", "published_at": "2024-10-16T15:34:08+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba69eb2295", "title": "The Rise of the Declarative Data Stack", "url": "https://www.ssp.sh/blog/rise-of-declarative-data-stack/", "published_at": "2024-10-16T14:19:32+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2ca6c868", "title": "My Obsidian Note-Taking Workflow", "url": "https://www.ssp.sh/blog/obsidian-note-taking-workflow/", "published_at": "2024-07-25T15:42:34+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a371b2d87", "title": "The Plain Text Workflow: How Vim and Markdown Became My Backbone", "url": "https://www.ssp.sh/blog/my-vimverse/", "published_at": "2023-12-10T12:41:26+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6a6ce0c2", "title": "Data Modeling - The Unsung Hero of Data Engineering: Architecture Pattern, Tools and the Future (Part 3)", "url": "https://www.ssp.sh/blog/data-modeling-for-data-engineering-architecture-pattern-tools-future/", "published_at": "2023-05-26T20:17:22+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6aec071e", "title": "Data Modeling – The Unsung Hero of Data Engineering: Modeling Approaches and Techniques (Part 2)", "url": "https://www.ssp.sh/blog/data-modeling-for-data-engineering-approaches-techniques/", "published_at": "2023-05-03T20:17:22+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6b3e564e", "title": "Data Modeling – The Unsung Hero of Data Engineering: An Introduction to Data Modeling (Part 1)", "url": "https://www.ssp.sh/blog/data-modeling-for-data-engineering-introduction/", "published_at": "2023-04-03T20:17:22+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2cb22759", "title": "Pandas 2.0 and its Ecosystem (Arrow, Polars, DuckDB)", "url": "https://www.ssp.sh/blog/pandas-2-0-ecosystem-arrow-polars-duckdb/", "published_at": "2023-03-08T14:32:27+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2d2f0371", "title": "Finding My Pathless Path", "url": "https://www.ssp.sh/blog/finding-my-pathless-path/", "published_at": "2023-02-25T09:21:17+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6b82789b", "title": "Modern Data Stack: The Struggle of Enterprise Adoption", "url": "https://www.ssp.sh/blog/modern-data-stack-struggle-of-enterprise-adoption/", "published_at": "2023-01-09T14:32:06+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6bef3bb2", "title": "Why Vim Is More than Just an Editor – Vim Language, Motions, and Modes Explained", "url": "https://www.ssp.sh/blog/why-using-neovim-data-engineer-and-writer-2023/", "published_at": "2023-01-03T23:04:46+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2dc02755", "title": "The Open Data Stack Distilled into Four Core Tools", "url": "https://www.ssp.sh/blog/open-data-stack-core-tools/", "published_at": "2023-01-03T14:31:30+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2e9e9a30", "title": "Data Integration as Code: Configuring Airbyte and dbt with Python (Dagster)", "url": "https://www.ssp.sh/blog/data-integration-as-code-airbyte-dbt-python-dagster/", "published_at": "2022-12-19T20:17:22+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba66c30669", "title": "Rust for Data Engineering", "url": "https://www.ssp.sh/blog/rust-for-data-engineering/", "published_at": "2022-10-19T08:31:09+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6c22ac1f", "title": "The Rise of the Semantic Layer", "url": "https://www.ssp.sh/blog/rise-of-semantic-layer-metrics/", "published_at": "2022-09-29T14:30:47+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6cd9bf26", "title": "Data Lake / Lakehouse Guide: Powered by Data Lake Table Formats (Delta Lake, Iceberg, Hudi)", "url": "https://www.ssp.sh/blog/data-lake-lakehouse-guide/", "published_at": "2022-08-25T10:45:41+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6d114771", "title": "Data Orchestration Trends: The Shift From Data Pipelines to Data Products", "url": "https://www.ssp.sh/blog/data-orchestration-trends/", "published_at": "2022-06-14T16:56:18+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6df29d1d", "title": "Personal Knowledge Management Workflow for a Deeper Life — as a Computer Scientist", "url": "https://www.ssp.sh/blog/pkm-workflow-for-a-deeper-life/", "published_at": "2022-04-06T18:40:01+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6e90b4d2", "title": "Building an Analytics API with GraphQL: The Next Level of Data Engineering?", "url": "https://www.ssp.sh/blog/analytics-api-with-graphql-the-next-level-of-data-engineering/", "published_at": "2022-01-22T18:02:40+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a2f8b9acf", "title": "How to Take Notes in 2021?", "url": "https://www.ssp.sh/blog/how-to-take-notes-in-2021/", "published_at": "2021-09-28T18:30:40+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a372b8ae7", "title": "Saying Goodbye to WordPress, a Homecoming", "url": "https://www.ssp.sh/blog/why-i-moved-away-from-wordpress/", "published_at": "2021-04-05T21:00:00+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba679f0ab5", "title": "Building a Data Engineering Project in 20 Minutes", "url": "https://www.ssp.sh/blog/data-engineering-project-in-twenty-minutes/", "published_at": "2021-03-09T18:54:25+00:00" }, { "id": "01a087e4-ec92-71cc-b6d2-55ba6f8ae792", "title": "Business Intelligence meets Data Engineering with Emerging Technologies", "url": "https://www.ssp.sh/blog/business-intelligence-meets-data-engineering/", "published_at": "2020-06-14T09:26:52+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a37b441ac", "title": "Email, and the way we (should) communicate at work", "url": "https://www.ssp.sh/blog/email-and-the-way-we-should-communicate-at-work/", "published_at": "2019-04-25T19:19:24+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a300d33fb", "title": "Open-Source Data Warehousing – Druid, Apache Airflow & Superset", "url": "https://www.ssp.sh/blog/open-source-data-warehousing-druid-airflow-superset/", "published_at": "2018-11-29T06:00:53+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a30ca6b0e", "title": "OLAP, what’s coming next?", "url": "https://www.ssp.sh/blog/olap-whats-coming-next/", "published_at": "2018-11-23T19:19:06+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a37cd3f53", "title": "Today’s Office – The Location Independent Lifestyle", "url": "https://www.ssp.sh/blog/the-location-independent-lifestyle/", "published_at": "2018-06-18T14:36:31+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3895ebba", "title": "Tools I Use – Part III", "url": "https://www.ssp.sh/blog/tools-i-use-part-iii/", "published_at": "2018-04-07T23:25:51+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a30e3e1bd", "title": "Data Engineering, the future of Data Warehousing?", "url": "https://www.ssp.sh/blog/data-engineering-the-future-of-data-warehousing/", "published_at": "2018-03-08T22:11:54+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a310d1d81", "title": "Data Warehouse vs Data Lake | ETL vs ELT", "url": "https://www.ssp.sh/blog/data-warehouse-vs-data-lake-etl-vs-elt/", "published_at": "2017-10-26T12:54:11+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a39903e58", "title": "Tools I Use – Microsoft OneNote – Part II", "url": "https://www.ssp.sh/blog/tools-i-use-onenote-part-ii/", "published_at": "2017-08-22T20:51:15+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a31f25063", "title": "What Data Warehouse Automation tools are on the market", "url": "https://www.ssp.sh/blog/what-dwa-tools-are-on-the-market/", "published_at": "2017-07-25T21:36:54+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a32bcd5ea", "title": "Why automate? What does Data Warehouse Automation for us?", "url": "https://www.ssp.sh/blog/why-automate-what-does-dwa-for-us/", "published_at": "2017-07-07T21:51:13+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a33bb54ed", "title": "Why Data Warehouse Automation is not more popular", "url": "https://www.ssp.sh/blog/why-data-warehouse-automation-is-not-more-popular/", "published_at": "2017-06-28T16:41:42+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a33e6b027", "title": "Data Warehouse Automation (DWA) – Series", "url": "https://www.ssp.sh/blog/data-warehouse-automation-dwa/", "published_at": "2017-06-28T16:40:46+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a39d3ca1c", "title": "Tools I Use", "url": "https://www.ssp.sh/blog/tools-i-use/", "published_at": "2017-05-22T17:55:42+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3a9a4b50", "title": "The more you share the more you get..", "url": "https://www.ssp.sh/blog/the-more-you-share-the-more-you-get/", "published_at": "2017-05-10T21:15:48+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3b885966", "title": "Migrate from Oracle to Microsoft (Views) – Part III", "url": "https://www.ssp.sh/blog/migrate-from-oracle-to-microsoft-views-part-iii/", "published_at": "2016-09-24T15:15:41+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3c37be3e", "title": "Migrate from Oracle to Microsoft (Views) – Part II", "url": "https://www.ssp.sh/blog/migrate-from-oracle-to-microsoft-views-part-ii/", "published_at": "2016-09-24T14:42:10+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3cd671c8", "title": "Migrate from Oracle to Microsoft (Views) – Part I", "url": "https://www.ssp.sh/blog/migrate-from-oracle-to-microsoft-views-part-i/", "published_at": "2016-09-24T14:34:16+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3a524964", "title": "SSAS Cubes – Dynamic generation of partition", "url": "https://www.ssp.sh/blog/ssas-cubes-dynamic-generation-of-partition/", "published_at": "2015-10-09T11:42:16+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3d89c122", "title": "Need any Headphones?", "url": "https://www.ssp.sh/blog/need-any-headphones/", "published_at": "2015-10-09T10:15:44+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3dc67241", "title": "Do you listen to music while working?", "url": "https://www.ssp.sh/blog/do-you-listen-to-music-while-working/", "published_at": "2015-10-09T10:05:18+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3e3ae2e4", "title": "Annoying advertising, what you can do", "url": "https://www.ssp.sh/blog/12/", "published_at": "2015-09-19T22:53:11+00:00" }, { "id": "01a08ceb-d16f-71e9-90d7-ac70c889e0a8", "title": "Annoying advertising, what you can do", "url": "https://www.ssp.sh/blog/annoying-advertising/", "published_at": "2015-09-19T22:53:11+00:00" }, { "id": "01a087e4-ec93-720d-8026-330a3ec0420d", "title": "ORDER BY Oracle vs. Microsoft SQL", "url": "https://www.ssp.sh/blog/order-by-oracle-vs-microsoft-sql/", "published_at": "2015-09-19T22:21:18+00:00" } ] posts Claim your blog
Back to Blogs - Data Engineering Blog & Second Brain
Blog · corpus.blog/blogs/ssp.sh/posts

Blogs - Data Engineering Blog & Second Brain

ssp.sh

2026

Beyond the Semantic Layer: Building a Context Layer for the Agentic Eraoriginal ↗
11 Jun 2026
Plan Mode All the Time, Substrait over SQL, and the End of the DE Role ft. Chris Riccominioriginal ↗
26 May 2026
The Dagster Almanack: From Complexity to Composabilityoriginal ↗
26 May 2026
Internal vs. External Storage? What's the Limit of External Tablesoriginal ↗
13 May 2026
AI Reveals Why BI Still Mattersoriginal ↗
21 Apr 2026
Specs Over Vibes: Consistent AI Results ft. Mark Freemanoriginal ↗
7 Apr 2026
Building an Agent-Friendly, Local-First Analytics Stack with MotherDuck and Rilloriginal ↗
7 Apr 2026
Why I Still Blog — and Why the Future of Blogging Is Connectedoriginal ↗
6 Mar 2026
Git for Data Applied: Comparing Git-like Tools That Separate Metadata from Dataoriginal ↗
3 Mar 2026
Building an Obsidian RAG with DuckDB and MotherDuckoriginal ↗
12 Feb 2026
Arch Linux (Omarchy) — 8 Months Later: The Good, the Bad, and the Fixableoriginal ↗
10 Feb 2026
Why Coinbase and Pinterest Chose StarRocks: Lakehouse-Native Design and Fast Joins at Terabyte Scaleoriginal ↗
9 Feb 2026
A Diary of a Data Engineeroriginal ↗
13 Jan 2026

2025

Well Being in Times of Algorithmsoriginal ↗
22 Dec 2025
Opinionated Data Platforms vs. Open-Source: The Chef’s Choice for Your Data Platformoriginal ↗
10 Dec 2025
Simplicity of a Database, but the Speed of a Cache: OLAP Caches for DuckDBoriginal ↗
9 Dec 2025
Dlt+ClickHouse+Rill: Multi-Cloud Cost Analytics, Cloud-Readyoriginal ↗
4 Dec 2025
Branch, Test, Deploy: A Git-Inspired Approach for Dataoriginal ↗
3 Dec 2025
Multi-Cloud Cost Analytics: From Cost-Export to Parquet to Rilloriginal ↗
21 Nov 2025
Boredom is the New Luxuryoriginal ↗
18 Nov 2025
4 Senior Data Engineers Answer 10 Top Reddit Questionsoriginal ↗
3 Nov 2025
Data Modeling for the Agentic Era: Semantics, Speed, and Stewardshiporiginal ↗
17 Oct 2025
Beyond Basic ETL: Enterprise Data Capabilities Without the Complexityoriginal ↗
13 Oct 2025
Why I Don't Research; and Write from Experienceoriginal ↗
17 Sept 2025
Data Modeling Guide for Real-Time Analytics with ClickHouseoriginal ↗
5 Sept 2025
Why Semantic Layers Matter—and How to Build One with DuckDBoriginal ↗
24 Aug 2025
My Journey from macOS to Arch Linux with Omarchyoriginal ↗
7 Aug 2025
Summer Data Engineering Roadmaporiginal ↗
6 Aug 2025
Why Are We Here on Earth? True Happiness, Giving Up Control, or the Trap of Worshipping Earthly Things?original ↗
2 Aug 2025
The Data Engineering Toolkit: Infrastructure, DevOps, and Beyondoriginal ↗
10 Jul 2025
Has Self-Serve BI Finally Arrived Thanks to AI?original ↗
9 Jul 2025
Universal Data Orchestrator in Action: Enterprise Best Practicesoriginal ↗
17 Jun 2025
The Open Lakehouse Stack: DuckDB and the Rise of Table Formatsoriginal ↗
16 Jun 2025
Self-Host & Tech Independence: The Joy of Building Your Ownoriginal ↗
7 Jun 2025
The Open Table Format Revolution: Why Hyperscalers Are Betting on Managed Icebergoriginal ↗
20 May 2025
Configure, Don't Code: How Declarative Data Stacks Enable Enterprise Scaleoriginal ↗
20 May 2025
The Data Engineer's Guide to Efficient Log Parsing with DuckDB/MotherDuckoriginal ↗
21 Apr 2025
The Universal Data Orchestrator: The Heartbeat of Data Engineeringoriginal ↗
15 Apr 2025
What «Shifting Left» Means and Why it Matters for Data Stacksoriginal ↗
14 Apr 2025
Vector Technologies for AI: Extending Your Existing Data Stackoriginal ↗
28 Mar 2025
Scaling Beyond Postgres: How to Choose a Real-Time Analytical Databaseoriginal ↗
11 Mar 2025
A Beginner’s Guide to Geospatial with DuckDBoriginal ↗
26 Feb 2025
Finding Flow: Escaping Digital Distractions Through Deep Work and Slow Livingoriginal ↗
14 Feb 2025
Why Pivot Tables Never Dieoriginal ↗
3 Feb 2025
The Data Engineering Toolkit: Essential Tools for Your Machineoriginal ↗
22 Jan 2025

2024

Designing a Declarative Data Stack: From Theory to Practiceoriginal ↗
20 Dec 2024
Semantic Layer and AI: The Future of Data Querying with Natural Languageoriginal ↗
19 Dec 2024
Universal Semantic Layer: Capabilities, Integrations, and Enterprise Benefitsoriginal ↗
4 Dec 2024
Building with Bluesky: Inside the New Open Social Networkoriginal ↗
27 Nov 2024
Exploring the Semantic Layer Through the Lens of MVCoriginal ↗
19 Nov 2024
15+ Companies Using DuckDB in Production: A Comprehensive Guideoriginal ↗
12 Nov 2024
BI-as-Code and the New Era of GenBIoriginal ↗
5 Nov 2024
The Enterprise Case for DuckDB: 5 Key Categories and Why Use Itoriginal ↗
16 Oct 2024
The Rise of the Declarative Data Stackoriginal ↗
16 Oct 2024
My Obsidian Note-Taking Workfloworiginal ↗
25 Jul 2024

2023

The Plain Text Workflow: How Vim and Markdown Became My Backboneoriginal ↗
10 Dec 2023
Data Modeling - The Unsung Hero of Data Engineering: Architecture Pattern, Tools and the Future (Part 3)original ↗
26 May 2023
Data Modeling – The Unsung Hero of Data Engineering: Modeling Approaches and Techniques (Part 2)original ↗
3 May 2023
Data Modeling – The Unsung Hero of Data Engineering: An Introduction to Data Modeling (Part 1)original ↗
3 Apr 2023
Pandas 2.0 and its Ecosystem (Arrow, Polars, DuckDB)original ↗
8 Mar 2023
Finding My Pathless Pathoriginal ↗
25 Feb 2023
Modern Data Stack: The Struggle of Enterprise Adoptionoriginal ↗
9 Jan 2023
Why Vim Is More than Just an Editor – Vim Language, Motions, and Modes Explainedoriginal ↗
3 Jan 2023
The Open Data Stack Distilled into Four Core Toolsoriginal ↗
3 Jan 2023

2022

Data Integration as Code: Configuring Airbyte and dbt with Python (Dagster)original ↗
19 Dec 2022
Rust for Data Engineeringoriginal ↗
19 Oct 2022
The Rise of the Semantic Layeroriginal ↗
29 Sept 2022
Data Lake / Lakehouse Guide: Powered by Data Lake Table Formats (Delta Lake, Iceberg, Hudi)original ↗
25 Aug 2022
Data Orchestration Trends: The Shift From Data Pipelines to Data Productsoriginal ↗
14 Jun 2022
Personal Knowledge Management Workflow for a Deeper Life — as a Computer Scientistoriginal ↗
6 Apr 2022
Building an Analytics API with GraphQL: The Next Level of Data Engineering?original ↗
22 Jan 2022

2021

How to Take Notes in 2021?original ↗
28 Sept 2021
Saying Goodbye to WordPress, a Homecomingoriginal ↗
5 Apr 2021
Building a Data Engineering Project in 20 Minutesoriginal ↗
9 Mar 2021

2020

Business Intelligence meets Data Engineering with Emerging Technologiesoriginal ↗
14 Jun 2020

2019

Email, and the way we (should) communicate at workoriginal ↗
25 Apr 2019

2018

Open-Source Data Warehousing – Druid, Apache Airflow & Supersetoriginal ↗
29 Nov 2018
OLAP, what’s coming next?original ↗
23 Nov 2018
Today’s Office – The Location Independent Lifestyleoriginal ↗
18 Jun 2018
Tools I Use – Part IIIoriginal ↗
7 Apr 2018
Data Engineering, the future of Data Warehousing?original ↗
8 Mar 2018

2017

Data Warehouse vs Data Lake | ETL vs ELToriginal ↗
26 Oct 2017
Tools I Use – Microsoft OneNote – Part IIoriginal ↗
22 Aug 2017
What Data Warehouse Automation tools are on the marketoriginal ↗
25 Jul 2017
Why automate? What does Data Warehouse Automation for us?original ↗
7 Jul 2017
Why Data Warehouse Automation is not more popularoriginal ↗
28 Jun 2017
Data Warehouse Automation (DWA) – Seriesoriginal ↗
28 Jun 2017
Tools I Useoriginal ↗
22 May 2017
The more you share the more you get..original ↗
10 May 2017

2016

Migrate from Oracle to Microsoft (Views) – Part IIIoriginal ↗
24 Sept 2016
Migrate from Oracle to Microsoft (Views) – Part IIoriginal ↗
24 Sept 2016
Migrate from Oracle to Microsoft (Views) – Part Ioriginal ↗
24 Sept 2016

2015

SSAS Cubes – Dynamic generation of partitionoriginal ↗
9 Oct 2015
Need any Headphones?original ↗
9 Oct 2015
Do you listen to music while working?original ↗
9 Oct 2015
Annoying advertising, what you can dooriginal ↗
19 Sept 2015
Annoying advertising, what you can dooriginal ↗
19 Sept 2015
ORDER BY Oracle vs. Microsoft SQLoriginal ↗
19 Sept 2015
Previous