David Malinaitis
Data Engineer & Technical Writer
9 posts
Posts by David Malinaitis

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.

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.

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.

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.

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.

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.

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.

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.

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.