Release 8.1
Connectivity:
Introducing Early Preview connections. In each release of cloud-based product editions, new connection types may be made available in read-only mode for users to begin exploring their datasets stored in the connected datastores.
NOTE: Early Preview connection types are read-only and are subject to change before they may be made generally available. |
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.
You can specify the column headers for your dataset during import. For more information, see Import Data Page.
None.
| Ticket | Description |
|---|---|
| TD-56170 | The 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. |
None.
Release 8.0
Connectivity:
Support for using OAuth2 authentication for Salesforce connections.
Recipe development:
Metric-based data quality rules:
Update Macros:
Job execution:
None.
| Ticket | Description |
|---|---|
| TD-57180 | AWS jobs run on Photon to publish to HYPER format fail during file conversion or writing. |
| Ticket | Description | ||
|---|---|---|---|
| TD-56170 | The Test Connection button for some relational connection types does not perform a test authentication of user credentials.
|
Release 7.10
Tip: Check out the new in-app tours, which walk you through the steps of wrangling your datasets into clean, actionable data. |
Import:
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:
Define permissions on individual objects when they are shared.
NOTE: Fine-grained sharing permissions apply to flows and connections only. |
For more information, see Changes to User Management.
Authentication:
Connectivity:
Improved Salesforce connection type.
For more information, see Create Salesforce Connections.
API:
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.
| Ticket | Description |
|---|---|
| TD-54742 | Access to S3 is disabled after upgrade. |
| TD-53527 | When 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. |
| Ticket | Description | |
|---|---|---|
| TD-57180 | AWS jobs run on Photon to publish to HYPER format fail during file conversion or writing.
| |
| TD-56830 | Receive
|
Release 7.9
Plan View:
Transform Builder:
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.
For flows created in a previous release, flow optimizations are disabled by default. You can choose to enable optimizations for an individual flow through Flow View page.
NOTE: If a flow execution fails multiple consecutive times, flow optimizations are automatically skipped. If job execution then succeeds, optimizations are automatically disabled for the flow. |
For more information, see Flow Optimization Settings Dialog.
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 |
| Ticket | Description |
|---|---|
| TD-55125 | Cannot copy flow. However, export and import of the flow enables copying. |
| TD-53475 | Missing associated artifact error when importing a flow. |
None.
Release 7.8
Plans:
Create HTTP tasks for your plans, which can be configured to issue a request to an API endpoint over HTTP.
Language:
Improvements to suggestions for data quality rules:
Connectivity:
IAM support for Redshift connections.
NOTE: To enable use of an existing IAM role for Redshift, additional permissions must be added. For more information, see Required AWS Account Permissions. |
For more information, see Create Redshift Connections.
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.
None.
| Ticket | Description | |
|---|---|---|
| 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.
|
Release 7.7
None.
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.
None.
None.
Release 7.7
Manage workspace users:
Workspace administrators can:
Flow View:
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.
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.
| Ticket | Description |
|---|---|
| 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). |
None.
Release 7.6
Flow View:
Plan View:
Data quality rules:
Job Execution:
Support for job cancellation. See Jobs Page.
Documentation:
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.
| Ticket | Description |
|---|---|
| TD-52221 | API: Unable to update awsConfig objects in per-user or per-workspace modes. |
| TD-48915 | Inserting special characters in an output filename results in a validation error in the the application and job failures. |
None.
Release 7.5
New Flow View is now generally available:
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.
Import:
For long-loading relational datasets, you can monitor the ingest process through Flow View as you continue your work.
For more information, see Flow View Page.
Improved performance when browsing databases for tables to import.
Tip: Performance improvements are due to limiting the volume of table metadata that is imported when paging through available tables. This metadata can be retrieved when you hover over a table in the database browser. |
For more information, see Database Browser.
Logical and physical optimizations when reading from relational sources during job execution, which includes column pruning push-down among other enhancements.
NOTE: This feature may need to be enabled in your workspace. See Workspace Settings Page. |
This feature applies to the following relational connections in this release:
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.
This feature must be enabled for individual users or across the workspace. See Workspace Settings Page.
When the feature is enabled, individual users can choose to not share their transformation data. See User Profile Page.
For more information, see Overview of Predictive Transformation.
Plans:
Authorization:
Language:
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:
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.
None.
| Ticket | Description |
|---|---|
| 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. |
Release 7.4
Language:
NOTE: Beginning in this release, the set of IP addresses for the
For more information, see Getting Started with Trifacta Wrangler Pro. |
API:
None.
None.
Release 7.3
Data quality rules:
Language:
New rolling window date functions.
| Function Name | Description |
|---|---|
| ROLLINGMAXDATE Function | |
| ROLLINGMINDATE Function | |
| ROLLINGMODEDATE Function |
None.
| Ticket | Description |
|---|---|
| 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. |
None.
Release 7.2
Introducing new Flow View:
The Flow View page has been redesigned to improve the user experience and overall productivity.
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. |
Publishing:
Support for generating results and publishing to Tableau Hyper format.
NOTE: Tableau TDE format will be deprecated in a future release. Please switch to using Tableau Hyper format. |
If you have upgraded to Tableau Server 10.5 or later, you may have a mix of TDE and Hyper files stored on the server. You can automatically upgrade the TDE files to Hyper, if needed. For more information, see https://help.tableau.com/current/online/en-us/extracting_upgrade.htm.
Connectivity:
Improved performance for Oracle and SQL Server connections. These performance improvements will be applied to other relational connections in future releases.
Language:
| Function Name | Description |
|---|---|
| KTHLARGESTDATE Function | |
| KTHLARGESTUNIQUEDATE Function | |
| KTHLARGESTDATEIF Function | |
| KTHLARGESTUNIQUEDATEIF Function | |
| MINDATEIF Function | |
| MAXDATEIF Function | |
| MODEDATEIF Function |
None.
| Ticket | Description |
|---|---|
| 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. |
None.
Release 7.1
API Documentation:
API reference documentation is now available directly through the application. This release includes more supported endpoints and documented options. To access, select Help menu > API Documentation.
Workflow documentation is available with the product documentation. For more information, see API Reference.
Import:
Flow View:
Create flow parameters that you can reference in the recipes of your flow. Flow parameters can be string literals, , or regular expression patterns.
NOTE: For this release, flow parameters can be applied into your recipes only. |
As needed, you can apply overrides to the parameters in your flow or to downstream flows.
NOTE: Flow parameters do not apply to datasets or output objects, which have their own parameters. However, if you specify an override at the flow level, any parameters within the flow that use the same name receive the override value, including output object parameters and datasets with parameters. |
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 Name | Description |
|---|---|
| MINDATE Function | |
| MAXDATE Function | |
| MODEDATE Function |
Work day functions:
| Function Name | Description |
|---|---|
| NETWORKDAYS Function | |
| NETWORKDAYSINTL Function | |
| WORKDAY Function | |
| WORKDAYINTL Function |
Time zone conversion functions:
| Function Name | Description |
|---|---|
| CONVERTFROMUTC Function | |
| CONVERTTOUTC Function | |
| CONVERTTIMEZONE Function |
Authorization:
All workspace admins now have access to all user-created objects within the workspace.
NOTE: Workspace admin access is at the owner level to each user-created object in the workspace. Under some conditions, workspace admins may have access to source datasets and generated results. See Workspace Admin Permissions. |
None.
| Ticket | Description | |
|---|---|---|
| TD-47473 | Uploaded files (CSV, XLS, PDF) that contain a space in the filename fail to be converted.
|
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.
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:
None.
None.
None.
Release 6.11
This release introduces in-app chat and content suggestions within the application. Give it a try!
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:
New functions to parse values against specific data types:
| Function Name | Description |
|---|---|
| PARSEBOOL Function | |
| PARSEFLOAT Function | |
| PARSEINT Function |
None.
None.
None.
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.
Troubleshooting:
Flow View:
Job Details:
Documentation:
Sharing:
None.
None.
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.
Transformer Page:
Workspace:
Language:
New statistical functions.
| Function Name | Description |
|---|---|
| MEDIAN Function | |
| PERCENTILE Function | |
| QUARTILE Function | |
| CORREL Function | |
| COVAR Function | |
| COVARSAMP Function |
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.
None.
None.
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!
Workspace:
Transformer Page:
Improved Date/Time format selection. See Choose Datetime Format Dialog.
Tip: Datetime formats in card suggestions now factor in the user's locale settings for greater relevance. |
Job execution:
Enable and configure email notifications based on the success or failure of job executions.
Language:
This release introduces the sampling method of calculating statistical functions. The following are now available:
| Function Name | Description |
|---|---|
| STDEVSAMP Function | |
| VARSAMP Function | |
| STDEVSAMPIF Function | |
| VARSAMPIF Function | |
| ROLLINGSTDEVSAMP Function | |
| ROLLINGVARSAMP Function |
Import/Export:
| Ticket | Description |
|---|---|
| TD-44548 | RANGE function returns null values if more than 1000 values in output. |
None.
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.
Browser:
Project Management:
Operationalization:
Connectivity:
None.
None.
None.
Release 6.6
This release introduces new functions to the language and improvements in search for transformations.
Transformer Page:
Language:
| Function Name | Description |
|---|---|
| SINH Function | |
| COSH Function | |
| TANH Function | |
| ASINH Function | |
| ACOSH Function | |
| ATANH Function |
None.
| Ticket | Description |
|---|---|
| TD-42080 | Cannot run flow or deployment that contains more than 10 recipe jobs |
None.
Release 6.5
This release introduces new functions and fixes a number off issues.
Import:
Language:
| Function Name | Description |
|---|---|
| SIN Function | |
| COS Function | |
| TAN Function | |
| Cotangent Function | See TAN Function. |
| Secant Function | See COS Function. |
| Cosecant Function | See SIN Function. |
| ASIN Function | |
| ACOS Function | |
| ATAN Function | |
| Arccotangent Function | See ATAN Function. |
| Arcsecant Function | See ACOS Function. |
| Arccosecant Function | See ASIN Function. |
Connectivity:
None.
| Ticket | Description |
|---|---|
| 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. |
None.
Release 6.4
This release introduces macros, which enable reuse and parameterization of common sequences of recipe steps.
Reuse:
Connectivity:
Support for direct publishing to Tableau Server. For more information, see Run Job Page.
Support for Snowflake database connections. See Create Snowflake Connections.
Transformation:
Job Execution:
Wrangle:
$filepath references now return the location of the source Excel file. Sheet names are appended to the end of the reference. See Source Metadata References.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 |
NOTE: The Chat with us feature is no longer available. For |
Documentation:
| Ticket | Description | |
|---|---|---|
| TD-40424 |
| |
| TD-39513 | Import of folder of Excel files as parameterized dataset only imports the first file, and sampling may fail. | |
| TD-39092 |
For more information, see Source Metadata References. | |
| TD-31354 | When creating Tableau Server connections, the Test Connection button is missing. See Create Tableau Server Connections. |
None.
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.
Transform:
Connectivity:
Admin:
Language:
NOTE: The Chat with us feature is no longer available. For more information, see |
| Ticket | Description |
|---|---|
| TD-40243 | API access tokens don't work with native SAML SSO authentication |
This release fixes a few bugs.
None.
None.
| Ticket | Description | |
|---|---|---|
| TD-40965 | JSON output escapes quotes in Array or Object outputs.
|
None.
Release 6.2
This release includes new functions and a new method for locating datasets and recipes to join in.
Transformer Page:
Language:
New functions:
| Function Name | Description |
|---|---|
| RANK Function | |
| DENSERANK Function |
Connectivity:
None.
None.
None.
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.
Connectivity:
Wrangling:
None.
None.
None.
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.
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 |
Read/write support for Redshift.
For more information, see Create Redshift Connections.
Read support for the following relational connections.
Monitoring:
:
New functions:
| Function Name | Description |
|---|---|
| ARRAYINDEXOF Function | |
| ARRAYRIGHTINDEXOF Function | |
| ARRAYSLICE Function | |
| ARRAYMERGEELEMENTS Function |
LIST* functions now accept Array type only inputs.None.
None.
| Ticket | Description | |
|---|---|---|
| TD-39299 | In Create Connection window, all connection types are listed as Import and Publish.
| |
| TD-38869 | Upload of Parquet files does not support nested values, which appear as null values in the Transformer page.
|
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:
New functions:
The following functions can now be applied directly to arrays to derive meaningful statistics about them.
| Function | Description |
|---|---|
| ARRAYSORT Function | |
| TRANSLITERATE Function |
None.
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. |
None.
| Ticket | Description | |
|---|---|---|
| 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.
|
Language:
$filepath and $sourcerownumber references. See Source Metadata References.Jobs:
None.
None.
None.
This is the initial release of .