Weld Product Updates – June 2026

June was packed with updates. Snowflake can now be used as an ELT source, we shipped new Google My Business Profile streams, and launched two new connectors (Unleashed and SevenRooms). On the connector side, we made significant updates to Facebook Ads, Klaviyo, HubSpot, Gorgias, Pinterest Ads, Stripe, and YouTube Analytics.

Here's everything new and improved in Weld this month.

New Features

Snowflake as an ELT Source

Snowflake can now be used as an ELT source, in addition to its existing role as a destination. Connect to any Snowflake account, select one or more databases, and sync any table directly into Weld. Incremental syncs are supported via a configurable pointer column, and full syncs and append-only syncs are also available.

Available on Business plan and above.

History Tables

Your source data is constantly changing but most pipelines only show you the latest snapshot. With History Tables, Weld automatically captures every previous version of your records, giving you a complete, auditable timeline of your data without writing a single line of SQL.

Enable history on any stream and Weld appends a timestamped copy of each record whenever it changes. The result is a full slowly-changing-dimension (SCD Type 2) table you can query for point-in-time analysis, audit trails, and trend detection.

The plan usage dashboard also now shows history table rows as a separate segment in source-stream usage charts, so you can see exactly where your row usage is going.

Read the full History Tables guide →

Weld MCP Server

The Weld MCP connects your AI assistant (Claude, Cursor, GitHub Copilot, or Windsurf) directly to your Weld workspace. Query your data warehouse, list syncs, inspect connections, debug pipelines, or create SQL transforms, all conversationally without switching context.

This month we also renamed the MCP query tools to run_query, get_query_status, and get_query_result to make the async workflow clearer for AI agents.

How to set up the Weld MCP → · See what you can do with it →

New Connectors

Unleashed

Unleashed is a cloud-based inventory management platform for manufacturers, wholesalers, and distributors. The new connector syncs your full Unleashed account: products, customers, suppliers, sales orders, purchase orders, invoices, shipments, stock counts, assemblies, bills of materials, and more. That's 37 top-level streams with substreams for nested data.

Explore Unleashed documentation →

SevenRooms

SevenRooms is a guest experience and retention platform for hospitality. The new connector syncs venue, client, charge, event, payout profile, program, reservation, reservation feedback, reservation request, and client venue stats streams.

View SevenRooms data schema →

Connector Updates

Google My Business Profile: Daily Performance & Search Keywords

Google My Business Profile now includes two new streams: location_performance_daily for daily location performance metrics and search_keywords_impressions_monthly for monthly search keyword impressions showing which search terms drive discovery of your business listings.

Gorgias: Custom Reports & Per-Event-Type Tables

Gorgias got two major additions this month. Custom reports let you build warehouse tables from any Gorgias Reporting Statistics scope, picking measures, dimensions, time dimension, and granularity. Each report becomes its own report_<name> stream.

Per-event-type tables let you sync individual Gorgias event types (e.g. ticket-closed) as separate append-only streams, enabling accurate resolution-time reporting that matches the Gorgias native dashboard.

HubSpot: Property History for Custom Objects & Field Collision Handling

HubSpot custom objects now expose a property history stream, previously only available for built-in objects. Each custom object type gets its own <object>_property_history table tracking every change to every property over time.

We also improved how HubSpot handles properties that produce duplicate column names after normalization. When multiple properties collapse to the same snake_case name, the connector now preserves trailing underscores to avoid column collisions.

Shopify: Product Variants Reverse ETL

Shopify Reverse ETL now supports product variants via bulk create and update operations. Write price, SKU, inventory quantities, option values, and compare_at_price back to Shopify.

Pinterest Ads: OUTBOUND_CLICK Metrics & Country Targeting

Pinterest Ads adds OUTBOUND_CLICK metrics to all report schemas and introduces country-level targeting report streams for ad accounts, ad groups, and campaigns.

Klaviyo: SMS Metrics & Weekly List/Segment Re-Syncs

Klaviyo now offers four additional SMS statistics on Campaign Values and Flow Values custom reports: message_segment_count_sum, text_message_credit_usage_amount, text_message_roi, and text_message_spend.

List and segment membership tables also now run a full re-sync once a week to preserve accuracy. These re-syncs do not affect row usage.

Stripe: Inactive Prices Stream

Stripe now has a dedicated price_inactive stream for syncing archived prices, with a price_inactive_tier sub-stream for tiered pricing data.

Additional Connector Updates

• Facebook Ads: The comscore_market breakdown replaces the deprecated dma breakdown, with a new demographics_comscore_market report stream.
• Facebook Pages: Updated for Meta's Graph API v25 metric deprecations. Retired legacy reach/impressions metrics and added new Media Views / Media Viewers replacements.
• Instagram Business: Reach columns on user_insights widened to nullable to handle missing data from Meta.
• Amazon Selling Partner: New inventory_list stream for Amazon Warehousing and Distribution (AWD) inventory.
• AWS S3, Google Drive, OneDrive: Custom table name override now available.
• Traede: New product_cost_price_set substream.
• YouTube Analytics: Bulk reports migrated to new versions with the engaged_views metric. New Reach reports added. Legacy report versions removed.

Platform Improvements

Shopify & PayPal: Legacy History Tables Deprecated

The integration-specific history table streams for Shopify and PayPal are now deprecated in favor of the generic per-table history table feature. Existing syncs continue to work, but we recommend migrating to the generic approach.

Bug Fixes

• REST API: Publishing transforms via the Weld Connect REST API no longer drops existing schedule, orchestration, partitioning, and clustering settings.
• Postgres destination: The statement timeout lock notification now correctly shows the duration in minutes instead of raw milliseconds.

That's a wrap for June! For the full technical details, check out the June 2026 release notes.

Questions or feedback? Reach out to us anytime.