Blog

Notes from the pipeline

Guides, product updates and customer stories from the team building Weld, on moving data for analysts and agents.

More from the blog

Tools & Platforms··19 min read

MCP Servers for Your Data Warehouse, Compared

See what the Snowflake, BigQuery, dbt and Weld MCP servers can actually do on three real tasks, with setup and permissions for each.

Tools & Platforms··21 min read

SCD Type 2 in SQL: MERGE, dbt Snapshots and History Tables

Build SCD Type 2 with a tested MERGE for BigQuery, Snowflake and Postgres or a dbt snapshot, and handle deletes, late rows and as-of queries.

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··8 min read

Use agents in your Weld workspace

Ed is an agent now, on the same tools as the Weld MCP server. It searches your tables, reads their columns, checks its SQL against your warehouse, and applies a model to the open tab in one click.

News & Product updates··4 min read

Workday Financial Management is now a Weld source

Weld now syncs Workday Financial Management into your data warehouse: journals, supplier and customer invoices, contracts, purchase orders, revenue and inventory, 85 Workday objects in all.

Tools & Platforms··33 min read

How to Migrate from dbt Cloud to dbt Core

How to move a dbt project from dbt Cloud to self-hosted dbt Core in 2026: what you lose, pricing, GitHub Actions jobs, Slim CI, docs and a safe cutover.

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.

News & Product updates··5 min read

Capture deletes: keep the rows your source deletes

Capture deletes keeps rows your source deletes, marked with _weld_deleted_at, instead of losing them on a full sync. Available on every connector.

News & Product updates··16 min read

Weld Product Updates – September 2026

Weld's September 2026 updates: Capture deletes (Beta), custom full sync schedules, Snowflake upper-case names and five new sources, including Walmart.

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.