Alex Merced — Developer and technical writer sharing in-depth insights on data engineering, Apache Iceberg, data lakehouse architectures, Python tooling, and modern analytics platforms, with a strong focus on practical, hands-on learning.
418 articles from this blog
Guide on connecting any Apache Iceberg REST Catalog to Dremio Cloud for universal lakehouse data access and management.
Guide on connecting AWS Glue Data Catalog to Dremio Cloud for querying and managing AWS Iceberg tables with full DML support and federation.
Guide on integrating Apache Druid with Dremio Cloud to enable SQL joins, AI analytics, and governance for real-time data.
Guide to federating Azure Synapse Analytics with Dremio Cloud for multi-cloud analytics, query acceleration, and unified governance without data movement.
Guide on connecting PostgreSQL to Dremio Cloud for federated queries, analytics acceleration, and building a semantic layer without data movement.
Guide on connecting Azure Storage to Dremio Cloud to query data lakes with SQL and AI, avoiding costs of Azure Synapse.
Guide on connecting Vertica analytics database to Dremio Cloud for data federation, cost reduction, and modern analytics workflows.
Guide on connecting Databricks Unity Catalog to Dremio Cloud to query Delta Lake tables with federation, AI analytics, and performance acceleration.
Guide on connecting Snowflake Open Catalog to Dremio Cloud for multi-engine Apache Iceberg analytics, federation, and cost optimization.
Guide on connecting SAP HANA to Dremio Cloud for federated analytics, enabling queries across SAP and non-SAP data sources without data movement.
Guide on connecting Oracle Database to Dremio Cloud for federated analytics without data movement, covering setup, optimization, and AI integration.
Guide on connecting Snowflake to Dremio Cloud to federate queries, accelerate performance, and reduce Snowflake compute costs.
Tutorial on using Dremio's AI_COMPLETE SQL function to generate product summaries, marketing copy, and translations directly within a data pipeline.
Introduces Dremio's built-in Open Catalog for Apache Iceberg, offering a zero-configuration, production-ready lakehouse solution with automated management.
Tutorial on using Dremio's AI_GENERATE SQL function to extract structured data from unstructured text like emails and contracts.
Explains the distinct roles of data catalogs and semantic layers in data architecture, arguing they are complementary tools.
Explains how a semantic layer enforces data governance by embedding policies directly into the query path, ensuring consistent metrics and access control.
Explains how data virtualization and a semantic layer enable querying distributed data without copying, reducing costs and improving freshness.
Explains the difference between a metrics layer and a semantic layer in data architecture, clarifying their distinct roles and relationship.
Explains why AI data analytics fail without a semantic layer to define business metrics and ensure accurate, secure queries.
