May 2026: New Connectors, Smarter Notifications & Expression Functions
ETL & Reverse ETL
May's release cycle focused on expanding connector coverage, adding text and date normalization functions to the expression editor, and tightening notification control across workspaces and packages.
Introducing Service Hook Filters
Service hook notifications can now be scoped to specific packages and workspaces, so users receive alerts only for the work relevant to them. The hook filter editor includes a scope picker, improved loading for large accounts, and accurate match counts during search - making it practical to manage notifications even in accounts with hundreds of packages.
New Zendesk Connector
The ETL platform now supports Zendesk as a source, letting users extract tickets, users, and organizations via OAuth - with automatic token refresh and support for both full and incremental load. Teams that rely on Zendesk for customer support workflows can now pull that data directly into their pipelines without manual exports.
New Features
- INITCAP(): A new expression editor function capitalizes the first letter of each word in a string and lowercases the rest, covering a common text normalization step that previously required custom transformations.
- NormalizePhone(): Standardizes phone numbers into E.164 format, handling a wide range of input formats and providing configurable behavior for invalid numbers - removing the need for manual cleaning logic in pipelines that ingest contact data.
- NormalizeDate(): Accepts datetime inputs and returns the date portion, validating against multiple formats so users can reliably extract dates from mixed-format fields without writing custom expressions.
- NormalizeLanguage(): Normalizes language codes in the expression editor, expanding the set of standardization tools available when working with localization or audience data.
- Excel Sheet Selection for Large File Ingestion: When the "ingest large Excel file" option is enabled, users can now specify which sheet to load, supporting workbooks where the target data is not on the default sheet.
- Inline SFTP Key per Connection: Each SFTP connection can now carry its own Ed25519 key pair inline, giving users connection-level key management without relying on shared credentials.
- Create New Option in Cluster and Connection Pickers: Dropdowns for cluster and connection selection in the Job form and component editors now include a "Create new" option, letting users add a resource without leaving the current context.
- Package Variable Persistence: Saving package variables now immediately persists them to the database and triggers draft validation, so newly added variables are recognized in the package without requiring an additional save cycle.
Improvements
- The Mouseflow connector has been updated to move the website ID input from the connection form into the source component, aligning configuration with where it is most relevant.
- Gmail source now extracts full email bodies, replacing the previous snippet-only behavior and supporting a dedicated "Email body" field option for ingesting content without attachments.
- The Snowflake connection form has been updated from Account identifier to Account locator, reflecting the current Snowflake authentication model and reducing configuration errors.
- Azure REST API pagination is now supported for the management.azure.com endpoint, enabling reliable ingestion of paginated Azure resource data.
- AI error summaries now anchor on the deepest root cause in stack traces rather than the first exception, producing cleaner, more actionable explanations for Salesforce timeouts, S3 access errors, schema mismatches, and cluster failures.
- The Package Designer now opens the relevant component editor when a user clicks on an error in the Package Errors panel, reducing the steps needed to navigate from an error to the fix.
Fixes
- Component previewer row ordering now matches schema preview ordering.
- Sort and Window components now return rows in the correct sequence during preview.
- Window component no longer adds "stitched::" prefixes to field names in the component previewer.
- Limit component previewer now works correctly.
- Window and Union component validation no longer incorrectly disables save and preview buttons after input updates.
- Universal OAuth connector reconnection for Google OAuth now works correctly - missing parameters that previously broke the request have been restored.
- Facebook Ads destination now shows the correct operation type options for the Customers object when reopening a saved configuration.
- AI Assistant popup no longer appears behind the expression editor and other modals.
- Expression Console search in the functions popup now returns correct results.
- Multi-line CSV parsing in Cloud Storage and SharePoint sources now works correctly when a text qualifier (" or ') is set.
- Google Sheets source headers containing commas or newlines no longer shift downstream columns, and duplicate-header columns now render their values correctly.
- Renaming a workspace no longer incorrectly updates the Last Modified date on every package inside it.
- Salesforce proxy traffic now routes through the correct region for proxy-enabled accounts.
Performance Enhancements
- The hook filter editor now uses lazy loading for package and workspace lists, reducing memory usage and keeping the UI responsive in large accounts.
- JSON extraction functions have been optimized to handle a wider range of data types more efficiently, reducing processing overhead for pipelines that work with complex nested structures.
Keep exploring what shipped this month - there's a lot in here, and we'd love to hear what's making a difference for your team.
3 days ago