Page tree

Trifacta SaaS



Contents:

   

Contents:


These release notes apply to the following product tiers:

  • Trifacta Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Starter Edition
  • Trifacta Premium

For more information, see Product Editions.

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

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.

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.


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, 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.

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 Trifacta 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 Trifacta 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.

    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.

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 Trifacta 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.

Job execution:


The Trifacta 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 Trifacta application.

NOTE: This experimental feature is intended for demonstration purposes only. This feature may be modified or removed from the Trifacta platform 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 Trifacta 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 Trifacta 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, 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.

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.

Refer and Earn:

Beginning in this release, for every new sign-up you refer, you get a reward of your choice. For more information, see  Referrals Page .

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.

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 Trifacta 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.


November 22, 2021

Release 8.10

What's New

Connectivity:

  • Enable connectivity between the Trifacta application and your cloud databases using SSH tunneling.

    NOTE: SSH tunneling is enabled on a per-connection basis. 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.

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

    Feature Availability: This feature may not be available in all product editions.

Session Management:

You can view the current and recent sessions for your account in the Trifacta application. As needed, you can revoke any unfamiliar devices or sessions. For more information, see Sessions Page.

Download vCPU usage:

You can download a detailed report of your vCPU usage in CSV format.

For more information, see Workspace Usage Page.

Changes in System Behavior

Ingestion:

Maximum permitted record length has been increased from 1 MB to 20 MB. For more information, see Working with JSON v2.

Publishing:

Improvements to publishing of Trifacta Date values to Snowflake. For more information, see Improvements to the Type System.

Split transformation:

When splitting a column based on positions, the positions no longer need to be listed in numeric order. See Changes to the Language.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-66185

Flatten transformation cannot handle multi-character delimiters.

Workaround: When a column of arrays is flattened using the Trifacta Photon running environment, multi-character String delimiters are not supported. As a workaround, you can create a regular expression delimiter, as in the following, which uses either left bracket or right bracket as the delimiter:

/[|]/

October 26, 2021

Release 8.9

What's New

Plans:

  • Create plan tasks to delete files and folders from file-based backend storage.

    Feature Availability: This feature may not be available in all product editions.

    For more information, see Create Delete Task.

  • You can now reference output metadata from within your plans. See Plan Metadata References.

Collaboration:

  • You can view the list of collaborators and their corresponding avatars on shareable objects, such as Flows, Plans, and Connections pages.

Connectivity:

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

    Feature Availability: This feature may not be available in all product editions.

    • Google Ads

Sampling:

  • Adjust the size of samples loaded in the browser for your current recipe to improve performance and address low-memory conditions. See  Change Recipe Sample Size.

Changes in System Behavior

None.

Deprecated

None.

Key Bug Fixes

TicketDescription
TD-65502Datasets from parameters are improperly being permitted to be referenced in recipes and returns an error during job execution.

New Known Issues

None.

September 27, 2021

Release 8.8

What's New

Subscribe and upgrade plans via credit card:

Through the Admin console, you can now view and manage your plan, including change the plan, billing information, and the number of licensed users. You can also upgrade, downgrade, or cancel your subscription. For more information, see Plans and Billing Page.

vCPU consumption:

Administrators can now view the total workspace consumption in vCPU hours. For more information, see Workspace Usage Page.

Flow View:

  • Updated context panel for output objects. For more information, see View for Outputs.

Changes in System Behavior

Import:

Improvements have been made in how double quotes are handled in CSV files during import to align  Trifacta with other systems that support CSV import. 

  • Example values in source CSV file:

    """My product""",In stock,"16,000",0.05

    Note that the value 16,000 must be double-quoted, since the value contains a comma, which is the field delimiter.

  • Previously, this value appeared in the Transformer page in columns as the following:

    c1c2c3c4
    """My product"""
    In stock
    "16,000"
    0.05
  • As of this version, the Trifacta application handles the values in a better manner when displaying them in the Transformer page:

    c1c2c3c4
    "My product"
    In stock
    16,000
    0.05
    • c1: Escaped values (tripe double-quotes) in the source no longer render in the application as triple double-quotes and are represented as quoted values.

    • c3: Note that the double quotes in c3 have been stripped. Leading and trailing quotes are trimmed if the quotes are balanced within a cell.

      NOTE: This change in behavior applies only to newly created imported datasets sourced from a CSV file. Existing imported datasets should not be affected. However, if a newly imported dataset is transformed by a previously existing recipe that compensated for the extra quotes in the Transformer page, the effects on output data could be unpredictable. These recipes and their steps should be reviewed.

      This change does apply to any newly imported dataset sourced from CSV and may cause the data to change. For example, if you export an older flow and import into a new workspace or project, this change in parsing behavior applies to the datasets that are newly created in the new environment. Recipes may require review upon import.

  • When results are generated in CSV, output files should continue to reflect the formatting of the source data before import. See above.

    Tip: You can also choose the Include quotes option when creating a CSV output.

    • When profiling is enabled, values that appear in CSV as "" are now marked as missing.

API:

  • To prevent overloading mission-critical API endpoints, rate limiting on a select set of API endpoints has been implemented in the Trifacta platform. For more information, see Changes to the APIs.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-63974

In imported datasets sourced from CSV files, double quotes that are escaped with a backslash ( \"backslash-escaped value\") can cause remainder of row to be compressed into a single cell.


September 15, 2021

Release 8.7 - push 2

What's New

Templates:

Feature Availability: This feature may not be available in all product editions.

From the Flows page, you can now access pre-configured templates directly from the templates gallery.

Tip: Click Templates in the Flows page. Select the template, and the template is opened in Flow View for you.

Changes in System Behavior

None.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

None.

September 1, 2021

Release 8.7

What's New

Browsers:

  • Update to supported browsers:
    • Mozilla Firefox is generally supported.
    • Microsoft Edge is now supported.

      NOTE: This feature is in Beta release.
    • New versions of supported browsers are now supported.
    • For more information, see Browser Requirements.

Plans:

  • Create plan tasks to deliver messages to a specified Slack channel.

    Feature Availability: This feature may not be available in all product editions.

    For more information, see Create Slack Task.

Connectivity:

  • Access to S3 is now managed using the native AWS SDK.

Recipe panel:

Changes in System Behavior

None.

Deprecated

API:

  • Deprecated API endpoint to transfer assets between users has been removed from the platform. This endpoint was previously replaced by an improved method of transfer.
  • Some connection-related endpoints have been deprecated. These endpoints have little value for public use.
  • For more information, see Changes to the APIs.

Key Bug Fixes

TicketDescription
TD-63564

Schedules created by a flow collaborator with editor access stop working if the collaborator is removed from the flow.

Collaborators with viewer access cannot create schedules.

New Known Issues

TicketDescription
TD-63517

Unpivoting a String column preserves null values in Spark but converts them to empty strings in Photon. Running jobs on the different running environments generates different results.

Workaround:  After the unpivot step, you can add an Edit with formula step. Set the columns to all of the columns in the unpivot and add the following formula, which converts all missing values to null values:

if(ismissing($col),NULL(),$col)

August 2, 2021

Release 8.6

What's New

NOTE: Trifacta Standard product edition is no longer available. All customers of this product edition have been moved to other product editions.

Rename Workspace

Feature Availability: This feature may not be available in all product editions.


Collaboration:
Workspace administrators can now edit the workspace name. Select Admin console > Workspace settings.
For more information, see Workspace Settings Page.

Connectivity:

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

    Feature Availability: This feature may not be available in all product editions.

Performance:

  • Conversion jobs are now processed asynchronously. 

  • Better management of file locking and concurrency during job execution. 

Better Handling of JSON files

The Trifacta application now supports the regularly formatted JSON files during import. You can now import flat JSON records contained in a single array object. With this, each array is treated as a single line and imported as a new row. For more information, see Working with JSON v2.

Changes in System Behavior 

None.

Deprecated

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-63564

Schedules created by a flow collaborator with editor access stop working if the collaborator is removed from the flow.

Tip: Flow owners can delete the schedule and create a new one. When this issue is fixed, the original schedule will continue to be executed under the flow owner's account.

Collaborators with viewer access cannot create schedules.

This page has no comments.