Page tree


Contents:

   

Contents:


These release notes apply to the following product tiers:

  • Designer Cloud Powered by Trifacta Enterprise Edition
  • Designer Cloud Powered by Trifacta Professional Edition
  • Designer Cloud Powered by Trifacta Starter Edition
  • Designer Cloud Powered by Trifacta Premium

For more information, see Product Editions.

Tip: You can see your product tier in the Designer Cloud application . Select Resources menu > About Trifacta.

November 3, 2022

Release 9.6

What's New

Connectivity:

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

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

  • Adobe Analytics
  • Microsoft Dataverse
  • Google BigQuery JDBC (Private Preview)
  • Google Contacts
  • For more information, see Early Preview Connection Types.

Connectivity:

Support for connections to  Snowflake JDBC (Private Preview) instances hosted in Azure. For more information, see Snowflake JDBC Connections.

Connectivity:

Job history:

Changes to the layout of history pages for flow jobs, sample jobs, and plan runs for an improved user experience. 

Performance:

Improved performance when browsing folders or searching on S3.

NOTE: These improvements do not apply to integrations in which S3 is used as the backend storage, such as Snowflake or AWS Glue.


Documentation:

Over the next set of releases, a number of object types are being migrated from the Designer Cloud application to the underlying platform layer.

Tip: This migration of objects to the platform layer is being performed to enable broader access to these object types in the future. You can expect to see enhancements to these capabilities in the future.

These object types include the following:

  • Plans
  • Connections
  • Library:
    • Imported datasets
    • Reference datasets
    • Macros
  • Job history:
    • Flow jobs
    • Sample jobs
    • Plan runs
  • Schedules

Additionally, the following capabilities are moving to the platform level:

  • Admin
  • Preferences

Over the next few releases, documentation for these objects is migrating to the new Platform area. For more information, see Platform.

Changes in System Behavior

Flow collaborators can now edit custom SQL

Collaborators on a flow who have the flow editor permission can now edit any custom SQL used in importing datasets into the flow. 

Enable / Disable Data Grid

You can enable or disable the data grid in the Transformer page. When the data grid is disabled, you may not be able to edit some recipe steps. For steps that you can edit, select Preview to see the effects of the step on the data. When you select Preview, the data grid is re-enabled. 

NOTE: This feature can be enabled or disabled by an administrator.  

Deprecated

None.

Key Bug Fixes

TicketDescription
TD-74502HTTP response for HTTP task is undefined.
TD-74496Snowflake job fails with JSON datasource

New Known Issues

None.

September 26, 2022

Release 9.5

What's New

The name of this product edition has changed. Trifacta is now known as Designer Cloud Powered by Trifacta. Please read on for additional updates.

Check out the updated resources in the left nav bar and on the Home page! 

Parameterization:

Flow parameters now support a new type. Selector type parameters allow you to specify a list of permitted values for the parameter, which ensures data integrity throughout the transformation process. See Create Flow Parameter.

Snowflake  Running Environment:

  • Support for reading S3 files for execution in Snowflake .

    Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

    NOTE: S3 must be the base storage layer. Supported file formats are CSV, TXT, and JSON only.

  • Beginning in this release, sampling jobs can be executed in the Snowflake running environment.

  • When publishing to a Snowflake table, you can choose to write results using the merge option. When selected, you specify a primary key of fields and then decide how data is merged into the table. For more information, see Snowflake Table Settings.

Schema refresh supports Excel, PDF, and Google Sheets:

You can now refresh the schemas from Excel, PDF or Google Sheets datasources converted during ingest. Schema refresh enables you to identify changes to the columns in your dataset. 

Import flow:

During the import flow process in the Designer Cloud application , you can now remap connections and environment parameters in the flow to corresponding objects in the new project or workspace through drop-down menus. For more information, see Import Flow

Connectivity:

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

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.


Connectivity:

Connection to  Snowflake JDBC (Private Preview) databases in other environments.

NOTE: This connection type provides a direct, read-only connection to a specified Snowflake database and is not tied to S3 as a base storage layer. It can be enabled upon request. 

For more information, see Snowflake JDBC Connections.

Connectivity:

  • Support for OAuth 2.0 authentication for SharePoint .
  • Support for Azure AD authentication for SharePoint
  • For more information, see SharePoint Connections.

Billing:

Support for direct deposit payments from your US Bank account.

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

For more information, see Plans and Billing Page.

Asset transfer:

Transfer ownership of your individual assets to another user. See Transfer Asset Ownership.

NOTE: Administrators can transfer ownership of any user's asset to another user. Administrators can also transfer ownership of all of a user's assets. See User Details Page.

Job History:

Administrators can configure the default number of days of jobs to display in the Job History page. Default setting is 180  days.

Tip: Individual users can filter the list of jobs further, as needed.

For more information, see Workspace Settings Page,

Transformer page:

For improved performance, you can now edit your recipes without loading a sample in the data grid. 

NOTE: This feature must be enabled in your environment.

For more information, see Workspace Settings Page.

Changes in System Behavior

New pricing and packaging model

Release 9.5 introduces a new model for what is packaged in Enterprise, Professional, and Starter product editions and pricing for each edition. 

  • Existing customers on the old model may continue to use their current set of features until their subscription expires.
    • These customers cannot downgrade to another old-model product edition. 
  • When their subscription expires:
    • They can renew their subscription using a product edition under the new model. 
    • They cannot renew using any product edition under the old model.

      NOTE: The new model does not include the Premium product edition. Renewing customers on these product editions must migrate to a supported product edition. For more information, see Product Editions.  

  • The new pricing and packaging model introduces some changes to the features that are available for each product edition. Key changes:
    • API access has changed. See below.
    • Scheduling and orchestration using plans are now available across all paid editions.
    • There are now per-edition limits on automated job execution (scheduled jobs and API-based jobs).

For more information on differences between product editions in the new model, please visit Pricing and Packaging.

For additional questions, please contact  Alteryx Support.

Subscription management through Sales

Beginning in Release 9.5, changes to your product edition are managed through Sales. In the Designer Cloud application , click Contact Sales to reach out. For more information, see Start a Subscription.

API access moving to Enterprise only

Beginning in Release 9.5, all new or renewed subscriptions have access to public API endpoints on the Enterprise product edition only. For example, new or renewed subscriptions for the Professional product edition do not have access to API endpoints.

Existing customers that currently have access to API endpoints for non-Enterprise product editions can continue to use their available endpoints until their subscription expires. To use API endpoints after renewal, you must upgrade to the Enterprise product edition. 

For more information on differences between product editions in the new model, please visit Pricing and Packaging.

For additional questions, please contact  Alteryx Support.

Quickbooks Online

The QuickBooks Online connection type has been re-enabled. See Quickbooks Online Connections.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

August 2, 2022

Release 9.4

What's New

Configure range joins:

Specify ranges of key values in your joins.

NOTE: This feature may need to be enabled by an administrator. See Workspace Settings Page.

For more information, see  Configure Range Join .

Connectivity:

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

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Connectivity:

Support for creating connections to Denodo .

NOTE: This connection type is disabled by default. For more information on enabling this connection type, please contact, Alteryx Support.


Connectivity:

Support for creating OAuth 2.0 connections to single-tenant and multi-tenant Microsoft Dynamics 365 Sales

Schema refresh supports JSON:

You can now refresh the schemas from JSON datasource converted during ingest. Schema refresh enables you to identify changes to the columns in your dataset. 

Email notifications enhancements:

Tip: Each email notification includes a summary of Data Quality rules (rules that were run and the success/failures of those rules) and the profile details (valid, mismatched, missing) when a job is completed successfully. In the email, click View job to view the details of the job. See Email Notifications Page.

Changes in System Behavior

Quickbooks Online connections are disabled:

This feature has been disabled due to technical issues. It will be re-enabled when these issues are resolved in a future release.

Email notifications enabled by default:

NOTE: The settings for email notifications based on success or failure of jobs or plan runs have been enabled at the project or workspace level and at the flow level.

This change means that the user who executes a job and others who have access to the flow receive, by default, an email notification whenever a job executes for flows where email notification settings have never been modified. 

If needed, these new default settings can be modified.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

May 9, 2022

Release 9.3

What's New

Expandable left nav bar:

The new left navigation bar can be expanded to display full-text options for each menu item. Collapse it to reclaim the screen area. Available options remain consistent. See Home Page.

Billing:

Edit credit card and billing information and review billing history and invoices.

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

For more information, see Plans and Billing Page.


Connectivity:

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

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Connectivity:

Transformer page:

Improved performance of the Transformer page through asynchronous loading of initial samples.

Changes in System Behavior

Generate an initial sample:

When generating an initial sample from a set of files in a directory, the maximum number of files that can be read is now limited to 10.

  • Previously, the  Designer Cloud application  read files until either 10MB of data or all matching files had been scanned.
  • This change is to limit the number of files that must be read for various operations in the Transformer page. It only applies to generating the initial sample type. Other sampling types, such as random sample, can scan the full set of files.

As needed, an administrator can change this maximum limit.


Deprecated

Dataset Configuration (Experimental):

The Dataset Configuration experimental feature has been disabled from use in the product.

Key Bug Fixes

TicketDescription
TD-70522Cannot import converted files such as Excel, PDF, or JSON through SFTP connections.
TD-69652Creating parameterized version of dataset from External S3 connection fails with Access Denied 403

New Known Issues

None.

April 4, 2022

Release 9.2

What's New

Lock/unlock column data type:

You can now lock or unlock a column's data type. When the data type is locked, the  Designer Cloud application  no longer attempts to infer the column's data type when subsequent recipe steps are applied. 

Tip: You can unlock the individual 's column data type through column menu. To the left of the column name, you can click the icon and select Automatically update to change the column's data type. For more information, see Column Menus.

Tip: As an early step in your recipe, you can use the Advanced column selector in the Change column data type transformation to specify locking of the data types for all columns.

For more information, see Change Column Data Type.

Connectivity:

  • Support for SFTP connections.

    Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

    NOTE: This connection type is import only.

    For more information, see SFTP Connections.

Connectivity:

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

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Connectivity:

  • Simplified configuration to enable access to S3 for users within the Connections page. For more information, see AWS Account Page.

Changes in System Behavior

Set column data type transformation locks the column's type by default:

Starting in this release, the column data type is locked by default when you change the column data type.

NOTE: This change in behavior does not affect recipe steps that were defined before this release. Column data types continue to be re-inferred after those recipe steps. For those steps, you can edit them and mark them as locking the data type, if preferred.

If required, you can unlock the column's data type. For more information, see Change Column Data Type.

S3 enabled for new workspaces:

When you create a new workspace, S3 access is enabled by default. Prior to this release, S3 access had to be enabled for new workspaces. 

  • Workspaces created before Release 9.0 are not affected.
  • A workspace administrator can enable or disable S3 access. For more information, see Workspace Settings Page.

Performance:

The intelligent caching of recipe steps feature for performance improvements has been made available again. The issues that required removing it from the platform have been addressed.

NOTE: This feature is in Beta release.

This feature can be enabled by an administrator. For more information, see Workspace Settings Page.

Email notifications:

In a future release, the setting for email notifications based on job success will default to Default (Any Jobs) at the project or workspace level and at the flow level. This change means that the user who executes a job and others who have access to the flow receive, by default, an email notification whenever a job executes for flows where email notification settings have never been modified. As part of this change, each email will contain a richer set of information about the job that was executed. 

If needed, this new default setting can be modified:

Workspace administrators can change default value of the email notification settings. For more information, see Workspace Settings Page.

Individual users can override these settings for individual flows. For more information, see Manage Flow Notifications Dialog.

Deprecated

None.

Key Bug Fixes

TicketDescription
TD-69279Test Connection button fails a ValidationFailed error when editing a working connection configured with SSH tunneling.
TD-66185Flatten transformation cannot handle multi-character delimiters.

New Known Issues

None.

March 10, 2022

Release 9.1

What's New

Connectivity:

  • Enable connectivity between the  Designer Cloud application  and your cloud databases using SSH tunneling is generally available with this release.

    Tip: This feature is now generally available.

    NOTE: For this release, SSH tunneling can be enabled on the following connection types: Oracle Database , PostgreSQL , MySQL , and Microsoft SQL Server .

    For more information, see Configure SSH Tunnel Connectivity.

Connectivity:

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

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Job execution:

The  Designer Cloud application  can check for changes to your dataset's schemas before jobs are executed and optionally halt job execution to prevent data corruption. These options can be configured by a workspace administrator. For more information, see Workspace Settings Page.

Tip: Schema validation can be overridden for individual jobs. For more information, see Run Job Page.

For more information, see Overview of Schema Management.

Dataset configuration:

For an imported dataset, you can configure settings through a new interface, including column names and column data types to use in the  Designer Cloud application .

NOTE: This experimental feature is intended for demonstration purposes only. This feature may be modified or removed from the  Alteryx Analytics Cloud without warning in a future release. It should not be deployed in a production environment.

NOTE: This feature is part of a larger effort to improve how data is imported into the Designer Cloud application . This feature must be enabled by a workspace administrator.

Sample Job IDs:

When a sample is collected, a job ID is generated and displayed in the  Designer Cloud application .   These job IDs enable you to identify the sample jobs.

Import:

For long-loading Parquet datasets, you can monitor the ingest process as you continue your work.

NOTE: This feature is in Beta release.

For more information, see Flow View Page.

Changes in System Behavior

Snowflake execution:

Support for splitting columns on multiple delimiters during Snowflake pushdown execution. See Snowflake Running Environment.

Performance:

A recent release introduced improved performance through intelligent caching of recipe steps.

  • This feature was released as a Beta feature.
  • Due to some recently discovered issues, this feature has been disabled for the time being. It cannot be enabled by a workspace administrator at this time.

    NOTE: If this Beta feature had been enabled in your environment, you may experience a reduction in performance when moving between recipe steps in the Transformer page.

  • The feature will be re-enabled in a future release.
Connectivity:

  • The  Google Analytics  connection type now supports the UniversalAnalytics schema.

    NOTE: Previously, this schema was called  GoogleAnalytics  by the driver vendor. You may need to update your custom SQL queries to reference this new schema name.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-69279

Test Connection button fails a ValidationFailed error when editing a working connection configured with SSH tunneling.

Workaround: Select/deselect the Enable SSH Tunneling checkbox, and then click Test Connection.

January 31, 2022

Release 9.0

What's New

Snowflake Running Environment:

For flows whose datastources and outputs are hosted in Snowflake, you can now push down execution of transformation jobs to Snowflake for much faster execution. For more information, see Snowflake Running Environment.

Dataset Schema Refresh:

You can now refresh your imported datasets with the current schema information from the source file or table. Schema refresh enables you to capture any changes to the columns in your dataset.

Connectivity:

Build connections to accessible REST API endpoints.

This feature is disabled by default. For more information about enabling REST API connectivity in your environment, please contact Alteryx Support.

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

For more information, see REST API Connections.

Connectivity:

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

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Changes in System Behavior

New configuration task for S3 connections

When you create a new workspace, the process by which you connect your workspace to S3 has improved.

Tip: Future releases will include additional improvements in connecting to AWS and S3 resources.

For more information, see Changes to Configuration.

Deprecated

None.

Key Bug Fixes

TicketDescription
TD-68162

Flow parameters cannot be displayed or edited in the Transformer page and cannot embedded in recipe steps.

New Known Issues

None.

January 10, 2022

Release 8.11

What's New

Connectivity:

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

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Performance:

  • Improved performance during design time through intelligent caching of recipe steps. 
    NOTE: This feature is in Beta release.

  • Improvements in job execution performance, due to skipping some output validation steps for file-based outputs.

    NOTE: When scheduled or API jobs are executed, no validations are performed of any writesettings objects. Issues with these objects may cause failures during transformation or publishing stages of job execution.

Changes in System Behavior

Sample sizes can be increased up to 40MB

Feature Availability: This feature may not be available in all product editions. For more information on available features, see Compare Editions.

Prior to this release, the size of a sample was capped at 10MB. This size represented:

  • the actual size of the sample object stored in the base storage layer
  • the default maximum size of the sample displayed in the Designer Cloud application . This sample size can be reduced from 10MB, if needed.

Beginning in this release:

  • The actual size of the stored sample has increased to 40MB.

    NOTE: On backend storage, sample sizes are now four times larger than in previous releases. For datasources that require decompression or conversion, actual storage sizes may exceed this 40 MB limit.

  • The size of the sample displayed for a recipe can be configured to be up to 40MB in size by individual users.

For more information, see Change Recipe Sample Size.

Data type mismatches can now be written out in CSV format

Beginning in this release, for CSV outputs mismatched values are written as regular values by default. In prior releases, mismatched values were written as null values in CSV outputs.

See Improvements to the Type System.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-68162

Flow parameters cannot be displayed or edited in the Transformer page and cannot embedded in recipe steps.

Workaround: To edit your flow parameters, select Parameters from the Flow View context menu.

NOTE: There is no current workaround for embedding in recipe steps. While your existing parameters should continue to work at execution time, avoid changing names of your flow parameters or editing recipe steps in which they are referenced. New flow parameters cannot be used in recipes at this time.


Earlier Releases

For more information on earlier releases, see Earlier Releases of Designer Cloud Powered by Trifacta.

This page has no comments.