Earlier Releases of Trifacta

Contents:

This section contains an archive of release notes for previous releases of  Trifacta®.

For the latest release notes, see Release Notes for Trifacta.

June 28, 2021

Release 8.5

What's New

Parameterization:

• Create environment parameters to ensure that all users of the project or workspace use consistent references.

  NOTE: You must be a workspace administrator or project owner to create environment parameters.

  Tip: Environment parameters can be exported from one project or workspace and imported into another, so that these references are consistent across the enterprise.

  • For more information, see Environment Parameters Page.
  • For more information on parameters in general, see Overview of Parameterization.
• Parameterize names of your storage buckets using environment parameters.
  • See Create Dataset with Parameters.
  • See Create Outputs.
  • For more information on parameters, see Overview of Parameterization.

Flow View:

• Click a node to see its lineage within the flow. See Flow View Page.

Job execution:

• Define SQL scripts to execute before data ingestion or after publication for file-based or table-based jobs.

  • This feature may need to be enabled in your environment. For more information, see Workspace Settings Page.

  • For more information, see Create Output SQL Scripts.

Connectivity:

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

  Feature Availability: This feature is available in the following editions:

  
  
  • Trifacta Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Premium

  
  

• Apache Impala

• For more information, see Early Preview Connection Types.

Connectivity:

• Connect to your relational database systems hosted on Amazon RDS. In the Connections page, click the Amazon RDS card for your connection type.
  
  Feature Availability: This feature is available in the following editions:

  
  
  • Trifacta® Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Premium

  
  
  
  For more information, see Create Connection Window.

Connectivity:

• Read-only support for  Teradata connections. For more information, see Teradata Connections.

Developer:

Download and install the Python SDK, which enables you to leverage the visual tools of the Trifacta application to transform data in your existing Python pipelines.

For more information, see Python SDK.

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.

Resource usage:

• Review the total vCPU hours consumed by your datasets, recipes, and job execution within your workspace across an arbitrary time period. 
  • For more information, see Workspace Usage Page.
  • For more information, see Usage Metrics.

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.

June 7, 2021

Release 8.4 push 2

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.

Connectivity:

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

  Feature Availability: This feature is available in the following editions:

  
  
  • Trifacta Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Premium

  
  
  • YouTube Analytics

• • For more information, see Early Preview Connection Types

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

May 24, 2021

Release 8.4

What's New

Self-serve upgrades from your free trial: Through the Admin console, you can review and select the paid plan that works for you. Submit payment details through the application and begin using your upgrade workspace immediately.

• See Workspace Usage Page.

Connectivity:

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

  Feature Availability: This feature is available in the following editions:

  
  
  • Trifacta Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Premium

  
  

• Splunk
• For more information, see Early Preview Connection Types.

Connectivity:

• Support for Google Sheets connections using OAuth2 authentication. For more information, see Google Sheets Connections.

Collaboration:

• You can receive email notifications whenever a plan or a flow is shared with you by the owner.

  • This feature may need to be enabled in your environment. For more information, see Workspace Settings Page.

  • For more information, see Email Notifications Page.

Language:

• New content on parsing functions. See Changes to the Language.

Changes in System Behavior

None.

Key Bug Fixes

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

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.

For more information, see Working with JSON v2.

Key Bug Fixes

None.

New Known Issues

None.

April 26, 2021

Release 8.3

What's New

Connectivity:

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

  Feature Availability: This feature is available in the following editions:

  
  
  • Trifacta Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Premium

  
  

• Authorize.net
• Cockroach DB
• DB2
• Magento
• Redis
• Shopify
• Smartsheet
• Trello
• QuickBase

• For more information, see Early Preview Connection Types.

Connectivity:

You can publish results to external S3 buckets through an Access key and Secret key. For more information, see External S3 Connections

Job execution:

Introducing new filter pushdowns to optimize the performance of your flows during job execution. For more information, see Flow Optimization Settings Dialog.

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.

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.

For more information, see Working with JSON v2.

Flows that use imported datasets created using the old method continue to work without modification.

Future work on support for JSON is targeted for the v2 version only.

For more information on using the old version and migrating to the new version, see Working with JSON v1.

API

The following API endpoints are scheduled for deprecation in a future release:

/v4/connections/vendors
/v4/connections/credentialTypes
/v4/connections/:id/publish/info
/v4/connections/:id/import/info

These endpoints have little value for public use.

Key Bug Fixes

New Known Issues

None.

March 31, 2021

Release 8.2 - push 2

What's New

This is the initial release of the following product editions:

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

Changes in System Behavior

None.

Key Fixes

None.

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.

API:

• You can now transfer ownership of assets created in  Trifacta between users, based on their user identifiers or email addresses. For more information, see Changes to the APIs.

Connectivity:

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

  Feature Availability: This feature is available in the following editions:

  
  
  • Trifacta Enterprise Edition
  • Trifacta Professional Edition
  • Trifacta Premium

  
  

• Amazon Athena
• Amazon DynamoDB
• Greenplum
• HubSpot
• MariaDB
• Microsoft Dynamics 365 Sales
• ServiceNow
• Smartsheet
• For more information, see Early Preview Connection Types.

Plan metadata references:

Use metadata values from other tasks and from the plan itself in your HTTP task definitions.

• For more information, see Create HTTP Task.
• For more information, see Plan Metadata References.

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:

You can monitor the status of all sample jobs that you have generated. Project administrators can access all sample jobs in the workspace. For more information, see Sample Jobs Page.

Changes in System Behavior

None.

Key Fixes

New Known Issues

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.

  Feature Availability: This feature is available in

  Trifacta Premium only.

• 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

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.

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

New Known Issues

;ConnectOnOpen=true