Release Notes for Alteryx Analytics Cloud Platform

Connectivity Performance for Standard Mode

This update makes it faster and easier than ever to bring data in from your connections and publish it back. You’ll notice quicker load times for tasks like listing tables and files, navigating pages, creating datasets from connections, and publishing them. Get ready for a smoother, more efficient experience!

Enable Parquet as Extract Output Format for Standard Workflows

In this release, all relational connectors will support Standard Mode with BigQuery as exception.

New Job List Interface for Designer Desktop

Modernized interface that aligns with the Designer Cloud experience and improved filtering options. Switch to the new (MFE) interface and experience the upgraded design!

Hide Webapp Dataset APIs

All Webapp dataset endpoints should be removed from AAC customer documentation.

Access-related Exceptions

We’ve resolved several access-related errors that appeared in our logs when users attempted to access resources through their connections. Error messages are now more readable and actionable, providing clearer guidance compared to previous versions that displayed end-system logs with limited context.

Connectors enhanced are Redshift, External S3, Postgres, Amazon RDS Postgres, Netsuite, Google sheets, Amazon Athena, Salesforce, and Oracle.

Self Service Google OAuth Apps

AACP now allows Global clients to use Google connectors with added flexibility. Admins can register their own tenant-based apps/clients for any Google connectors that previously required Alteryx global client apps. Both self-service tenant-based and global client options are now available.

Allow Read OAuth Client

Admins can now view the details of the OAuth client apps they register in Admin Console.

Find and Replace for Snowflake

Updated Find and replace tool can be used for snowflake pushdown.

Restructure of Data Tab:

Schema information is available without triggering preview and Number of rows in Dataset is also available.

Products column in admin workspace-list table:

The Workspaces page, found in the Account Admin Console, now shows which products have been enabled for each workspace.

Qlik Cloud Analytics Connector:

You can now publish directly into your Qlik Cloud datasets with the Qlik Cloud connector. You can only map 1 table under a Qlik Cloud dataset for every output tool, append new rows to an existing Qlik Cloud dataset-table, and also create new datasets under selected spaces and collection under your Qlik Hub.

You are able to filter based on Spaces and collection in the Output tool to publish under specific destination that you choose.

For more information, go to Qlik Connections.

Enhanced search and pagination for Oracle and SQL Server is available.

An exception is thrown for unsupported data types when the Parquet reader encounters binary data.

Currently, Blob types are not supported in Designer Cloud. If someone tries to create a Blob type in Cloud mode, the AMP Engine will throw an error saying, Unsupported type in Cloud: Blob.

Time and DateTime values are now written to Parquet files with full precision. The process has been updated to ensure that fractional seconds are preserved, preventing any loss of data when writing these types to Parquet files.

ISO 8061 string values are now generated from Parquet Time values, ensuring that no data is lost in the process.

Connectors supported in Standard Mode:

Global Search

Global Search allows you to quickly find and access specific assets, such as workflows, connections, and datasets, within your workspace through a unified search bar. See Platform Landing Page for more information.

New schedules created for flows in Trifacta Classic may not appear in the UI, even though they are successfully triggered and completed in the backend. This behavior is particularly noticeable when creating multiple schedules for the same flow. If a new schedule does not show up in the UI, you can verify the execution of the schedule by relying on email notifications for flow completion.

When attempting to schedule a flow in Trifacta Classic using the "File Watcher" (also called "Event Watcher") trigger type, users may encounter the error message "Scheduling service not available." This occurs even though the scheduling service is operational and available. At this time, no direct workaround exists for this issue. Users may need to monitor and manage their schedules through other parts of the platform.

The Default role no longer includes permissions to workflows. To grant access to Designer Cloud, administrators must assign users the Designer Cloud Creator or Designer Cloud Consumer roles.

Support of DesktopApp to CEfD section for Library. User with permission related to Analytic App:

can upload, manage, and run Analytic app in the Library.

BQ billing project: As a user of AACP you can utilize a billing project to execute workflows, ensuring that the associated query costs are correctly attributed to the appropriate project. By working within the billing project context, operations like creating AACP datasets, samples, custom SQL queries, and running AACP jobs are billed to the default billing project.

Previously, the AACP files were stored in the root folder by default. You can now setup a base path when configuring AWS S3 as Private Data Storage. All the files created in AACP (uploaded files, workflow outputs and temporary files like samples) will be stored in folders after the base path. You can also block users from exploring data in S3 Private Data Storage in AACP by setting the flag in Admin Console > Storage > Hide Underlying file systems to Users to Enabled.

The Google Ads connector has been updated with the latest Cdata driver.

Read Support for XML file as an input:

End of Life Static Tokens on AAC. Going forward, all users should use OAuth tokens to access the Analytics Cloud API.

Capture audit logs for Scheduling. We have introduced Audit Events for Scheduling to enhance visibility and tracking of actions related to scheduling activities.

Account Admins now have the option to set up an audit connection to their AWS S3 bucket. For more information, see Admin.

You can now import values from Excel with and without formatting.

Workflow metadata tagging and Library (workflows) rebuild:

For more information, go to Library for Assets Page.

The Email task in Plans is now available. Have your workspace admin set up the email server in their Workspace settings. Note that attachments are currently not supported.

New options are added for Dataset list page like Refresh, Delete, and Edit.

Trino connection upgraded to latest CData driver.

Gallery API Decommission

Gallery (gallery.alteryx.com) has been deprecated fully now. The site will be deleted soon. Gallery is now on Community!

New accounts will see the new Role name after promotion to production.

Existing accounts with the Designer Desktop Creator role will be migrated to the new role by September 26th or later.

You are now able to filter Jobs by Workflow name.

All Connection events are logged and available for Audit.

You can now schedule Plans from within Platform Library > Plans > More Options menu (3 dots).

Alteryx Analytics Cloud (AAC) supports running queries with or without using BigQuery OAuth credentials. You can either use files as input and BigQuery as the output destination, or use BigQuery as the input and generate files as the output.

The HTTP task now supports the ability to delete the dataset created from an HTTP response after a Plan execution, using the dataset as an input in a downstream task, without creating new datasets in your workspace each time.

Output tool is completely redesigned to be represented as a popup modal. There are no changes in the capabilities of Output tool.

Cdata connector LinkedInd Ads has been upgrade to support latest APIs.

The platform now supports warm pools that helps dramatically reduce the time to create a dataset from a relational source during design time. With this improvement, the excel upload times have significantly reduced. Overall better platform performance for users during design.

Account Admins and Billing Account Admins can now see workflow run usage data on the product page in the Account Admin Console. Temporarily, data for EU1 and AU1 regions is limited to only reflect workflow runs completed after May 24th, 2024. US1 reflects comprehensive usage against contract quotas, and EU1 and AU1 regions will be updated to reflect comprehensive usage in Q4.

In Cloud Native mode, the ValidInt formula function now correctly identifies strings containing integer values with a decimal separator (e.g., "10.0") or in scientific notation (e.g., "1e3") as valid integers.

As a user with permission to share, you can now share a workflow with another user who has the View permission.

As a user with the View permission, you cannot share the workflow or edit the sharing options.

url,

method,

request_body,

request_headers.

Publish directly into your Power BI Cloud datasets using the Power BI connector.

Map one table per Power BI dataset for each output tool.

Append new rows to an existing table in a Power BI dataset.

Overwrite existing tables in Power BI datasets. When overwriting, you can choose to update the columns/schema of the table, or retain the existing columns.

For more information, go to Microsoft Power BI Connections.

Fixed an issue where the output data resulted as empty when using Snowflake to output data with at least one tool.

Previously, users had to manually refresh datasets connected to SharePoint files. Now, datasets based on files uploaded through this connection will update automatically. For example, if an app, software, or user  updates "Sales.xlsx" in SharePoint, the "Revenue" workflow in Alteryx will now automatically pull the updated data without manual refreshes. This bug fix enables real-time data updates in the workflow.

Added a new Designer Cloud Consumer role with the permission to view and execute Designer Cloud workflows. To view the detailed permission, go to the Permissions Matrix.

You can now upload text files (.txt) on the Data page.

Auto Insights datasets are now included in a new Library Assets page. The Assets page for Auto Insights provides visibility of Name, Shared with, Owner and Last Updated, and access to dataset-related menu actions, including...

Auto Insights datasets are now available in the Schedules interface to create new refresh Schedules.

A new option is available in the Data page to Use an Analytics Cloud dataset in Auto Insights.

When creating an external S3 connection, you can now set a default directory path from your default S3 bucket.

Updated the look and feel of the Designer Cloud job history page.

New user registration now supports all RFC5332-supported email formats.

You can now preview the new Data page UI experience. To try it out, select the New Dataset Experience toggle on the Data page.

Updated the Designer Cloud Creator role to include full permissions to Datasets, Connectors, and Plans. To view the detailed permission, go to the Permissions Matrix.

Admins can now invite users with email addresses that include ICANN-era top-level domains.

Users can now sign in to workspaces to which they have been invited without first accepting their invite via email.

You can now find Cloud Execution for Desktop documentation inside the AAC content.

Cloud Execution for Desktop is now available for GCP Private Data Processing. For more information, go to Cloud Execution for Desktop in GCP.

API endpoints used to assign roles now only require user id and role id values to succeed. The rest of the role payload is now optional. This change affects these endpoints...

AAC now automatically disables schedules with incorrect file paths if they fail after multiple attempts.

Added dynamic identifier support for OAuth 2.0 tokens.

Added a link to the Licensing and Download Portal on the Account Management page.

Fixed an issue where Excel files with a high sheet count failed to upload. The sheet limit is now 399.

Enabled Databricks Spark to handle ADLS input and output to ADLS-mounted DBFS tables.

You no longer need to include the x-alteryx-account-id header for OAuth 2.0 API tokens.

You no longer need to include the x-trifacta-workspace-name/id header for OAuth 2.0 API tokens.

Account Admins can now manage Workspace Admins. Account Admins can add, remove, disable, enable, and reinvite Workspace Admins.

Account Admins can now see how many users belong to each workspace under their account. To view the number of users in each workspace, look for the Users column on the Account Management Workspaces page.

Admins should now be able to invite users who have ICANN-era top-level domains.

Added Tableau Connections.

Added a warning to the Static API Access Tokens page that these tokens have been deprecated.

Fixed an issue where the API Token deprecation warning link opened an iframe. The link now correctly redirects the user.

Renamed the Users page in the Account Admin Console to the Admins page. Use this view to manage admin access to your AAC account.

Added read support for Excel XLSM files to the Input Data tool and datasets you create on the Data page.

Added an account-level Single Sign On (SSO) configuration page to the Account Management page.

Fixed an issue where AAC displayed Dataset Deleted on the Jobs page if a user ran a workflow from Plans.

Fixed an issue where you were unable to upload Excel files containing currency symbols or the accounting number format to Designer Cloud.

Fixed an issue where Designer Experience jobs didn't display if the workflows ran from Plans.

Updated the CData driver for NetSuite Connections.

Added OAuth 2.0 authentication for REST API Connections. For more information, go to OAuth 2.0 for REST API.

Updated the look and feel of the Connections page and underlying pages.

The App Builder Creator role now includes permissions to App Builder applications, datasets, connections, and plans.

The Location Intelligence Creator role now includes permissions to Location Intelligence projects and datasets.

Account Admins can now view the workspaces associated with their account.

Users are no longer required to provide GCP resource manager API permissions to create Big Query connections in AAC.

Added a Connection Credentials Sharing option to the Admin console. Use this option to allow users to share credentials when sharing a Connection. Enabled by default.

You can now overwrite Excel files in OneDrive and Sharepoint.

Added JSON file support. For more information, go to Supported File Formats.

Updated Excel file import functionality. If there are blank rows at the start of a file and you select the first row as header, AAC skips the blank rows and treats the first non-NULL row as the header.

Resolved an issue that prevented a Workspace Admin from disabling OAuth 2.0 tokens created by other users.

Resolved an issue that prevented admins from switching from one account to another.

The Designer Creator Role now correctly includes full permissions to workflows.

Updated Search for Google Sheets Connections

Added Write Support to Box Connections

Fixed an issue where scheduled jobs ran when Private Data Processing didn't exist.

Fixed an issue where users experienced an infinite loop after accepting an invitation to a workspace configured with SAML SSO.

Fixed an issue that prevented users from viewing their own sessions in User Preferences.

Added separate sections on the Workspace Settings Page for both the legacy access tokens and the new OAuth 2.0 API tokens. Admins now have more control over what API tokens users can generate.Access Tokens Page

Fixed an issue where AAC would hang when you used grouping with the XIRR function in the Summarize tool.

Fixed an issue where the Unique tool produced different results between the AMP and Snowflake engines.

Resolved an issue where the sort function wasn't working for BiqQuery datasets.

Resolved an issue where Plans were not triggering as scheduled.

Removed duplicate Auth fields from the Airtable Connections configuration window.

New users must now accept the Alteryx End User License Agreement (EULA) before they can access AAC.

Updated the look and feel of the registration page.

If you belong to 1 or more accounts, you can now directly sign in to an account when you sign in.

Added the email of the user that triggers an event to the Audit Logs Page.

Resolved an issue where some valid Snowflake connections failed with an error such as no metadata produced or dataset is taking longer than expected.

Resolved an issue where users whose permissions went from Workflow Author down to Workflow Editor were still able to see the Duplicate and Delete buttons, even though they could not use those functionalities.

Resolved an issue where you could select Snowflake as an execution engine when using inputs that aren't supported for Snowflake pushdown processing.

Resolved an issue with Job failures for sources from Unity catalog and writing to Azure Data Lake Storage (ADLS).

Resolved an issue where users with multiple workspaces that bypassed workspace selection and navigated directly to the Platform landing page saw unexpected errors.

Resolved an issue that caused multiple UI errors when a target schema was added to a recipe in the Trifacta Classic experience on AAC.

Resolved an issue where random sampling sometimes didn't work when you executed the workflow in Snowflake.

Resolved an issue where some workflows failed when using Photon to run a workflow that output to a Snowflake database.

Resolved an issue where some flows succeeded with Photon but failed with Spark with a memory allocation error.

Resolved an issue where some REST API connection calls failed with this error: HTTP protocol error. 500 Server Error.

Resolved an issue where workflows using the DateTime tool failed in Designer Experience when Snowflake was used as an execution engine.

Resolved an issue where Snowflake was listed as an execution engine when Snowflake accounts with different roles were used in a workflow.

The Default role no longer includes permissions to Flows by default. Instead, the Designer Cloud Creator role now includes Author permissions to Flows.

You now have access to your Reports on the Library page. Use the 3-dot menu next to each Report to open, schedule, or delete a Report.

Improved performance for users with over 1000 files and folders.

AAC now restricts file uploads to supported file types only.

Added Parquet file support to the Data page. You can now upload Parquet files and then use them with the Input Data tool in Designer Experience.

Added support for Excel output to an external S3 location.

Added the option to append data to a sheet in an existing Excel file.

Updated the Oracle driver for Oracle Database Connections.

Updated the CData driver for ServiceNow Connections.

The Flows tab was sometimes hidden from users that had sufficient permissions.

Designer Cloud Workflow runs sometimes failed after changing engine selection.

An option to export Designer Cloud Workflows was exposed, even though the user could not use it.

Added a Browse Data button when you hover over your connections on the Connections page. Select Browse Data to go to that connection's Import Data page.

Added a Connect to Data link to the Input Data tool configuration panel in Designer Experience. Select Connect to Data to go to the Data page, then select a dataset for the Input Data tool.

Alteryx Analytics Cloud is now hosted within the EMEA and APJ regions. This regional availability supports EU and Asia Pacific customers who have tightly regulated data. Additionally, this availability helps customers conform to the General Data Protection Regulation (GDPR) and Australian Privacy Act requirements, along with other rules and regulations on data usage.

Updated the CData driver for Authorize.net Connectionsand Airtable Connections.

Resolved an issue where you could create a Plan with an empty Flow task.

Location Intelligence assets now show on the Library page.

Workspace admins can now view the job history of Designer Cloud and Designer Desktop workflow jobs from all users on the workspace.

Resolved an issue where the Connections page could not be opened in Firefox.

Support for XLSX and XLS files.

You can create 1 dataset per workbook per sheet.

You can select if the first row includes headers or not.

Maximum file size of 500 MB. For larger files, upload your data through the Data page.

Updated the CData Driver for Apache Impala Connections.

Added an event trigger Run option for your Schedules. Use event triggers to schedule a Workflow, Flow, or Plan when an application creates or updates an existing file. Use this capability for real-time responses to external events. To learn more, go to Add Schedule Dialog.

Updated the CData driver for Zoho CRM Connections.

Added integration with Databricks Unity Catalog:

You can now use Databricks as your Spark engine to run workflows. Leverage Databricks' advanced capabilities for distributed data processing while you work in your familiar AAC environment.

Updated the CData driver for Microsoft Advertising Connections.

For Workspaces using a Private Data Plane, you can now run Spark jobs in Amazon EMR. To learn how to enable EMR, go to Private Data Processing.

Resolved an issue where you couldn't use datasets as Designer Cloud inputs when the datasets came from relational connections and the columns had duplicate names with numerical suffixes (for example, column and column1).

Resolved an issue where the number of columns attribute was sometimes incorrect for input datasets in Designer Cloud.

Resolved an issue so that you can now create an AWS connection when aws mode is set to user.

We now support the Google Analytics 4 connector. Use the new connector to create a GA 4 connection to one of the two schemas: Universal Analytics and Google Analytics 4.

The Shopify connector now supports both an API key and a new Access Token authentication method. We recommend that you move to the new Access Token authentication method.

In the Designer Cloud Output tool, you can now browse through a list of your files and folders. You can also perform a search within a particular directory. The search keyword only applies to files and folders under the directory you are currently in, it won't continuously search for downstream folders.

JIRA by Atlassian Connections

LinkedIn Ads Connections

Shopify Connections

Microsoft Sharepoint Files Connections

Microsoft OneDrive Connections

Resolved an issue where newly uploaded files were not immediately visible in the list of datasets in the Input tool in Designer Cloud.

Resolved an issue where Snowflake datasets created from XLSX files couldn't be used in the Designer Cloud Input tool.

Resolved an issue where workflows failed when Snowflake was the selected engine and the workflow included an input imported via an SFTP connection.

You can now create a dataset with parameters to import multiple CSV files at once (go to Create Dataset with Parameters for more information). Use the parameterized dataset with the Input tool in Designer Cloud to get results from all the data that match the parameters.

You can now share datasets with other users in your workspace.

Resolved an issue where workflow jobs showed "Dataset deleted" instead of the asset name.

Resolved an issue where workflows could be run in Designer Cloud when the output tool wasn't configured properly. An appropriate error is now shown.

Resolved an issue where the Designer Cloud output tool didn't retain publish settings when incompletely configured, using a connection, and closed by clicking somewhere else on the canvas.

Resolved an issue where files saved directly under the S3 bucket were incorrectly displayed under a folder with a blank name.

Resolved an issue where characters were not allowed in an output file name, but were accepted until a workflow was run, then it failed. Now an error is displayed when the incompatible characters are entered.

Updated the Auto Insights tile on the landing page to directly go to Auto Insights, rather than opening a pop-up window. If you are eligible, you will automatically sign in to Auto Insights, or a new Auto Insights trial will be created for you.

Added functionality to the Switch Workspace list in the Profile menu. If you have access to multiple workspaces, you can now search and scroll through a list of the workspaces. Additionally, a checkmark next to a workspace name indicates your current workspace.

Updated the CData driver for QuickBase Connections. For more information, go to QuickBase Connections.

Resolved an issue where the Run button was available for Workflows with a misconfigured output tool on the Designer Cloud canvas.

Resolved an issue where the scheduling window disappeared when the hourly frequency field was displayed but the start field was manually emptied.

Resolved an issue where the default storage showed as N/A when AWS credentials were already set up for the workspace. Default storage now reflects the AWS connection defined for the workspace.

Resolved an issue where S3 connections could get into a bad state when aws.mode = 'user'.

Resolved an issue where Dataset imports were failing for Redshift IAM connections.

You can now pushdown to Snowflake and then output to a file. Pushdown provides faster processing and lower compute costs. These are the supported file types for Snowflake pushdown:

Resolved an issue where the Logout button didn't work on some pages when SSO was enabled on the workspace.

Resolved an issue where ValidInt returned false positives when using Snowflake pushdown.

Resolved an issue where Snowflake pushdown was sometimes incorrectly recommended by default when multiple output tools to multiple locations were used in a single workflow.

Resolved an issue where users were able to run a Snowflake full pushdown job with an External S3 source, resulting in a job failure. This isn't supported at the moment; AAC only supports the admin/user level S3 for full pushdown.

Resolved an issue where Avro previews sometimes failed to display.

Resolved an issue where some production workspace admins couldn't view all jobs.

You can now Browse and Publish XLS or XLSX workbooks on these file stores:

You can now use the Designer Cloud Output tool to define a Sheet Name when you output an Excel file.

Added a Contact Admin button to apps on the landing page that you don't have permission to yet. To request permission, select Contact Admin to view a list of active admins on your workspace.

Updated the Auto Insights tile on the landing page to directly go to Auto Insights, rather than opening a pop-up window.

Early Preview (read-only) connections available with this release:

Support for creating these additional connections:

Resolved an issue where job run options included Snowflake when it wasn't a valid option.

Resolved an intermittent issue where auto-linked tasks prevented successful Plan runs.

Use the recently released Machine Learning Upload task in Plans to train an ML model in an existing project. The ML Upload task connects to existing task outputs.

You can now use the Output tool in Designer Cloud to save CSV files to customer-provided Base S3 Storage or Alteryx Data Storage, which is an Alteryx-managed S3 storage. Use this capability to easily output a CSV file to Alteryx Analytics Cloud. You can then use this file as input for another workflow or application without downloading data onto your physical machine or leaving Alteryx Analytics Cloud.

Improved load time for asset table UI when displaying more than 100 records.

Resolved a vulnerability where some of the connectors we support might have been able to access unauthorized resources that were available in its container or within the cluster.

Resolved an issue where some errors were rendered as empty when editing a Dataset name or description from within the Designer Cloud Input tool.

Resolved an issue where an error was incorrectly shown in the tool config of a newly added output tool after a former job run had already been completed. Now, messaging indicates that the user needs to run the job to see the output.

Resolved an issue where users of the Designer Cloud Input tool were unable to select a dataset that was uploaded on the Import Data page.

Resolved an issue where CSV output differs from its input when ToNumber is used.

Resolved an issue where some previously successful Snowflake connections were unable to connect, with the error: "SSLPeerUnverifiedException: Certificate doesn't match any of the subject alternative names: [*.drtst.org, drtst.org]."

Resolved an issue with ingesting data via an Oracle database connection with SSH tunneling when running a Designer Cloud workflow.

Resolved an issue with ingesting data via configured Snowflake connection with an OAuth client when running a Designer Cloud workflow.

Resolved an issue where Plans were failing, even though associated flows were succeeding.

Resolved an issue where Schedules could not be opened from the Plans UI.

Resolved an issue where the POST /v1/schedule endpoint was unresponsive.

Resolved an intermittent issue where auto-linked tasks prevented successful Plan runs.

Resolved an issue where jobs failed when using Snowflake only and feature.enableEMRExecutionViaJPL was set to true.

Resolved an issue where only 25 records were displayed on Library pages when a higher limit was selected.

Admins can now assign roles to users while inviting those users to the workspace.

Admins can now select multiple users at once and apply an action such as adding roles or disabling users.

Admins can now sort and filter their users.

Added these updated operations to the Alteryx Analytics CloudAPI.

Use the ML Upload task type upstream of a task with a CSV output. Note that uploading a new CSV input to an existing ML project will not automatically retrain your model. To retrain your model, go to the Auto Model stage in Machine Learning.

Use the ML Prediction task type downstream of a task that outputs a CSV file. The CSV file must be compatible with the model session selected.

Resolved an issue where Plans failed even though the underlying workflows were succeeding.