February 26, 2021

Release 8.1

What's New

Connectivity:


API:

Customize connection types (connectors) to ensure consistency across all connections of the same type and to meet your enterprise requirements. For more information, see Changes to the APIs.


Job results:

Results of data quality checks are now part of the visual profile PDF available with your job results. In the PDF, you can download the data quality results over the entire dataset.

Specify column headers during import

You can specify the column headers for your dataset during import. For more information, see Import Data Page.

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-56170The Test Connection button for some relational connection types does not perform a test authentication of user credentials.
TD-54440

Header sizes at intermediate nodes for JDBC queries cannot be larger than 16K.

Previously, the column names for JDBC data sources were passed as part of a header in a GET request. For very wide datasets, these GET requests often exceeded 16K in size, which represented a security risk.

New Known Issues

None.

January 26, 2021

Release 8.0

What's New

Connectivity:

Import:

Recipe development:

Metric-based data quality rules:

Update Macros:

Job execution:

APIs:

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-57180

AWS jobs run on Photon to publish to HYPER format fail during file conversion or writing.

New Known Issues

TicketDescription
TD-56170

The Test Connection button for some relational connection types does not perform a test authentication of user credentials.

Workaround: Append the following to your Connect String Options:

;ConnectOnOpen=true

This option forces the connection to validate user credentials as part of the connection. There may be a performance penalty when this option is used.

December 21, 2020

Release 7.10

What's New

Tip: Check out the new in-app tours, which walk you through the steps of wrangling your datasets into clean, actionable data.

Import:

Plan View:

For more information, see Export Plan.

For more information, see Import Plan.


Photon:

Introducing , an in-memory running environment for running jobs. Embedded in the , is fast and best-suited for small- to medium-sized jobs.

Sampling:

Sharing:

Authentication:

Connectivity:


API:

Changes in System Behavior

New public bucket for product assets

In prior releases, the product referenced the following S3 bucket, which contained demo assets:

trifacta-public-datasets

Beginning in this release, please enable access through your IAM role to the following buckets:

trifacta-public-datasets
3fac-data-public
aws-saas-datasets


NOTE: These buckets are available for read access on the public Internet. However, if you are using IAM roles to enable access to AWS resources, you may need to review your policies to change the reference to the new bucket. If the bucket is not updated in the policy, users who are assigned the IAM role may not be able to access these product assets.



For more information, see Getting Started with Trifacta Wrangler Pro.

Key Bug Fixes

TicketDescription
TD-54742Access to S3 is disabled after upgrade.
TD-53527When importing a dataset via API that is sourced from a BZIP file stored on S3, the columns may not be properly split when the platform is permitted to detect the structure.

New Known Issues

TicketDescription
TD-57180

AWS jobs run on Photon to publish to HYPER format fail during file conversion or writing.

Workaround: Run the job on the Spark running environment instead.

TD-56830

Receive malformed_query: enter a filter criterion when importing table from Salesforce.

NOTE: Some Salesforce tables require mandatory filters when they are queried. Mandatory filters are not currently supported for Salesforce connections.


November 18, 2020

Release 7.9

What's New

Plan View:

Transform Builder:

Changes in System Behavior

Flow optimizations re-enabled:

For , flow execution optimizations were disabled in an earlier release due to to technical issues. These optimizations are designed to improve query performance during job and sampling execution. 

Beginning in this release, flow optimizations are re-enabled for new flows. When you create a new flow now, flow optimizations are automatically enabled for it.

Better license management:

In prior releases, the  locked out all users if the number of active users exceeded the number permitted by the license. This situation could occur if users were being added via API, for example. 

Beginning in this release, the  does not block access when the number of licensed users is exceeded. 

NOTE: If you see the notification banner about license key violations, please adjust your users until the banner is removed. If you need to adjust the number of users associated with your license key, please contact .

Key Bug Fixes

TicketDescription
TD-55125Cannot copy flow. However, export and import of the flow enables copying.
TD-53475Missing associated artifact error when importing a flow.

New Known Issues

None.

October 19, 2020

Release 7.8

What's New

Plans:

Flow View:

Language:

Data quality rules:

Improvements to suggestions for data quality rules:

Connectivity:

Changes in System Behavior

Enhanced  Flow and Flow View menu options:

The context menu options for Flow View and Flow have been renamed and reorganized for a better user experience.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-54030

When creating custom datasets from Snowflake, columns containing time zone data are rendered as null values in visual profiles, and publishing back to Snowflake fails.

Workaround: In your SELECT statement applied to a Snowflake database, references to time zone-based data must be wrapped in a function to convert it to UTC time zone. For more information, see Create Dataset with SQL.

October 2, 2020

Release 7.7

What's New

None.

Changes in System Behavior

Disabled Optimizer Service

In the September release, the Optimizer service was introduced, which enabled users to apply advanced physical and logical optimizations for flow and job executions. Recently, an issue was discovered, which has caused us to disable the service temporarily.

Key Bug Fixes

None.

New Known Issues

None.

September 21, 2020

Release 7.7

What's New

Manage workspace users:

Workspace administrators can:

Flow View:

Changes in System Behavior

Deprecated Parameter History Panel Feature 

As a part of collaborative suggestions enhancement, the support for Parameter History panel is deprecated from the software. For more information on collaborative suggestions feature, see Overview of Predictive Transformation.

Classic Flow View no longer available

In Release 7.6, an improved version of Flow View was released. At the time of release, users could switch back to using the classic version. 

Beginning in this release, the classic version of Flow View is no longer available. 

Tip: The objects in your flows that were created in classic Flow View may be misaligned in the new version of Flow View. You can use auto-arrange to re-align your flow objects.

For more information, see Flow View Page.

Key Bug Fixes

TicketDescription
TD-53318
Cannot publish results to relational targets when flow name or output filename or table name contains a hyphen (e.g. my - filename.csv).

New Known Issues

None.

August 19, 2020

Release 7.6

What's New

Flow View:

Plan View:

Data quality rules:

Job Execution:

Documentation:

Changes in System Behavior

IP addresses to whitelist have changed:

Please verify that the following range of IP addresses have been whitelisted for the  for access to relational datasources in your enterprise:

35.199.3.51/32
35.245.35.240/28

For more information, see Getting Started with Trifacta Wrangler Pro

Key Fixes

TicketDescription
TD-52221API: Unable to update awsConfig objects in per-user or per-workspace modes.
TD-48915Inserting special characters in an output filename results in a validation error in the the application and job failures.


New Known Issues

None.

July 20, 2020

Release 7.5

What's New

New Flow View is now generally available:

Import:

Transformer Page:

Plans:


Authorization:

Language:

Changes in System Behavior

Schema information is retained:

Enhanced PII masking:

IP addresses to whitelist have changed:

Please verify that the following range of IP addresses have been whitelisted for the  for access to relational datasources in your enterprise:

35.199.3.51/32
35.245.35.240/28

For more information, see Getting Started with Trifacta Wrangler Pro.

Key Fixes

None.

New Known Issues

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

June 22, 2020

Release 7.4

What's New

Language:

Changes in System Behavior

NOTE: Beginning in this release, the set of IP addresses for the has been changed. If you have connected to any relational sources from the product, please update all of your database services to which connects to whitelist the new IP addresses.

34.86.43.62/32
35.230.178.129/32
35.245.163.90/32
34.86.140.202/32

For more information, see Getting Started with Trifacta Wrangler Pro.

API:

Key Bug Fixes

None.

New Known Issues

None.

June 4, 2020

Release 7.3

What's New

Data quality rules:

Language:

New rolling window date functions. 

Function NameDescription
ROLLINGMAXDATE Function

ROLLINGMINDATE Function

ROLLINGMODEDATE Function

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-49559Cannot select and apply custom data types through column Type menu.
TD-47473Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted.
TD-34840Platform fails to provide suggestions for transformations when selecting keys from an object with many of them.


New Known Issues

None.

May 18, 2020

Release 7.2

What's New

Introducing new Flow View:

The Flow View page has been redesigned to improve the user experience and overall productivity. 

Publishing:

Connectivity:

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

Language:

Function NameDescription
KTHLARGESTDATE Function

KTHLARGESTUNIQUEDATE Function

KTHLARGESTDATEIF Function

KTHLARGESTUNIQUEDATEIF Function

MINDATEIF Function

MAXDATEIF Function

MODEDATEIF Function


Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-47473Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted.
TD-34840Platform fails to provide suggestions for transformations when selecting keys from an object with many of them.

New Known Issues

None.

April 15, 2020

Release 7.1

What's New

API Documentation:

Import:

Flow View:

Transformation:

Language:

Some functions now accept Datetime values: Beginning in this release, the following functions now accept Datetime values as inputs. When a Datetime value is input, output values are in unixtime format.

Tip: You can wrap the unixtime format output in the DATEFORMAT function to render the results in the preferred Datetime format. See DATEFORMAT Function.

Date calculation functions:

Function NameDescription
MINDATE Function

MAXDATE Function

MODEDATE Function

Work day functions:

Function NameDescription
NETWORKDAYS Function

NETWORKDAYSINTL Function

WORKDAY Function

WORKDAYINTL Function

Time zone conversion functions:

Function NameDescription
CONVERTFROMUTC Function

CONVERTTOUTC Function

CONVERTTIMEZONE Function

Changes in System Behavior

Authorization:

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-47473

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

Workaround: Remove the space in the filename and upload again.

March 17, 2020

Release 7.0

Beginning in this release, you can access publicly available APIs of the  to run and monitor jobs. Numerous bug fixes and performance improvements. 

What's New

APIs:

APIs are now publicly available! You can now use a library of publicly available REST APIs to automate key aspects of object creation and job execution. For more information, see API Reference.

Import:

Transformer Page:

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

February 19, 2020

Release 6.11

This release introduces in-app chat and content suggestions within the application. Give it a try!

What's New

In-app chat: 

Have a question about the product? Use the new in-app chat feature to explore content or ask a question to our support staff. If you need assistance, please reach out!

Language:

Changes in System Behavior

None.

Key Fixes

None.

New Known Issues

None.

January 23, 2020

Release 6.10

This release delivers enhancements to job monitoring, visual profiles that are downloadable in PDF format, and a useful feature to kickoff any support inquiries.

What's New

Troubleshooting:

Flow View:

Job Details:

Documentation:

Changes in System Behavior

Sharing:

Key Bug Fixes

None.

New Known Issues

None.

December 17, 2019

Release 6.9

This release introduces new statistical functions, including co-efficient and covariance calculations for enhanced analysis. A redesigned User menu facilitates easier management of user and workspace settings.

What's New

Transformer Page:

Workspace:

Language:

Changes in System Behavior

Language:

All MODE functions return the lowest value in a set of values if there is a tie in the evaluation.

In prior releases, these functions returned a null value in the event of a tie for most common value among the evaluated ones.

Key Bug Fixes

None.

New Known Issues

None.

November 13, 2019

Release 6.8

This release features enhancements to the user experience in the workspace, in the form of keyboard shortcuts and user-specific locale settings. You can also receive email notifications based on the outcome of your job executions. Flows and macros can be exported and imported into different editions and releases of the product. Read on!

What's New

Workspace:

Transformer Page:

Job execution:

Language:

This release introduces the sampling method of calculating statistical functions. The following are now available:

Function NameDescription
STDEVSAMP Function

VARSAMP Function

STDEVSAMPIF Function

VARSAMPIF Function

ROLLINGSTDEVSAMP Function

ROLLINGVARSAMP Function

Changes in System Behavior

Import/Export:

Key Bug Fixes

TicketDescription
TD-44548RANGE function returns null values if more than 1000 values in output.

New Known Issues

None.

October 9, 2019

Release 6.7

This release introduces two key management features. You can now export and import macros into other instances of , which enables broader adoption of your data wrangling practices. You can also create webhook notifications to be sent to a third-party application based on the success or failure of your job. 

What's New

Browser:

Project Management:

Operationalization:

Connectivity:

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

September 11, 2019

Release 6.6

This release introduces new functions to the language and improvements in search for transformations.

What's New

Transformer Page:

Language:

Function NameDescription
SINH Function

COSH Function

TANH Function

ASINH Function

ACOSH Function

ATANH Function


Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-42080Cannot run flow or deployment that contains more than 10 recipe jobs


New Known Issues

None.

August 14, 2019

Release 6.5

This release introduces new functions and fixes a number off issues.

What's New

Import:

Language:

Function NameDescription
SIN Function

COS Function

TAN Function

Cotangent FunctionSee TAN Function.
Secant FunctionSee COS Function.
Cosecant FunctionSee SIN Function.
ASIN Function

ACOS Function

ATAN Function

Arccotangent FunctionSee ATAN Function.
Arcsecant FunctionSee ACOS Function.
Arccosecant FunctionSee ASIN Function.

Connectivity:

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-40348

When loading a recipe in an imported flow that references an imported Excel dataset, Transformer page displays Input validation failed: (Cannot read property 'filter' of undefined) error, and the screen is blank.

New Known Issues

None.

July 18, 2019

Release 6.4

This release introduces macros, which enable reuse and parameterization of common sequences of recipe steps.

What's New

Reuse:

Connectivity:

Transformation:

Job Execution:

Wrangle:

Changes in System Behavior

NOTE: The desktop version of Trifacta Wrangler will cease operations on August 31, 2019. If you are still using the product at that time, your data will be lost. Please transition to using the free Cloud version of . Automated migration is not available. To register for a free account, please visit https://cloud.trifacta.com.

NOTE: The Chat with us feature is no longer available. For customers, this feature had to be enabled in the product. For more information, see .


Documentation:

Key Bug Fixes

TicketDescription
TD-40424

UTF-32BE and UTF-32LE are available as supported file encoding options. They do not work.

NOTE: Although these options are available in the application, they have never been supported in the underlying platform. They have been removed from the interface.

TD-39513Import of folder of Excel files as parameterized dataset only imports the first file, and sampling may fail. 
TD-39092

$filepath and $sourcerownumber references are not supported for Parquet file inputs.

For more information, see Source Metadata References.

TD-31354When creating Tableau Server connections, the Test Connection button is missing. See Create Tableau Server Connections.


New Known Issues

None.

June 17, 2019

Release 6.3

This release features a brand-new way to develop transformations via example. Map source column values to your entered values, and the platform can infer similar pattern-based matches in your column of data. Also, multi-step operations are now available in the Recipe panel. For administrators: you can now review the list of all available schedules in the workspace.  

What's New

Transform:

Connectivity:

Admin:

Language:

Changes to System Behavior

NOTE: The Chat with us feature is no longer available. For more information, see .

Key Bug Fixes

TicketDescription
TD-40243API access tokens don't work with native SAML SSO authentication

May 30, 2019

This release fixes a few bugs. 

What's New

None.

Changes in System Behavior

None.

Key Bug Fixes

TicketDescription
TD-40965

JSON output escapes quotes in Array or Object outputs.

NOTE: By default, all columns for schematized outputs are typecast to their annotated types. This feature can be disabled as needed by a workspace administrator. For more information, see Schematized output in Workspace Settings Page.

New Known Issues

None.

May 15, 2019

Release 6.2

This release includes new functions and a new method for locating datasets and recipes to join in.

What's New

Transformer Page:

Language:

Connectivity:

Changes to System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

April 10, 2019

Release 6.1

This release greatly expands the set of supported JDBC-based connections. Also, it introduces new selection-specific operations, including replacement of individual cell values, as well as bug fixes.

What's New

Connectivity:

Wrangling:

Changes to System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

March 4, 2019

Release 6.0

This release of  introduces key features around job monitoring and column management, including multi-select and copy and paste of columns and column values. A new Job Details page captures more detailed information about job execution and enables more detailed monitoring of in-progress jobs. 

What's New

NOTE: The PNaCl client for Google Chrome has been replaced by the WebAssembly client. This new client is now the default in use by the platform and is deployed to all clients through the browser. Please verify that all users in your environment are on Google Chrome 68+. For more information, see Desktop Requirements.

Wrangling:

Connectivity:

NOTE: If you are connecting to any relational source of data, such as Redshift or Oracle, you must add the to your whitelist for those resources. For more information, see see Getting Started with Trifacta Wrangler Pro.


Monitoring:

:

Changes to System Behavior

None.

Key Bug Fixes

None.

New Known Issues

TicketDescription
TD-39299

In Create Connection window, all connection types are listed as Import and Publish.

Workaround: In this release, only Redshift connections are Import and Publish.

TD-38869

Upload of Parquet files does not support nested values, which appear as null values in the Transformer page.

Workaround: Unnest the values before importing into the platform.

February 5, 2019

What's New

NOTE: The PNaCl client for Google Chrome has been replaced by the WebAssembly client component. This new client is now the default in use by the platform and is deployed to all clients through the browser. For more information, see Desktop Requirements.

 

Wrangling:

Workspace:

Changes to System Behavior

None.

Errata

In prior releases, the product and documentation stated that the platform implemented a version of regular expressions based on Javascript syntax. This is incorrect.

The  implements a version of regular expressions based off of RE2 and PCRE regular expressions.

NOTE: This is not a change in behavior. Only the documentation has been changed.

Key Fixes

None.

New Known Issues

TicketDescription
TD-37683

Send a copy does not create independent sets of recipes and datasets in new flow. If imported datasets are removed in the source flow, they disappear from the sent version.

Workaround: Create new versions of the imported datasets in the sent flow.

January 10, 2019

What's New

Language:

Jobs:

Changes to System Behavior

None.

Key Fixes

None.

New Known Issues

None.

December 4, 2018

This is the initial release of .