Alex Merced

For many data analysts, daily reality is defined by “architectural friction.” You have a critical business question, but the answer is buried under fragmented data silos, brittle ETL pipelines, and queries that take forever to run. This friction turns promising data lakes into inefficient “data swamps,” where the cycle time between a question and an […]

For years, the term “semantic layer” has described a straightforward concept: creating a consistent, shared dictionary for canonical business datasets and metrics. This has been undeniably useful for ensuring that everyone in an organization is speaking the same language when it comes to data. However, as valuable as this has been, it is becoming insufficient […]

Many businesses hit an analytics wall as they grow. Production databases slow down under the weight of complex queries. Marketing teams wait for campaign data while order systems struggle to keep up. The traditional fix is building a data warehouse. This path is often slow and expensive. It requires moving and copying data through brittle […]

Agentic analytics is here. AI agents don’t wait for instructions. They take a question, explore the data, and find the next question before you ask it. This changes everything. It changes how people interact with data. It changes how quickly teams get answers. And it changes what the platform needs to do. Traditional tools weren’t […]

Data warehouse cost varies widely. One team pays for a small cloud footprint, another funds always-on compute, strict compliance, and high concurrency. This article breaks down the pricing models behind that spread, then shows practical ways to cut waste without losing speed or reliability. Agentic data warehouse cost models How these cost models work Consumption-based […]

On Monday morning, the CFO asks for a revenue view that splits by region and channel. The raw data sits in object storage, the clean tables live in a warehouse, and a few “temporary” extracts are in spreadsheets. A pipeline fails, the dashboard goes stale, and the meeting starts anyway. The right data lakehouse tools […]

Apache Polaris 1.3.0-incubating shipped in January 2026 and represents a meaningful step forward for teams building open lakehouse architectures. This release focuses on three practical needs that data engineers and architects consistently raise: visibility into table usage, tighter and more flexible authorization, and the ability to manage more than one table format through a single […]

(This blog covers this example; you can just create a fresh Dremio account and run this SQL to see this example in action, also see the end result in the 1 minute video below) The Data Burden: Moving Beyond the “Stale Data” Paradigm The traditional portfolio rebalancing workflow is broken. We are currently witnessing a […]

For decades, the data catalog has been a passive repository, a “phone book” for data that simply recorded where files lived and what columns they contained. These traditional, static catalogs have become the ultimate bottleneck in the age of AI, reinforcing data silos and offering zero intelligence to the consumers who need it most. We […]

As organizations embrace the modern data lakehouse, managing metadata has become a critical challenge. Apache Iceberg is rapidly becoming the standard for organizing huge analytic datasets, but its rise has created a new problem: how do you manage Iceberg tables across a growing ecosystem of different query engines and tools? The answer is a universal, […]

The Apache Iceberg data lakehouse has captured the industry’s imagination, and for good reason. It promises an open, flexible future where you aren’t locked into a single vendor’s ecosystem. But there’s a significant gap between that promise and the reality of implementation. Building a production-grade lakehouse from scratch is a massive undertaking. Data teams often […]

As your company grows, a familiar problem emerges: your production databases, which run your day-to-day operations, start to slow down under the weight of analytical queries. Your marketing team wants to analyze campaign performance, but running the query grinds the order-entry system to a halt. You’re forced to tell them to wait until after business […]

Every modern business wants to unlock the power of its data through artificial intelligence, particularly by enabling teams to ask questions in natural language and get immediate, data-backed answers. The promise is transformative: democratized analytics, faster insights, and a truly data-driven culture. However, a significant and frustrating paradox stands in the way. The reality for […]

Every business leader shares a common dream: to ask simple questions about their company’s data in plain English and get instant, accurate answers. “What was our quarterly recurring revenue in the APAC region?” or “Show me the top 10 most active customers last month.” This is the holy grail of business intelligence, the promise of […]

Dremio is a powerful data lakehouse platform designed to facilitate high-performance, self-service analytics and power AI-driven applications. It provides a unified semantic layer and seamless data access across diverse sources, making it a central hub for modern data workflows. While Dremio’s user interface is excellent for exploration and management, data engineers, data scientists, and developers […]

It’s impossible to have a conversation about data platforms today without AI coming up. The hype is real, and the promise of generative AI is transforming how we think about data interaction. While much of the initial focus has been on natural language-to-SQL chatbots, this is only scratching the surface of what’s possible. The most […]

For data professionals building a modern lakehouse, the data catalog often becomes a point of contention. Proprietary catalogs can create vendor lock-in, introduce unnecessary complexity, and carry hidden costs that aren’t apparent until you’re deeply invested. They promise integration but often deliver a walled garden, limiting your choice of tools and inflating your bills. Dremio’s […]

Achieving interactive, sub-second query performance on massive data lakehouse tables is the universal goal for any data team. While basic tuning, such as adjusting engine sizes, is common knowledge, many users miss the more nuanced, high-impact strategies that truly unlock the full potential of a platform like Dremio. The difference between good and excellent performance […]

For the modern analyst, the data experience is too often defined by a spinning wheel and the “ETL tax.” Traditional architectures force a choice: suffer through slow dashboards by querying data in place, or wait weeks for engineering to move data into a proprietary warehouse. This warehouse-first mindset is a relic of the legacy era […]

The most expensive resource isn’t just CPU or storage, it’s time. For the data architect, nothing is more frustrating than watching a multi-terabyte query crawl due to architectural friction. Often, the bottleneck isn’t the data size itself, but the legacy “tax” imposed by how that data is moved, translated, and cached. Dremio is more than […]

Modern data platforms are no longer built around monolithic warehouses or tightly coupled ingestion pipelines. Instead, organizations are standardizing on open lakehouse architectures, where data is stored in open formats, governed by shared catalogs, and processed by multiple engines based on workload. At the center of this shift is Apache Iceberg, which has emerged as […]

The answer to your most critical business question is likely sitting somewhere in your data. The problem? That data is spread across a dozen different systems, from object stores and databases to third-party applications. Getting a straight answer often requires complex ETL pipelines, data copies, and specialized technical skills, creating a frustrating “analytics bottleneck” that […]

Data engineering teams manage growing data volumes, more sources, and tighter delivery timelines. Pipelines break when schemas change. Queries slow as data spreads across systems. Teams spend time tuning performance, fixing failures, and explaining data meaning instead of building value. These problems block analytics and delay AI projects. AI tools for data engineering address these […]

Organizations depend on fast, predictable analytics. Query speed affects dashboards, reports, and automated systems that rely on data every minute. Slow queries increase latency, raise cloud compute costs, and limit how many users a platform can support at once. SQL query optimization sits at the center of this challenge. Teams that design efficient queries reduce […]

The demand for fast, interactive query performance is universal. For decades, the go-to solution for accelerating slow queries has been the materialized view, a pre-computed dataset that stores the results of a query. This approach saves the database from performing expensive joins or aggregations on raw data for every single request. However, traditional materialized views […]

Data chaos is a common challenge. The marketing team uses one business intelligence (BI) tool, finance uses another, and sales has their own set of dashboards. Each team defines “active user” or “monthly revenue” slightly differently, leading to conflicting reports, endless reconciliation meetings, and a pervasive mistrust in the data. The traditional solution to this […]

The success of any AI initiative depends on the data that powers it. Without the right foundation, even the most advanced models will underperform. “AI-ready data” means your information is clean, well-governed, and accessible across teams, enabling accuracy, compliance, and scalability from the start. Key Takeaways Definition: AI-ready data is structured, trusted, and usable, prepared […]

The data lakehouse, supercharged by generative AI, has become the centerpiece of the modern data stack. The promise is alluring: a single, unified platform for all data and analytics, simplified access, and AI that can answer any business question you can articulate in plain English. Yet, many organizations find themselves facing a paradox. The goal […]

For too long, the most valuable information in the enterprise has remained locked away, dormant and inaccessible. I’m talking about the mountains of unstructured data, customer feedback emails, support transcripts, research papers, legal documents, sitting in your data lake. Historically, accessing these insights meant wrestling with complex ETL pipelines, specialized tools, and costly data movement […]

Too often, promising data lakes degrade into data swamps of inefficiency, plagued by slow queries, constant tuning, and complex management. This architectural friction creates data silos and requires specialized teams just to keep the lights on, slowing down the very analytics they were meant to enable. But what if your data lakehouse could manage itself? […]