Changelog

Two new enhancements are available to simplify and streamline working with Snowflake's internal stages:

• Upload to internal stage: Provides a dedicated solution for uploading files to Snowflake's internal stage, simplifying the process of transferring data into Snowflake for further processing or analysis
• Bulk load from stage: Allows for loading files directly from Snowflake's internal stages into a table.

Long actions for databases give users the ability to handle long-running SQL queries and exports of datasets. The timeout limit for long actions is 120 minutes. New actions include:

• Run long query using custom SQL, for executing queries that require extended processing times
• Export query result, for bulk extraction from databases, without worrying about row limits

Long actions for databases are currently available for Snowflake, PostgreSQL, MySQL, and Oracle.

Queries can now aggregate and transform data from Workato data tables, in addition to applications and files, and fetch the query results as CSV to be used in downstream actions.

SQL queries can now process and transform Excel files, providing the ability to aggregate and query across both CSV and Excel data types.

To further enhance our data integration solution, we have updated and added bulk and batch CSV actions and triggers for Workato FileStorage to assist in processing, configuring, and monitoring data.

With FileStorage actions:

• Store a CSV file along with its column data type schema in a directory (Create file action)
• Append CSV lines to an already existing file with column data type validation (Append to file action)
• Fetch CSV lines from a file in batches from an existing file (Get CSV lines from file action)

With FileStorage triggers:

• Trigger and fetch any data type as a byte stream once it is available (New file bulk trigger)
• Extract complete CSV file data in batches (New CSV file batch trigger)
• Monitor a particular CSV file and fetch new lines appended to the file (New lines in a CSV file batch trigger)

When in a Workflow App, you can now filter by any of the columns visible to your role within the app, and bookmark a preferred view based on the filters set.

Examples include filtering to expenses or procurement requests above a certain dollar threshold, or narrowing down to onboarding employees in a particular department.

When audit log streaming fails, Workato now sends email notifications to the workspace admin of your account and to all users designated in the error notifications email list. For Embedded accounts, email recipients are determined based on the workspace where audit log streaming is enabled.

Email notifications will be sent for the following error types:

• Voluntary disconnections by a user
• Involuntary disconnections, when Workato detects we no longer have access
• Destination-specific errors

You can now choose between 12 and 24 hour and between m/d/y and d/m/y formats from your profile settings. Available formats are:

• Dec 31, 2024 1:00 PM (%b %d, %Y %l:%M %p)
• Dec 31, 2024 13:00 (%b %d, %Y %H:%M)
• 31 Dec, 2024 1:00 PM (%d %b, %Y %l:%M %p)
• 31 Dec, 2024 13:00 (%d %b, %Y %H:%M)

The option you choose here is reflected across your workspace, but will not affect date and time format for other users in this workspace.

For workspaces with Recipe Copilot enabled, you can now use natural language to ask Copilot to generate a formula to accomplish your goal. Copilot evaluates what combination of data pills and/or formulas will best satisfy your request, before offering you a suggestion to accept or revise as needed.

This functionality receives data about your current recipe, which may include metadata about custom fields in your systems, but does not receive any job data.

If you know an endpoint will take more than a few seconds to respond, you can now configure the HTTP action as a long action. The action will wait for a response for up to an hour, but does not guarantee ordering of job execution.

HTTP long action is a a beta release, available to everyone using Workato's HTTP connector.