April 2026: Real-time Package Validation & New Connectors
ETL & Reverse ETL
April's release cycle focused on tightening the package authoring loop, expanding connector coverage across CRM and analytics tools, and hardening the platform's secure-access options.
Real-time Package Validation
Package Validation now runs continuously inside the Package Designer, with a status section in the toolbar that reflects the current state of the package as you edit. Auto-validation triggers on component changes without requiring a save, and a new two-tier classification separates 'to configure' warnings from genuine errors so users can see what is actually blocking a run versus what is still in progress.
REST API Connections via SSH Tunnel
A new connection type routes REST API traffic through an SSH tunnel, letting users reach private APIs that sit behind a firewall without exposing them to the public internet. The connection is configured through the standard form and works with existing REST API source, removing the need for custom networking workarounds when integrating with internal services.
Refreshed Package Designer
The Package Designer now ships dedicated components for each database and file storage connection type, replacing the generic Database and File Storage entries on the components list.
New Connectors
- Stripe Source Connector: Pull payments, subscriptions, customers, and invoices directly from Stripe into the warehouse, giving finance and revenue teams a single source for billing analytics, churn modeling, and reconciliation against the general ledger.
- SugarCRM Source Connector: Bring accounts, contacts, opportunities, and custom modules from SugarCRM into downstream pipelines, so revenue teams can build pipeline forecasts, attribution models, and customer 360 views without exporting from the CRM by hand.
- ServiceNow Source Connector: Move incidents, change requests, and service catalog data from ServiceNow into the warehouse, letting IT and operations teams report on SLA performance, ticket volume trends, and team workload alongside the rest of the business.
- Kantata Source Connector: Pull project, resource, and financial data from Kantata into the warehouse, giving services and PMO teams the inputs they need to track utilization, project profitability, and forecast capacity.
- Klaviyo Source Connector: Ingest campaign, flow, and subscriber engagement data from Klaviyo, so marketing teams can attribute revenue back to specific sends and join email behavior with web and purchase data already in the warehouse.
- Mouseflow Source Connector: Bring session replay and heatmap analytics from Mouseflow into pipelines, letting product and growth teams join behavioral signals with conversion data to understand where users drop off and which experiments are working.
- Crisp Source Connector: Ingest conversation, contact, and helpdesk data from Crisp, so support and product teams can analyze response times, surface recurring issues, and tie customer questions back to product usage.
New Features
- Postgres JSON Column Support: Postgres destinations can now write directly into JSON columns, removing the need to serialize JSON payloads as text and parse them downstream.
- Postgres Staging Schema Configuration: Users can now configure staging tables to be created in the destination's target schema instead of the public schema, avoiding permission failures on locked-down databases.
- REST API String Unwrapping: The REST API source now offers an option to unwrap extracted string values, returning plain strings instead of JSON-quoted strings for downstream consumption.
- REST API Destination Request Throttling: A configurable sleep interval between requests has been added to the REST API destination, letting users stay within rate limits on target APIs without external throttling.
Improvements
- The AI Assistant has been migrated to a new engine, providing in-product help that is based on our live product documentation pages.
- Source component field aliases now consistently replace spaces and special characters with underscores during schema import, producing predictable column names regardless of the upstream field naming convention.
- The cURL import parser in the REST API source and Expression Editor now recognizes the `--url` flag, so commands copied from a wider range of tools parse correctly without manual editing.
- The Data Previewer now shows a human-readable timestamp tooltip when hovering over Unix datetime fields, removing the need to convert epoch values manually while inspecting data.
- Test Connection error messages on connection forms now persist until explicitly dismissed instead of disappearing automatically after seven seconds, giving users time to read and act on the diagnostic.
- Job error logs and component preview error output have been trimmed to remove stack traces and internal noise, surfacing the operator-relevant message instead of a wall of text.
- The File Source components now truncate oversized data previews to keep the application responsive when working with very large files.
Bug Fixes
- Fixed an issue in the SFTP source where seeking inside SFTPInputStream caused records to be silently dropped from the output.
- Fixed Excel ingestion so that blank cells are treated as null instead of empty strings, matching expected behavior in downstream type-sensitive operations.
- Fixed `_WORKFLOW_PACKAGE_LAST_SUCCESSFUL_JOB_SUBMISSION_TIMESTAMP` to return the parent workflow's last successful timestamp for sub-packages, where it had previously returned empty.
- Fixed an issue where Dynamics and SharePoint connectors did not refresh access tokens automatically, causing long-running jobs to fail mid-run.
- Resolved a scheduler issue where DST offsets were applied incorrectly, shifting scheduled runs by an hour at transition boundaries.
Performance Enhancements
- Excel file previews from SFTP sources have been optimized to handle larger files without timing out, restoring the previewer's usefulness on multi-megabyte spreadsheets.
- The File Uploader has been reworked to handle large-size files reliably, eliminating failures that previously occurred above certain size thresholds for some file types.
Alongside this release, our fully updated documentation is now live, with refreshed content and improved accessibility throughout. For quick lookups while you work, use the Ask Assistant button at the top of the UI to surface answers without leaving the tool.
Have a look at what shipped this month and let the team know which improvements are landing well in your day-to-day work.
about 1 month ago