Skip to main content

Release Notes 7.6

Releases 7.6.2

May 12, 2021

What's New

EMR:

Security:

Authorization:

Trifacta node:

  • NodeJS upgraded to 12.22.1.

Changes in System Behavior

None.

Key Fixes

Ticket

Description

TD-60881

Incorrect file path and missing file extension in the application for parameterized outputs

TD-60378

Join and Union user interfaces are taking too long to respond.

TD-60187

Snowflake publishing fails during validation when both Stage database and External Stage are in use.

TD-59658

IAM roles passed through SAML does not update after Hotfix upgrade

TD-59633

Enabled session tag feature but running into "The security token included in the request is invalid" error

TD-59249

After ad-hoc publishing, job cleanup process deletes user's output directory on HDFS.

TD-59229

Uploaded CSV file fails with Parquet schema error.

TD-58932

Cannot read file paths with colons from EMR Spark jobs

TD-58591

Copied flow does not include output objects.

TD-58433

Some recipe steps missing in copied flow

TD-58036

Custom SQL query from Hive fails to run.

TD-57792

Trifacta Photon jobs take a long time to write output without chunked encoding.

TD-57653

Monitoring details not visible in dataset details and flow view

TD-57528

Slow ingest time for small XSLX files

TD-57512

Java-vfs-service is becoming unresponsive when fetching files for a parameterized dataset comprised of 10,000 files

TD-57264

Transformation engine crashes when specifying Group By parameter for List function.

TD-56739

Memory leak in java-vfs-service

TD-53375

S3 browsing 400 error

New Known Issues

Ticket

Description

TD-59854

Datetime column from Parquet file incorrectly inferred to the wrong data type on import.

Tip

Use the column drop-down to change the data type to Datetime.

Release 7.6.1

December 7, 2020

What's New

Install:

  • Support for PostgreSQL 12.3 for Alteryx databases on all supported operating systems.

    Note

    NOTE: This feature is in Beta release.

    Note

    Support for PostgreSQL 9.6 will be deprecated in a future release.

AWS:

Changes in System Behavior

Installation of database client is now required:

Beginning in this release, before you install or upgrade the database or perform any required database cross-migrations, you must install the appropriate database client first.

Note

Use of the database client provided with each supported database distribution is now a required part of any installation or upgrade of the Designer Cloud Powered by Trifacta platform.

Note

The MySQL database client cannot be provided by Alteryx. It must be downloaded and installed separately. As a result, installation or upgrade of a Docker environment using MySQL requires additional support. For more information, please contact Alteryx Customer Success and Services.

For more information:

Catalog support to be deprecated:

Note

Integrations with Alation and Waterline catalogs are likely to get deprecated in a future release.

Support for custom data types based on dictionary files to be deprecated:

Note

The ability to upload dictionary files and use their contents to define custom data types is scheduled for deprecation in a future release. This feature is limited and inflexible. Until an improved feature can be released, please consider using workarounds. For more information, see Validate Your Data.

The maintenance release updater script has been deprecated. This script could be used for performing maintenance upgrades:

  • Release X.Y.1 to Release X.Y.2

  • Hot Fixes

Key Fixes

None.

New Known Issues

Ticket

Description

TD-57354

Cannot import data from Azure Databricks. This issue is caused by an incompatibility between TLS v1.3 and Java 8, to which it was backported.

This issue is known to impact Marketplace installs of Designer Cloud Powered by Trifacta Enterprise Edition and can impact on-premises installs.

Tip

The solution is to downgrade Java on the Trifacta node to openJDKv1.8.0_242 or earlier. Java 8 is required. After you have downgraded, restart the platform. For more information, see System Requirements.

TD-56632

Non-default admin users are not automatically granted full workspace admin privileges on upgrade. These users may be able to see Workspace Settings and Admin Settings but are not granted access to edit roles and users.

Tip

Login as the default admin user. Select User menu > Admin Console > Roles. For the Workspace Admin role, select Assign Role. Assign the role to the non-default admin users.

For more information:

TD-54742

Access to S3 is disabled after upgrade.

Tip

This issue is caused by the migration of the S3 enablement setting into the Workspace Settings page. To address, set Enable S3 Connectivity to true. For more information, see Workspace Settings Page.

TD-53527

When importing a dataset via API that is sourced from a BZIP file stored on a backend datastore such as S3, WASB, or ADLS Gen1/Gen2, the columns may not be properly split when the platform is permitted to detect the structure.

Tip

Import the dataset via UI. If you must still import via API, please change webapp.loadLimitForSplitInference to 900000. See Admin Settings Page.

Release 7.6

September 7. 2020

What's New

New Flow View is now generally available:

  • Drag and drop to reposition objects on the Flow View canvas, and zoom in and out to focus on areas of development.

  • Perform joins and unions between objects on the Flow View canvas.

  • Search for flow objects by name or by type.

  • Annotate the canvas with notes.

    Tip

    The relative position of objects on the flow view canvas is preserved between screen updates. On refresh, the window on the canvas is repositioned based on the leftmost object on the canvas to focus on the flow to other objects from that one.

    Note

    Classic Flow View is no longer available.

    See Flow View Page.

Install:

  • Support for PostgreSQL 12.3 for Alteryx databases on CentOS/RHEL 7.

    Note

    NOTE: This feature is in Beta release.

  • Support for Cloudera Data Platform.

    Note

    Installation requirements for Cloudera Data Platform are consistent with installation for CDH. The Designer Cloud Powered by Trifacta platform must be installed on a pre-existing Cloudera Data Platform.

    There are minor differences in configuration. For more information, see Configure for Cloudera.

  • Support for high availability on AWS.

  • Support for high availability integration with EMR clusters. For more information, see Configure for EMR.

Job execution:

Import:

Flow View:

Plan View:

  • Apply overrides to recipe parameters for your plans. SeePlan View Page.

  • New Plan Runs page:

    • Monitor status of all of your plan runs and drill into details.

    • Download logs for plan runs and individual flow tasks in the run.

    • See Plan Runs Page.

Transformer Page:

  • Collaborative suggestions allow users within a workspace to receive suggestions based on the transformations that have been recently created by themselves or by all members of the workspace. As more users generate transformations, the relevance of these suggestions to the data in the workspace continues to improve.

  • Create and edit flow parameters and their overrides while editing your recipe. See Transformer Page.

Job Execution:

  • Support for job cancellation on EMR clusters. See Job History Page.

    Note

    Additional configuration may be required. For more information, see Configure for EMR.

  • Azure Databricks enhancements:

    • Support for creating clusters using instance pools across multiple Databricks workspaces using instance pooling and Databricks pool names.

    • Manage jobs on Azure Databricks to prevent reaching Databricks workspace limits.

    • SeeConfigure for Azure Databricks.

  • When profiling is enabled for a Spark job, the transformation and profiling steps are combined into a single task, which optimizes the execution of transform and profiling tasks for a Spark job. For more information, see Configure for Spark.

Authorization:

  • Workspace administrators can now create and assign roles to govern access to types of objects in the workspace. For more information, see Changes to User Management.

Single Sign-On:

  • Support for configurable Azure AD endpoint and authority, including Gov Cloud. For more information, see Configure SSO for Azure AD.

Connectivity:

  • Improved performance for Oracle and SQL Server connections. These performance improvements will be applied to other relational connections in future releases.

  • Improved performance when reading from Hive with many partitions into the Transformer page.

Language:

  • New approximation functions for median, percentile, and quartile based on a very fast algorithm.

  • New functions to encode and decode base64 strings.

  • New weekday name function.

  • New rolling window date functions.

  • New Kth-largest functions.

  • New conditional minimum, maximum, and mode date functions.

  • See Changes to the Language.

Documentation:

  • Additional connect string options and troubleshooting information has been included for specific relational connections. For more information, see Connection Types.

Changes in System Behavior

End of Life for Wrangler Enterprise desktop application

The Wrangler Enterprise desktop application is no longer available for installation and is not supported for use with the product. Please use one of the supported browser versions instead. For more information, see Browser Requirements.

Users section of Admin Settings is disabled

In previous releases, the Users section of the Admin Settings page was used to manage users.

  • Beginning in this release, the above area has been replaced by the Workspace Users page, where almost all user management tasks can be performed.

  • The Users section must still be used for assigning the Alteryx admin platform role and the SSO, Hadoop, or Kerberos principals through the Trifacta Application. It can be enabled as needed.

  • For more information, see Changes to User Management.

CentOS/RHEL 7.1 and 7.2 deprecated

Please upgrade to a supported distribution of either operating system. For more information, see System Requirements.

S3 access uses Java VFS service

Access to S3 is now managed through the Java-based virtual file system. For more information, see Configure Java VFS Service.

Note

No configuration changes are required for upgrading customers. For more information, see S3 Access.

Schema information is retained

When schematized datasources are ingested, schema information is now retained for publication of job results.

Note

In prior releases, you may have set column data types manually because this schema information was lost during the ingest process. You may need to remove these manual steps from your recipe. For more information, see Improvements to the Type System.

Enhanced PII masking

For social security numbers and credit card numbers, the methods by which these values are determined for purposes of masking sensitive Personally Identifiable Information (PII) has been expanded and improved. For more information, see Improvements to the Type System.

Updated credential types for connections via API

  • Redshift connections now require a different credential type.

  • Snowflake connections now require a different credential type.

  • See Changes to the APIs.

New components

Optimizer service and database: During job execution on relational sources, the optimizer service assists in managing SQL queries efficiently so that smaller volumes of data are retrieved for the job. Queries are stored in the related database.

Key Bug Fixes

Ticket

Description

TD-52221

API: Unable to update awsConfig objects in per-user or per-workspace modes.

TD-51229

When an admin user shares a flow that the admin user owns, a Failed to share flow with selected user error message may be displayed, even though the flow was successfully shared.

TD-48915

Inserting special characters in an output filename results in a validation error in the the application and job failures.

TD-47696

Platform appears to fail to restart properly through Admin Settings page due to longer restarts of individual services.

TD-49559

Cannot select and apply custom data types through column Type menu.

TD-47473

Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted.

TD-34840

Platform fails to provide suggestions for transformations when selecting keys from an object with many of them.

New Known Issues

Ticket

Description

TD-51840

Import of dataset from Alation catalog hangs.

Note

The Alation catalog integration is not working in Release 7.6. For more information, please contact Alteryx Support.

TD-50942

If a flow is unshared with you, you cannot see or access the datasources for any jobs that you have already run on the flow. You can still access the job results.

In this section: