Contents:
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.
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.
- For more information, see Workspace Settings Page.
- For more information on sampling, see Overview of Sampling.
Transformer page:
Improved performance of the Transformer page through asynchronous loading of initial samples.
Deprecated
None.
Key Bug Fixes
None.
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.
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.
Deprecated
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-66185 | Flatten transformation cannot handle multi-character delimiters. |
New Known Issues
None.
March 10, 2022
Release 9.1
What's New
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.
- For more information, see Generate a Sample.
- For more information, see Samples Panel.
- For more information, see Sample Jobs Page.
Changes in System Behavior
None.
Deprecated
None.
Key Bug Fixes
None.
New Known Issues
None.
January 31, 2022
Release 9.0
No updates.
January 10, 2022
Release 8.11
What's New
Performance:
- Improved performance during design time through intelligent caching of recipe steps. This feature has been disabled. This feature is currently disabled due to technical issues. When this message is gone, it will be available in the product.
For updates on system status, please visit https://status.trifacta.com/.
Changes in System Behavior
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
None.
November 22, 2021
Release 8.10
What's New
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.
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.
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
None.
October 26, 2021
Release 8.9
What's New
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
| Ticket | Description |
|---|---|
| TD-65502 | Datasets 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
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 Wrangler 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,000must 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:
c1 c2 c3 c4 """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:
c1 c2 c3 c4 "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
c3have 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.
Deprecated
None.
Key Bug Fixes
None.
New Known Issues
| Ticket | Description |
|---|---|
| TD-63974 | In imported datasets sourced from CSV files, double quotes that are escaped with a backslash ( |
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.
Recipe panel:
- Some enhancements to flagging steps for review. See Flag for Review.
Changes in System Behavior
None.
Deprecated
None.
Key Bug Fixes
None.
New Known Issues
| Ticket | Description |
|---|---|
| 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
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
None.
June 28, 2021
Release 8.5
What's New
Flow View:
- Click a node to see its lineage within the flow. See Flow View Page.
Job execution:
You can choose to ignore the recipe errors before job execution and then review any errors in the recipe through the Job Details page.
- For more information, see Run Job Page.
- For more information, see Job Details Page.
Language:
- NUMVALUE function can be used to convert a String value formatted as a number into an Integer or Decimal value.
- NUMFORMAT function now supports configurable grouping and decimal separators for localizing numeric values.
- For more information, see Changes to the Language.
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
May 24, 2021
Release 8.4
What's New
Template Gallery:
- Check out the new gallery of flow templates, which can be imported into your workspace. These templates are pre-configured to solve the most compelling loading and transformation use cases in the product. For more information, see www.trifacta.com/templates.
- For more information on importing flows into your workspace, see Import Flow.
Language:
- New content on parsing functions. See Changes to the Language.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-60881 | Incorrect file path and missing file extension in the application for parameterized outputs |
| TD-60382 | Date format |
New Known Issues
None.
May 5, 2021
Release 8.3 - push 2
What's New
None.
Changes in System Behavior
Improved method of JSON import
Beginning in this release, the Trifacta application now uses the conversion service to ingest JSON files during import. This improved method of ingestion can save significant time wrangling JSON into records.
NOTE: The new method of JSON import is enabled by default.
For more information, see Working with JSON v2.
Flows that use imported datasets created using the old method continue to work without modification.
Key Bug Fixes
None.
New Known Issues
None.
April 26, 2021
Release 8.3
What's New
Single login for multiple workspaces: Login through https://cloud.trifacta.com and then choose the workspace to which to connect. If you are a member of multiple workspaces, you can switch between workspaces through the User menu. For more information, see Home Page.
Job results:
You can now preview job results and download them from the Overview tab of the Job details page. For more information, see Job Details Page.
Tip: You can also preview job results in Flow View. See View for Outputs.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-60701 | Most non-ASCII characters incorrectly represented in visual profile downloaded in PDF format |
| TD-59854 | Datetime column from Parquet file incorrectly inferred to the wrong data type on import. |
New Known Issues
None.
March 22, 2021
Release 8.2
What's New
Preferences:
- Re-organized user account, preferences, and storage settings to streamline the setup process. See Preferences Page.
Spark Execution Properties Settings:
Advanced Spark parameters have been newly added to the Spark running environment. Use these parameters to override the global Spark settings for individual jobs. For more information, see Spark Execution Properties Settings.
Improve Accessibility of Job Results:
The Jobs tabs have been enhanced to display the list of latest and the previous jobs that have been executed for the selected output.
For more information, see View for Outputs.
Sample Jobs Page:
Changes in System Behavior
None.
Key Fixes
| Ticket | Description |
|---|---|
| TD-59236 | Use of percent sign (%) in file names causes Transformer page to crash during preview. |
| TD-59218 | BOM characters at the beginning of a file causing multiple headers to appear in Transformer Page. |
| TD-58932 | Cannot read file paths with colons from EMR Spark jobs |
| TD-58802 | Running job on Photon using zipped CSV that was uploaded yields garbage characters in output. |
| TD-58694 | Very large number of files generated during Spark job execution |
New Known Issues
| Ticket | Description |
|---|---|
| TD-60701 | Most non-ASCII characters incorrectly represented in visual profile downloaded in PDF format. |
March 9, 2021
Release 8.1, push 2
What's New
Macro updates:
You can replace an existing macro definition with a macro that you have exported to your local desktop.
NOTE: Before you replace the existing macro, you must export a macro to your local desktop. For more information, see Export Macro.
For more information, see Macros Page.
Changes in System Behavior
None.
Key Fixes
None.
New Known Issues
None.
February 26, 2021
Release 8.1
What's New
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
| 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. |
New Known Issues
None.
January 26, 2021
Release 8.0
What's New
Import:
- Improved method for conversion and ingestion of XLS/XSLX files. For more information, see Import Excel Data.
Recipe development:
- The Flag for Review feature enables you to set review checkpoints in your recipes. You can flag recipe steps for review by other collaborators for review and approval. For more information, see Flag for Review.
Update Macros:
- Replace / overwrite an existing macro's steps and inputs with a newly created macro.
- Map new macro parameters to the existing parameters before replacing.
- Edit macro input names and default values as needed.
- For more information, see Create or Replace Macro.
- For more information, see Overview of Macros.
- For more information, see Create or Replace Macro.
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
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:
- The maximum permitted size of a file uploaded through Trifacta application has been increased from 100 MB to 1 GB.
Photon:
Introducing Trifacta Photon, an in-memory running environment for running jobs. Embedded in the Trifacta Wrangler, Trifacta Photon is fast and best-suited for small- to medium-sized jobs.
- When you choose to run a job, you can now choose to run a job on Trifacta Photon.
- Trifacta Wrangler specifies the most appropriate running environment as the default selection based on the size of your job.
- For more information, see Run Job Page.
Sampling:
- Trifacta Photon also enables quick scan sampling. A quick scan sample generates an appropriate selection of rows from the dataset from which to perform the sample. These samples are faster to generate. For more information, see Overview of Sampling.
- For more information on generating samples, see Samples Panel.
Changes in System Behavior
None.
Key Bug Fixes
None.
New Known Issues
None.
November 18, 2020
Release 7.9
What's New
Flow View:
- Export your flows to back up your flow logic. For more information, see Export Flow.
- As needed, you can import flows back into the product. See Import Flow.
Transform Builder:
- An All option has been added for selecting columns in the Transform Builder. For more information, see Changes to the Language page.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-55125 | Cannot copy flow. |
New Known Issues
None.
October 19, 2020
Release 7.8
What's New
Flow View:
- The viewport position and zoom level are now preserved when returning to a given flow.
Language:
- Rename columns now supports uppercase or lowercase characters or shorten column names to a specified character length from the left or right. For more information, see Changes to the Language .
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.
- For more information, see Flows Page.
- For more information, see Flow View Page .
Key Bug Fixes
None.
New Known Issues
None.
September 21, 2020
Release 7.7
What's New
Flow View:
- Automatically organize the nodes of your flow with a single click. See Flow View Page.
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
None.
New Known Issues
None.
August 19, 2020
Release 7.6
What's New
In this release, experimental versions of the following have been deployed to some users of the product:
- First-time on-boarding: New and improved product walkthrough!
- Getting started workflow: Shorter and faster method for getting started wrangling data. Example datasets are available for use!
Got feedback? We'd love to hear it. Please contact Trifacta Support.
Job Execution:
Support for job cancellation. See Job History Page.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-48915 | Inserting special characters in an output filename results in a validation error in the the application and job failures. |
New Known Issues
None.
This page has no comments.