# Architecture Articles

> Deep dives on modern data architecture: Lakehouse patterns, distributed query engines (DuckDB, Trino), and building fast analytical databases.

Filter by Topic:

[All Posts (45)](/blog.md) [Engineering (31)](/blog/tag/engineering.md) [Architecture (21)](/blog/tag/architecture.md) [Performance (14)](/blog/tag/performance.md) [Product (13)](/blog/tag/product.md) [Altertable Agent (12)](/blog/tag/ai-agents.md) [Open Source (10)](/blog/tag/open-source.md) [Data Stack (9)](/blog/tag/data-stack.md) [Analytics (7)](/blog/tag/analytics.md) [AI (4)](/blog/tag/ai.md) [Culture (3)](/blog/tag/culture.md) [Generative UI (2)](/blog/tag/generative-ui.md) [Agents (2)](/blog/tag/agents.md) [Semantic Layer (2)](/blog/tag/semantic-layer.md) [Cousteau (1)](/blog/tag/cousteau.md) [MCP Apps (1)](/blog/tag/mcp-apps.md) [Agentic UI (1)](/blog/tag/agentic-ui.md) [Model Context Protocol (1)](/blog/tag/model-context-protocol.md) [Pricing (1)](/blog/tag/pricing.md)



Deep dives on modern data architecture: Lakehouse patterns, distributed query engines (DuckDB, Trino), and building fast analytical databases.

[![From One Sentence to a Running Pipeline](/assets/blog/2026-11-16-from-one-sentence-to-a-running-pipeline.jpg)](/blog/2026-11-16-from-one-sentence-to-a-running-pipeline.md)

[NOVEMBER 16TH, 2026](/blog/2026-11-16-from-one-sentence-to-a-running-pipeline.md)

[Florian Valeye](/blog/2026-11-16-from-one-sentence-to-a-running-pipeline.md)

## [From One Sentence to a Running Pipeline](/blog/2026-11-16-from-one-sentence-to-a-running-pipeline.md)

[Altertable Agent, Architecture, Engineering](/blog/2026-11-16-from-one-sentence-to-a-running-pipeline.md)

[State a business need in one sentence: an agent writes the pipeline, proves it on real data, schedules the code, and tells you why when a run fails.](/blog/2026-11-16-from-one-sentence-to-a-running-pipeline.md)

[READ ARTICLE](/blog/2026-11-16-from-one-sentence-to-a-running-pipeline.md)

[![Interfaces for the next question](/assets/blog/2026-11-04-interfaces-for-the-next-question.jpg)](/blog/2026-11-04-interfaces-for-the-next-question.md)

[NOVEMBER 4TH, 2026](/blog/2026-11-04-interfaces-for-the-next-question.md)

[François Chalifour](/blog/2026-11-04-interfaces-for-the-next-question.md)

## [Interfaces for the next question](/blog/2026-11-04-interfaces-for-the-next-question.md)

[Generative UI, Architecture, Engineering, Product, Agents](/blog/2026-11-04-interfaces-for-the-next-question.md)

[Our UI schema couldn't keep up with new questions, so we built agent-written Data Apps with flexible interfaces and stable data contracts.](/blog/2026-11-04-interfaces-for-the-next-question.md)

[READ ARTICLE](/blog/2026-11-04-interfaces-for-the-next-question.md)

[![The Context Lakehouse](/assets/blog/2026-08-14-the-context-lakehouse.jpg)](/blog/2026-08-14-the-context-lakehouse.md)

[AUGUST 14TH, 2026](/blog/2026-08-14-the-context-lakehouse.md)

[Andre Noujaim](/blog/2026-08-14-the-context-lakehouse.md)

## [The Context Lakehouse](/blog/2026-08-14-the-context-lakehouse.md)

[Architecture, Data Stack, Altertable Agent](/blog/2026-08-14-the-context-lakehouse.md)

[Why the lakehouse is becoming the governed context foundation for humans, applications, and agents—not just an analytical destination.](/blog/2026-08-14-the-context-lakehouse.md)

[READ ARTICLE](/blog/2026-08-14-the-context-lakehouse.md)

[![Hand the Agent a Map](/assets/blog/2026-07-22-hand-the-agent-a-map.jpg)](/blog/2026-07-22-hand-the-agent-a-map.md)

[JULY 22ND, 2026](/blog/2026-07-22-hand-the-agent-a-map.md)

[Florian Valeye](/blog/2026-07-22-hand-the-agent-a-map.md)

## [Hand the Agent a Map](/blog/2026-07-22-hand-the-agent-a-map.md)

[Altertable Agent, Architecture, Engineering](/blog/2026-07-22-hand-the-agent-a-map.md)

[Search finds a match, not its context. Altertable's ontology and live entity graph let agents navigate to the evidence, one hop at a time.](/blog/2026-07-22-hand-the-agent-a-map.md)

[READ ARTICLE](/blog/2026-07-22-hand-the-agent-a-map.md)

[![The DuckDB Bet](/assets/blog/2026-07-21-the-duckdb-bet.jpg)](/blog/2026-07-21-the-duckdb-bet.md)

[JULY 21ST, 2026](/blog/2026-07-21-the-duckdb-bet.md)

[Sylvain Utard](/blog/2026-07-21-the-duckdb-bet.md)

## [The DuckDB Bet](/blog/2026-07-21-the-duckdb-bet.md)

[Architecture, Engineering, Data Stack](/blog/2026-07-21-the-duckdb-bet.md)

[DuckDB is showing up in warehouses, product-serving paths, and database servers. The shift is flexible execution without a central data copy.](/blog/2026-07-21-the-duckdb-bet.md)

[READ ARTICLE](/blog/2026-07-21-the-duckdb-bet.md)

[![Data Warehouses & Lakehouses in 2026](/assets/blog/2026-07-20-data-warehouses-and-lakehouses-in-2026.jpg)](/blog/2026-07-20-data-warehouses-and-lakehouses-in-2026.md)

[JULY 20TH, 2026](/blog/2026-07-20-data-warehouses-and-lakehouses-in-2026.md)

[Sylvain Utard](/blog/2026-07-20-data-warehouses-and-lakehouses-in-2026.md)

## [Data Warehouses & Lakehouses in 2026](/blog/2026-07-20-data-warehouses-and-lakehouses-in-2026.md)

[Architecture, Engineering, Data Stack](/blog/2026-07-20-data-warehouses-and-lakehouses-in-2026.md)

[A practical 2026 comparison of warehouses and lakehouses, from Snowflake and BigQuery to Databricks, DuckDB, and Altertable.](/blog/2026-07-20-data-warehouses-and-lakehouses-in-2026.md)

[READ ARTICLE](/blog/2026-07-20-data-warehouses-and-lakehouses-in-2026.md)

[![Lakehouse as Context Store](/assets/blog/2026-07-15-lakehouse-as-context-store.jpg)](/blog/2026-07-15-lakehouse-as-context-store.md)

[JULY 15TH, 2026](/blog/2026-07-15-lakehouse-as-context-store.md)

[Sylvain Utard](/blog/2026-07-15-lakehouse-as-context-store.md)

## [Lakehouse as Context Store](/blog/2026-07-15-lakehouse-as-context-store.md)

[Architecture, Engineering, Data Stack](/blog/2026-07-15-lakehouse-as-context-store.md)

[Why the lakehouse becomes the working context store for agents: live data, telemetry, definitions, and company knowledge in one governed foundation.](/blog/2026-07-15-lakehouse-as-context-store.md)

[READ ARTICLE](/blog/2026-07-15-lakehouse-as-context-store.md)

[![Stack Drift](/assets/blog/2026-06-30-stack-drift.jpg)](/blog/2026-06-30-stack-drift.md)

[JUNE 30TH, 2026](/blog/2026-06-30-stack-drift.md)

[Sylvain Utard](/blog/2026-06-30-stack-drift.md)

## [Stack Drift](/blog/2026-06-30-stack-drift.md)

[Architecture, Engineering, Data Stack](/blog/2026-06-30-stack-drift.md)

[Why mature data stacks keep accumulating copy layers, and how direct relational federation gives dbt a simpler path over live operational sources.](/blog/2026-06-30-stack-drift.md)

[READ ARTICLE](/blog/2026-06-30-stack-drift.md)

[![Know What a Query Reads Before It Runs](/assets/blog/2026-06-15-know-what-a-query-reads.jpg)](/blog/2026-06-15-know-what-a-query-reads.md)

[JUNE 15TH, 2026](/blog/2026-06-15-know-what-a-query-reads.md)

[Florian Valeye](/blog/2026-06-15-know-what-a-query-reads.md)

## [Know What a Query Reads Before It Runs](/blog/2026-06-15-know-what-a-query-reads.md)

[Architecture, Altertable Agent, Performance](/blog/2026-06-15-know-what-a-query-reads.md)

[Row estimates only hint at what an agent will read. Bytes pin it down. Our explain returns them from catalog metadata, before the engine touches a file.](/blog/2026-06-15-know-what-a-query-reads.md)

[READ ARTICLE](/blog/2026-06-15-know-what-a-query-reads.md)

[![Let Agents Render the Platform](/assets/blog/2026-05-25-let-agents-render-the-platform.jpg)](/blog/2026-05-25-let-agents-render-the-platform.md)

[MAY 25TH, 2026](/blog/2026-05-25-let-agents-render-the-platform.md)

[Florian Valeye](/blog/2026-05-25-let-agents-render-the-platform.md)

## [Let Agents Render the Platform](/blog/2026-05-25-let-agents-render-the-platform.md)

[Architecture, Altertable Agent, Engineering](/blog/2026-05-25-let-agents-render-the-platform.md)

[Charts, queries, and interactive UI now render inside AI agents through MCP Apps—the same components as altertable.ai.](/blog/2026-05-25-let-agents-render-the-platform.md)

[READ ARTICLE](/blog/2026-05-25-let-agents-render-the-platform.md)

[![Memory Is Not a Database](/assets/blog/2026-05-18-memory-is-not-a-database.jpg)](/blog/2026-05-18-memory-is-not-a-database.md)

[MAY 18TH, 2026](/blog/2026-05-18-memory-is-not-a-database.md)

[Florian Valeye](/blog/2026-05-18-memory-is-not-a-database.md)

## [Memory Is Not a Database](/blog/2026-05-18-memory-is-not-a-database.md)

[Altertable Agent, Architecture, Engineering](/blog/2026-05-18-memory-is-not-a-database.md)

[Intelligence without memory is nothing. The right model is memory that lives, forgets, and knows where it belongs.](/blog/2026-05-18-memory-is-not-a-database.md)

[READ ARTICLE](/blog/2026-05-18-memory-is-not-a-database.md)

[![Pruning Top-N Queries](/assets/blog/2026-02-03-pruning-top-n-queries.jpg)](/blog/2026-02-03-pruning-top-n-queries.md)

[FEBRUARY 3RD, 2026](/blog/2026-02-03-pruning-top-n-queries.md)

[Sylvain Utard](/blog/2026-02-03-pruning-top-n-queries.md)

## [Pruning Top-N Queries](/blog/2026-02-03-pruning-top-n-queries.md)

[Open Source, Performance, Architecture](/blog/2026-02-03-pruning-top-n-queries.md)

[A deep dive into DuckLake PR #668 and how Top-N dynamic filter pruning turns ORDER BY + LIMIT from full scans into metadata-driven execution.](/blog/2026-02-03-pruning-top-n-queries.md)

[READ ARTICLE](/blog/2026-02-03-pruning-top-n-queries.md)

[![Upside-Down Architecture](/assets/blog/2026-01-20-upside-down-architecture.jpg)](/blog/2026-01-20-upside-down-architecture.md)

[JANUARY 20TH, 2026](/blog/2026-01-20-upside-down-architecture.md)

[Yannick Utard](/blog/2026-01-20-upside-down-architecture.md)

## [Upside-Down Architecture](/blog/2026-01-20-upside-down-architecture.md)

[Architecture, Engineering](/blog/2026-01-20-upside-down-architecture.md)

[Most analytics queries scan <100MB. We explore a hybrid architecture where compute moves between servers and your local machine, powered by DuckDB and DuckLake.](/blog/2026-01-20-upside-down-architecture.md)

[READ ARTICLE](/blog/2026-01-20-upside-down-architecture.md)

[![Lessons from Search](/assets/blog/2026-01-13-lessons-from-search.jpg)](/blog/2026-01-13-lessons-from-search.md)

[JANUARY 13TH, 2026](/blog/2026-01-13-lessons-from-search.md)

[Sylvain Utard](/blog/2026-01-13-lessons-from-search.md)

## [Lessons from Search](/blog/2026-01-13-lessons-from-search.md)

[Performance, Architecture, Engineering](/blog/2026-01-13-lessons-from-search.md)

[Real-time analytics faces the small-file problem search engines solved. DuckLake's tiered compaction brings those merge strategies to streaming analytics.](/blog/2026-01-13-lessons-from-search.md)

[READ ARTICLE](/blog/2026-01-13-lessons-from-search.md)

[![Stop Batching Analytics](/assets/blog/2025-12-30-stop-batching-analytics.jpg)](/blog/2025-12-30-stop-batching-analytics.md)

[DECEMBER 30TH, 2025](/blog/2025-12-30-stop-batching-analytics.md)

[Sylvain Utard](/blog/2025-12-30-stop-batching-analytics.md)

## [Stop Batching Analytics](/blog/2025-12-30-stop-batching-analytics.md)

[Analytics, Architecture, Performance](/blog/2025-12-30-stop-batching-analytics.md)

[Why we're forcing analytics through complex batch pipelines when append-only data should work like logs. The warehouse constraint that stopped making sense.](/blog/2025-12-30-stop-batching-analytics.md)

[READ ARTICLE](/blog/2025-12-30-stop-batching-analytics.md)

[![Rethinking the Lakehouse](/assets/blog/2025-07-30-rethinking-the-lakehouse.jpg)](/blog/2025-07-30-rethinking-the-lakehouse.md)

[JULY 30TH, 2025](/blog/2025-07-30-rethinking-the-lakehouse.md)

[Yannick Utard](/blog/2025-07-30-rethinking-the-lakehouse.md)

## [Rethinking the Lakehouse](/blog/2025-07-30-rethinking-the-lakehouse.md)

[Architecture, Performance, Data Stack](/blog/2025-07-30-rethinking-the-lakehouse.md)

[Breaking down our storage and query architecture: why we're leaning into Apache Iceberg and why DuckDB is emerging as our real-time query engine of choice.](/blog/2025-07-30-rethinking-the-lakehouse.md)

[READ ARTICLE](/blog/2025-07-30-rethinking-the-lakehouse.md)

[![Under the Hood: Agents](/assets/blog/2025-07-15-under-the-hood-agents.jpg)](/blog/2025-07-15-under-the-hood-agents.md)

[JULY 15TH, 2025](/blog/2025-07-15-under-the-hood-agents.md)

[Sylvain Utard](/blog/2025-07-15-under-the-hood-agents.md)

## [Under the Hood: Agents](/blog/2025-07-15-under-the-hood-agents.md)

[Altertable Agent, Architecture, Engineering](/blog/2025-07-15-under-the-hood-agents.md)

[Altertable agents think ahead. Powered by custom lakehouse and MCP, they monitor, investigate, and act on your data autonomously.](/blog/2025-07-15-under-the-hood-agents.md)

[READ ARTICLE](/blog/2025-07-15-under-the-hood-agents.md)

[![What We're Building](/assets/blog/2025-07-08-what-building.jpg)](/blog/2025-07-08-what-building.md)

[JULY 8TH, 2025](/blog/2025-07-08-what-building.md)

[Sylvain Utard](/blog/2025-07-08-what-building.md)

## [What We're Building](/blog/2025-07-08-what-building.md)

[Product, Architecture, Altertable Agent](/blog/2025-07-08-what-building.md)

[Most data platforms wait for questions. Altertable doesn't. We're building an AI-native data OS that turns raw data into continuous insight.](/blog/2025-07-08-what-building.md)

[READ ARTICLE](/blog/2025-07-08-what-building.md)

[![Semantic Layers in 2025](/assets/blog/2025-07-01-state-semantic-layers-2025.jpg)](/blog/2025-07-01-state-semantic-layers-2025.md)

[JULY 1ST, 2025](/blog/2025-07-01-state-semantic-layers-2025.md)

[Sylvain Utard](/blog/2025-07-01-state-semantic-layers-2025.md)

## [Semantic Layers in 2025](/blog/2025-07-01-state-semantic-layers-2025.md)

[Semantic Layer, Architecture, Analytics](/blog/2025-07-01-state-semantic-layers-2025.md)

[We tested four semantic layer approaches: Looker, Omni, Cube.dev, and dbt MetricFlow. Here's what we learned about each.](/blog/2025-07-01-state-semantic-layers-2025.md)

[READ ARTICLE](/blog/2025-07-01-state-semantic-layers-2025.md)

[![Behind the Stack](/assets/blog/2025-06-10-behind-the-stack.jpg)](/blog/2025-06-10-behind-the-stack.md)

[JUNE 10TH, 2025](/blog/2025-06-10-behind-the-stack.md)

[Sylvain Utard](/blog/2025-06-10-behind-the-stack.md)

## [Behind the Stack](/blog/2025-06-10-behind-the-stack.md)

[Architecture, Engineering](/blog/2025-06-10-behind-the-stack.md)

[Our tech stack: Rails for backend velocity, Rust for high-performance ingestion, React and Urql for UIs, Iceberg for data lake, Trino for federated queries.](/blog/2025-06-10-behind-the-stack.md)

[READ ARTICLE](/blog/2025-06-10-behind-the-stack.md)

[![The Data Stack Is Broken](/assets/blog/2025-05-20-the-data-stack-is-broken.jpg)](/blog/2025-05-20-the-data-stack-is-broken.md)

[MAY 20TH, 2025](/blog/2025-05-20-the-data-stack-is-broken.md)

[Sylvain Utard](/blog/2025-05-20-the-data-stack-is-broken.md)

## [The Data Stack Is Broken](/blog/2025-05-20-the-data-stack-is-broken.md)

[Data Stack, Architecture, Product](/blog/2025-05-20-the-data-stack-is-broken.md)

[Most data sits idle—trapped behind complexity, bloated budgets, and brittle tooling. The modern data stack promised agility but delivered a slow, siloed maze.](/blog/2025-05-20-the-data-stack-is-broken.md)

[READ ARTICLE](/blog/2025-05-20-the-data-stack-is-broken.md)

## Interested in learning more about Altertable?

[Start free](/sign-up)

[Web version](https://altertable.ai/blog/tag/architecture)
