Author

David Malinaitis

Data Engineer & Technical Writer

9 posts

Posts by David Malinaitis

Tools & Platforms··20 min read

The best semantic layer tools in 2026, compared

The best semantic layer tools in 2026: dbt, Cube, AtScale, Snowflake, Databricks, Looker, Power BI and more, compared on agents, security and price.

Tools & Platforms··18 min read

Star schema vs snowflake schema, with real e-commerce tables

Star schema vs snowflake schema on real Shopify tables: the SQL for both, when one big table is enough, and how SCD Type 2 dimensions plug in.

News & Product updates··7 min read

GitHub Sync: manage your Weld SQL models as code

GitHub Sync keeps your Weld SQL models in a GitHub repo. Every push syncs to Weld, with pull requests, review and history for every change.

Tools & Platforms··27 min read

Amazon Seller Central & Vendor Central Reports in SQL

Build Amazon Seller and Vendor Central reports in SQL: ordered sales, settlement fees, ASIN profitability and vendor shipped COGS, with free templates.

Tools & Platforms··48 min read

How to Build a Shopify Sales Report with SQL

Build a Shopify sales report in SQL that matches your Shopify admin: gross sales, discounts, reversals, net and total sales, with a free BigQuery template.

Tools & Platforms··16 min read

How to Migrate from Snowflake to BigQuery

How to migrate from Snowflake to BigQuery: assess schemas, move and sync data, translate SQL, validate results, dual-run, and cut over safely.

Tools & Platforms··32 min read

Shopify dbt Models: A Production Sales Report That Matches the Admin

A warehouse-native dbt blueprint for Shopify sales reports: the event grain that makes numbers match, multi-store staging, currencies and tests.

Tools & Platforms··4 min read

How to set up the Weld MCP

Set up the Weld MCP server with Claude, Cursor, GitHub Copilot or Windsurf, over OAuth or an API key, and connect your AI assistant to your workspace.

Tools & Platforms··4 min read

New Feature Alert: History Tables

Most pipelines show only the latest snapshot of your source data. History Tables keep every earlier version of each record, with no SQL to write.

Build the foundation
your AI runs on.

Connect your sources, keep them synced to your warehouse, and give every agent data it can trust. Free for 14 days, no credit card.