Release Notes for Alteryx Analytics Cloud Platform

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.

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.