Contents:
This section contains an archive of release notes for previous releases of Trifacta®.
For the latest release notes, see Release Notes for Trifacta.
February 26, 2021
Release 8.1
What's New
Storage environment:
Support for use of TFS and S3 as storage environments at the same time. For more information, see Configure Storage Environment.
NOTE: When new workspaces are created, TFS is set as the default storage environment. S3 can be added as another storage environment or set as the default storage environment as sign-up is complete. For more information, see Getting Started with Trifacta.
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.
- Early Preview connections available with this release:
- Airtable
- Cassandra
- Freshdesk
- MailChimp
- For more information, see Early Preview Connection Types.
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 .
- Visual profiling must be enabled for the job.
- For more information, see Job Details Page.
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.
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.
Early Preview connections available with this release:
- Google Analytics
- For more information, see Early Preview Connection Types.
Changes in System Behavior
None.
Key Fixes
None.
New Known Issues
None.
January 26, 2021
Release 8.0
What's New
Connectivity:
- Support for connections to SharePoint Lists. See SharePoint Connections.
Support for using OAuth2 authentication for Salesforce connections. See Salesforce Connections.
- Support for re-authenticating through connections that were first authenticated using OAuth2.
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.
Metric-based data quality rules:
- You can create metric-based data quality rules for assessing the data quality.
- For more information, see Add Data Quality Rule.
- For more information, see Data Quality Rules Reference.
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.
Job execution:
- You can enable the Trifacta application to apply SQL filter pushdowns to your relational datasources to remove unused rows before their data is imported for a job execution. This optimization can significantly improve performance as less data is transferred during the job run. For more information, see Flow Optimization Settings Dialog.
- Optimizations that were applied during the job run now appear in the Job Details Page. See Job Details Page.
APIs:
- Individual workspace users can be permitted to create and use their own access tokens for use with the REST APIs. For more information, see Workspace Settings Page.
Changes in System Behavior
None.
Key Bug Fixes
| Ticket | Description |
|---|---|
| TD-57180 | AWS jobs run on Photon to publish to HYPER format fail during file conversion or writing. |
New Known Issues
| Ticket | Description |
|---|---|
| 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:
- The maximum permitted size of a file uploaded through Trifacta application has been increased from 100 MB to 1 GB.
Plan View:
- Import and Export Plans: You can import and export plans from one environment, workspace, or projects to others.
For more information, see Export Plan.
For more information, see Import Plan.
- Share Plans: Share plans with one or more users to work together on the same plan. For more information, see Share a Plan.
- Email notifications: Send email notifications to plan owners and collaborators based on the status of execution of plans. For more information, see Manage Plan Notifications Dialog.
Photon:
Introducing Trifacta Photon, an in-memory running environment for running jobs. Embedded in the Trifacta, 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 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.
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:
- Support for authentication to third-party datastores using OAuth2. For more information, see Enable OAuth 2.0 Authentication.
- Support for using OAuth2 for Snowflake connections. For more information, see OAuth 2.0 for Snowflake.
Connectivity:
Improved Salesforce connection type.
For more information, see Salesforce Connections.
API:
- Reference documentation on the API endpoints is now available for:
- API Endpoints for Trifacta Premium
- For more information, see https://api.trifacta.com.
API:
- Experimental feature: Export Python Pandas code to generate the transformation steps required to produce a defined output object.
- NOTE: This feature can be changed or removed from the platform at any time without notice. Do not deploy it in a production environment.
- For more information, see API Workflow - Wrangle Output to Python.
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.
Key Bug Fixes
| 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. |
New Known Issues
| Ticket | Description |
|---|---|
| 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
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
Introducing TFS:
Trifacta File Storage (TFS) is an S3-backed storage service provided by Trifacta, which can be enabled for new workspaces. TFS manages the data storage for imported datasets, samples, metadata, and generated results for the product.
NOTE: TFS is available only for new workspaces at this time. After choosing to use TFS, you cannot choose to switch to using your own S3 bucket.
To check out TFS, you can register for a new workspace. For more information, see Getting Started with Trifacta.
Plan View:
- Execute Plan using status rules: Starting in Release 7.9, you can execute tasks based on the previous task execution result. For more information, see Create a Plan.
- Execute Parallel Plan tasks: In previous releases, plans were limited to a sequential order of task execution. Beginning in Release 7.9, you can create branches in the graph into separate parallel nodes, enabling the corresponding tasks to run in parallel. This feature enables you to have a greater level of control of your plans' workflows. For more information, see Create a Plan.
- Zoom options: Zoom control options and keyboard shortcuts have been introduced in the plan canvas. For more information, see Plan View Page.
- Filter Plan Runs: Filter your plan runs based on dates or plan types. For more information, see Plan Runs Page.
Transform Builder:
- An All option has been added for selecting columns in the Transform Builder. For more information, see Changes to the Language.
Changes in System Behavior
Flow optimizations re-enabled:
For Trifacta, 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.
- By default, flow optimizations are enabled for the entire workspace. They can be disabled if necessary. See Workspace Settings Page.
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 Trifacta application 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 Trifacta application 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 Trifacta Support.
Key Bug Fixes
| 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. |
New Known Issues
None.
October 19, 2020
Release 7.8
What's New
Plans:
Create HTTP tasks for your plans, which can be configured to issue a request to an API endpoint over HTTP.
- For more information, see Plan View for HTTP Tasks.
- For more information on plans, see Overview of Operationalization.
Flow View:
- Get started adding and building objects in your flows with new object placeholders. See Flow View Page.
- The viewport position and zoom level are now preserved when returning to a given flow.
Publishing:
- Improved performance when publishing to Tableau Server.
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.
Data quality rules:
Improvements to suggestions for data quality rules:
- Existing Data quality rules panel is updated with View suggestions button.
- Data quality rules are now categorized by suggestions for individual columns.
- Some rule types support the May be missing checkbox. When it is selected, the data quality rule allows missing values to be acceptable for a specified column. For more information on data quality rules, see Data Quality Rules Panel.
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 Amazon Redshift Connections.
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 .
Salesforce connector disabled temporarily:
In this release, the Salesforce connector has been disabled temporarily. In a future release, it will be replaced with an improved version of the Salesforce connector.
Key Bug Fixes
None.
New Known Issues
| 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. 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.
- This issue affected a very small number of users who were using the new feature. Now that the feature is disabled, impacted users should experience impacts only to performance of flow and job executions. Performance should be similar to pre-release of the service.
- The Optimizer service was disabled through a configuration change that did not require any service interruptions. Users should not experience any loss of functionality or availability due to the work to resolve this issue.
- The Trifacta Engineering team is actively working to resolve the issue. Thank you for patience. If you have further questions, please contact Trifacta Support.
Key Bug Fixes
None.
New Known Issues
None.
September 21, 2020
Release 7.7
What's New
Manage workspace users:
Workspace administrators can:
- Modify users. See Users Page.
- Explore details on individual users. See User Details Page.
- Assign and un-assign workspace roles to individual users. See Roles Page.
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
| 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). |
New Known Issues
None.
August 19, 2020
Release 7.6
What's New
Introducing Trifacta Premium and Trifacta Standard:
- These product editions remove the limitations on Trifacta Free and deliver enhanced capabilities in connectivity, operationalization, and API access.
- Product documentation for all three editions can be found in this same location with distinctions noted as needed.
- For more information, see Product Editions .
Plan View:
Apply overrides to recipe parameters for your plans. See Plan View Page.
- Download logs for plan runs and individual flow tasks in the run. See Plan Runs Page.
Flow View:
- Configure advanced settings on your flow and its job executions. See Flow Optimization Settings Dialog.
Data quality rules:
- You can select data quality rules from a set of suggestions presented to you.
- For more information, see Data Quality Rules Panel.
- For more information, see Overview of Data Quality.
Job Execution:
Support for job cancellation. See Jobs Page.
Documentation:
- Additional connect string options and troubleshooting information has been included for specific relational connections.
- For more information, see Connection Types.
Changes in System Behavior
IP addresses to whitelist have changed:
Please verify that the following range of IP addresses have been whitelisted for the Trifacta service 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.
Key Fixes
| 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. |
New Known Issues
| 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). Workaround: Remove the hyphen from the flow name or output target and re-publish the results. |
July 20, 2020
Release 7.5
What's New
New Flow View is now generally available:
- Drag and drop to reposition objects on the Flow View canvas, and zoom in and out to focus on areas of development.
- Perform joins and unions between objects on the Flow View canvas.
- Search for flow objects by name or by type.
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.
- Create and edit flow parameters and their overrides while editing your recipe. See Transformer Page.
- For more information on editing flow parameters, see Manage Parameters Dialog.
Plans:
- Monitor status of all of your plan runs and drill into details. See Plan Runs Page.
Authorization:
- Workspace administrators can now create and assign roles to govern access to types of objects in the workspace. For more information, see Changes to User Management.
Language:
- New approximation functions for median, percentile, and quartile based on a very fast algorithm:
- New functions to encode and decode base64 strings.
Changes in System Behavior
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:
- For social security numbers and credit card numbers, the methods by which these values are determined for purposes of masking sensitive Personally Identifiable Information (PII) has been expanded and improved. For more information, see Improvements to the Type System.
IP addresses to whitelist have changed:
Please verify that the following range of IP addresses have been whitelisted for the Trifacta service 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.
Key Fixes
None.
New Known Issues
| 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. |
June 22, 2020
Release 7.4
What's New
Language:
- New weekday name function.
- See Changes to the Language.
Changes in System Behavior
NOTE: Beginning in this release, the set of IP addresses for the Trifacta Service has been changed. If you have connected to any relational sources from the product, please update all of your database services to which Trifacta 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.
API:
- Redshift connections now require a different credential type.
- Snowflake connections now require a different credential type.
- See Changes to the APIs.
Key Bug Fixes
None.
New Known Issues
None.
June 4, 2020
Release 7.3
This is the initial release of Trifacta® Standard.
NOTE: In this initial release, only the free tier of Trifacta Standard (known as Trifacta Free) is available. Some restrictions apply. See Product Limitations.
For more information on removing the restrictions, please contact Trifacta Support.
This page has no comments.