Release Notes 5.0

Release 5.0.1

This release includes a number of key bug fixes and updates. 

What's New

• Promote users to Alteryx Administrator role. See Create Admin Account.

Changes to System Behavior

None.

Key Bug Fixes

Security Fixes

The following security-related fixes were completed in this release.

New Known Issues

New Known External Issues

The following issues are sourced from third-party vendors and are impacting the Designer Cloud Powered by Trifacta platform. 

Release 5.0

Release 5.0 of Designer Cloud Enterprise Edition delivers major enhancements to the Transformer page and workspace, starting with the new Home page. Key management capabilities simplify the completion of your projects and management of scheduled job executions. This major release of the platform supports broader connectivity and integration.

Improving user adoption:

The new workspace features a more intuitive design to assist in building your wrangling workflows with a minimum of navigation. From the new Home page, you can quickly access common tasks, such as creating new datasets or flows, monitoring jobs, or revisiting recent work. 

Significant improvements have been delivered to the core transformation experience. In the Transformer page, you can now search across dozens of pre-populated transformations and functions, which can be modified in the familiar Transform Builder. Use the new Transformer toolbar to build pre-designed transformations from the menu interface.

New for Release 5.0, target matching allows you to import a representation of the final target schema, against which you can compare your work in the Transformer page. Easy-to-understand visual tags show you mismatches between your current recipe and the target you have imported. Click these tags to insert steps that align your columns with their counterparts in the target.

For multi-dataset operations, the new Auto Align feature in the Union tool improves matching capabilities between datasets, and various enhancements to the Join tool improve the experience.

Over 20 new Wrangle functions deliver new Excel-like capabilities to wrangling.

Enterprise operationalization:

Previously a beta feature, relational connectivity is now generally available, which broadens access to more diverse data. Out-of-the-box, the platform now supports more relational connections with others available through custom configuration. From the Run Jobs page, you can now publish directly to Amazon Redshift.

Build dynamic datasets with variables and parameters. Through parameters, you can apply rules to match multiple files through one platform object, a dataset with parameters. Rules can contain regular expressions, patterns, wildcards, dates, and variables, which can be overridden during runtime job execution through the UI or API. Variables can also be applied to custom SQL datasets.

Using these parameterized datasets allows schedules to pick up new data each execution run and enables users to pass variable values through the API or UI to select different data apply to the job.

Cloud focus:

Release 5.0 delivers broader and enhanced integration with Microsoft Azure. With a few clicks in the Azure Marketplace, you can deploy the platform into a new or existing HDI cluster. Your deployment can seamlessly integrate with either ADLS or WASB and can be configured to connect to Microsoft SQL Data Warehouse. As needed, integrate with Azure Active Directory for single-sign on simplicity.

What's New

Here's what's new in Release 5.0.

Install:

• Support for CDH 5.14.

  NOTE: Support for CDH 5.11 has been deprecated. See End of Life and Deprecated Features.

• Support for Spark 2.2. 

  NOTE: By default, the Designer Cloud Powered by Trifacta platform is configured to use Spark 2.1.0. Depending on your environment, you may be required to change the configuration to Spark 2.2, particularly if you are integrating with an EMR cluster. For more information, see Configure for Spark.

Azure:

• Integrate your Microsoft Azure deployment with ADLS and WASB. 
  • For more information, see Enable WASB Access.
    
  • For more information, see Enable ADLS Access.
• Support for Azure Single Sign On. See Configure SSO for Azure AD.
  • Integrate with domain-joined clusters using SSO. See Configure for HDInsight. 
• Support for read-only and read-write connections to Microsoft SQL DW. See Configure for Azure.

Admin:

• Through the application, you can now use Tricheck to check the server requirements and connectivity of the Alteryx node to the connected cluster. See Admin Settings Page.

Workspace: 

• New Home page and left nav bar allows for more streamlined access to recent flows and jobs, as well as learning resources. See Home Page.

  Tip: Try the tutorial available from the Home page. See Home Page.

• Manage your datasets and references from the new Library page. See Library Page.
• In the new Jobs page, you can more easily locate and review all jobs to which you have access. 
  • Administrators can view and cancel jobs launched by other users. 
  • See Jobs Page.

Workflow:

• Use parameterized rules in imported datasets to allow scheduled jobs and API executions to automatically pick up the right input data. See Overview of Parameterization.
• Assign a new Target to your recipes to provide guidance during wrangling. See Overview of Target Matching.

Transformer Page:

• Search across dozens of pre-defined transformations. Select one, and the Transform Builder is pre-populated based on the current context in the data grid or column browser. 
  • See Search Panel.
  • See Transform Builder.
• Targets assigned to a recipe appear as column header overlay to assist users in aligning their dataset to match the dataset schema to the target schema. See Data Grid Panel.
• Cancel in-progress sampling jobs. See Samples Panel. 
• New toolbar provides faster access to common transformations and operations. See Transformer Toolbar.
• Better intelligence for column matching during union operations. See Union Page.
• Numerous functional improvements to the Join page. See Join Page.

Run Job Page:

• Specify Redshift publishing actions as part of the job specification. See Run Job Page.

Connectivity:

• Delete unused connections through the application. See Connections Page.

Changes to System Behavior

Language:

• The aggregate transform has been removed from the platform. Instead, you can use the pivot transform to accomplish the same tasks. For more information, see Changes to the Language.

Key Bug Fixes

New Known Issues