...

June 28, 2021

Release 8.4 push 25

What's New

...

Parameterization:

• 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:

  • 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

Connectivity:

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

• 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 

For more information, see Working with JSON v2.

Key Bug Fixes

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

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

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

...

• 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:

• D s conntype
  type 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.
  

  D s ed
  r true editions awsent,awspro,awspr

  
  For more information, see Create Connection Window.

...

Connectivity:

• Read-only support for

  D s conntype
  type Teradata

  connections. For more information, see Teradata Connections.

...

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.

...

• 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.34 push 2

What's New

Connectivity:

...

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.
  • For more information on using a template in the product, see Start with a Template. 

Connectivity:

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

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

• • YouTube Analytics

• • 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 

...

Changes in System Behavior

None.

Key Bug Fixes

None.

New Known Issues

None.

May 24, 2021

Release 8.4

What's New

Connectivity:

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

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

...

• 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 

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

  D s product

  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:

• 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 addedto 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 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:

• 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 

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

...

March 9, 2021

Release 8.1, push None.

March 22, 2021

Release 8.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 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

  D s product

  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:

...

• Google Analytics

• Amazon Athena
• Amazon DynamoDB

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

Changes in System Behavior

None.

Key Fixes

None.

New Known Issues

None.

February 26, 2021

Release 8.1

What's New

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.

...

• 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 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 addedto the Spark running environment. Use these parameters to override the global Spark settings for individual jobs. For more information, see Spark Execution Properties Settings.

...

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

None.

New Known Issues

March 9, 2021

Release 8.01, push 2

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:

...

Macro updates:

You can replace an existing macro definition with a macro that you have exported to your local desktop.

...

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:

...

For more information, see Macros Page.

Early Preview connections available with this release:

• Google Analytics
• 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

  D s webapp

  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

...

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

;ConnectOnOpen=true

December 21, 2020

Release 7.10

What's New

Import:

• The maximum permitted size of a file uploaded through 

  D s webapp

   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

• When you choose to run a job, you can now choose to run a job on

  D s photon

  .

• D s product

  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:

• D s 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.

  Info
  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:

• 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

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

Key Bug Fixes

...

New Known Issues

...

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

...

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

November 18, 2020

Release 7.9

What's New

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 

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.

  Info
  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 

Beginning in this release, the 

Key Bug Fixes

...

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:

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

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. 
  

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

Key Bug Fixes

None.

New Known Issues

...

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.

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 

  D s item
  item Engineering team

   is actively working to resolve the issue. Thank you for patience. If you have further questions, please contact 

  D s 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 Workspace Users Page.
• Explore details on individual users. See Workspace User Details Page.
• Assign and un-assign workspace roles to individual users. See Workspace 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. 

For more information, see Flow View Page.

Key Bug Fixes

...

New Known Issues

None.

August 19, 2020

Release 7.6

What's New

Flow View:

• Configure advanced settings on your flow and its job executions. See Flow Optimization Settings Dialog.

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.

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 

35.199.3.51/32
35.245.35.240/28

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

Key Fixes

...

None.

July 20, 2020

Release 7.5

What's New

New Flow View is now generally available:

...

Annotate the canvas with notes.

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

  Info
  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:

  • Oracle Database Connections

  • Microsoft SQL Server Connections

  • PostgreSQL Connections

  • Amazon Redshift Connections

  • Snowflake Connections

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:
  • APPROXIMATEMEDIAN Function
  • APPROXIMATEPERCENTILE Function
  • APPROXIMATEQUARTILE Function
• New functions to encode and decode base64 strings.
  • BASE64ENCODE Function
  • BASE64DECODE Function

Changes in System Behavior

Schema information is retained:

When schematized datasources are ingested, schema information is now retained for publication of job results.

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 

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

...

June 22, 2020

Release 7.4

What's New

Language:

• New weekday name function. 
• See Changes to the Language.

Changes in System Behavior

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

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

What's New

Data quality rules:

• Introducing data quality rules, which enable you to define data quality checks specific to your dataset. For more information, see Overview of Data Quality.
  • Data quality rules are created in the Transformer page. For more information, see Data Quality Rules Panel. 

Language:

New rolling window date functions. 

...

...

...

Changes in System Behavior

None.

Key Bug Fixes

...

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. 

...

Annotate the canvas with notes.

...

Publishing:

• Support for generating results and publishing to Tableau Hyper format. 

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

  • If you are on Tableau Server 10.5 or later and you append to a TDE file, the file is automatically converted to Hyper format. This conversion cannot be reverted.
  • See Tableau Server Connections.

Connectivity:

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

Language:

...

...

...

...

...

...

...

Changes in System Behavior

None.

Key Bug Fixes

...

New Known Issues

None.

April 15, 2020

Release 7.1

What's New

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:

• Ingestion of large relational datasets is no longer a blocking operation. Track progress of large-scale ingestion in Flow View and the Library page. 
  • See Flow View Page.
  • See Import Data Page.

Flow View:

Create flow parameters that you can reference in the recipes of your flow.  Flow parameters can be string literals, 

As needed, you can apply overrides to the parameters in your flow or to downstream flows. 

...

Transformation:

• Faster and improved method of surfacing transform suggestions based on machine learning.

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.

• MIN Function
• MINIF Function
• ROLLINGMIN Function
• MAX Function
• MAXIF Function
• ROLLINGMAX Function
• MODE Function
• MODEIF Function
• ROLLINGMODE Function
• KTHLARGEST Function
• KTHLARGESTIF Function
• ROLLINGKTHLARGEST Function
• KTHLARGESTUNIQUE Function
• KTHLARGESTUNIQUEIF Function
• ROLLINGKTHLARGESTUNIQUE Function

Date calculation functions:

...

...

...

Work day functions:

...

...

...

...

Time zone conversion functions:

...

...

...

Changes in System Behavior

Authorization:

...

All workspace admins now have access to all user-created objects within the workspace.

Key Bug Fixes

None.

New Known Issues

...

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

March 17, 2020

Release 7.0

Beginning in this release, you can access publicly available APIs of the 

What's New

APIs:

Import:

...

• Track progress of large-scale ingestion in Flow View and the Library page. 
  • See Flow View Page.
  • See Import Data Page.

...

...

Transformer Page:

• Improved performance when loading the Transformer page and when navigating between the Flow View and Transformer pages.
• Join steps are now created in a larger window for more workspace. See Join Window.

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: 

Language:

New functions to parse values against specific data types:

...

...

...

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

T roubleshooting:

• Encounter an issue with the product? Select Help > Report issue to collect session information for 

  D s support

  . See Report Issue.

Flow View:

• Monitor job progress through each phase in the Jobs panel. See Flow View Page.

Job Details:

• When visual profiling is enabled for a job, you can now download your visual profile in PDF format. See Job Details Page. 

Documentation:

• New content on the getting started with sampling. See Sampling Basics.
  • Feature overview: Overview of Sampling
  • Best practices: https://community.trifacta.com/s/article/Best-Practices-Managing-Samples-in-Complex-Flows

Changes in System Behavior

Sharing:

• The Send a Copy feature is no longer available in the product. As a workaround, you can make a copy of the flow and share it. See Flow View Page.

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:

• New column selection UI simplifies choosing columns in your transformations. See Transform Builder. 

Workspace:

• Redesigned Settings and Help menus. See Home Page.

• • User settings are now modified through Preferences. See Preferences Page.
  • Administrators now have a dedicated admin area. See Admin Console.

Language:

New statistical functions. 

...

...

...

...

...

...

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.

• See MODE Function.
• See MODEIF Function.
• See LISTMODE Function.
• See ROLLINGMODE Function.

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:

• Individual users can now enable or disable keyboard shortcuts in the workspace or Transformer page. See User Profile Page.
• Configure locale settings at the workspace or user level. See Locale Settings.
• You can optionally duplicate the datasets from a source flow when you create a copy of it. See Flow View Page.
• Create a copy of your imported dataset. See Library Page.

Transformer Page:

...

Improved Date/Time format selection. See Choose Datetime Format Dialog.

...

Job execution:

• If you enabled visual profiling for your job, you can download a JSON version of the visual profile. See Job Details Page.

• Enable and configure email notifications based on the success or failure of job executions. 

  • For more information on enabling, see Workspace Settings Page.
    • Individual users can opt out of receiving email messages or can configure use of a different email address. See Email Notifications Page.
  • For more information on enabling emails for individual flows, see Manage Flow Notifications Dialog.

Language:

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

...

...

...

...

...

...

Changes in System Behavior

Import/Export:

• Flows can now be exported and imported across products and versions of products. See Export Flow.

Key Bug Fixes

...

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 

What's New

Browser:

...

...

Project Management:

• Support for export and import of macros. See Macros Page.
  • For more information on macros, see Overview of Macros.

Operationalization:

• Create webhook notifications for third-party platforms based on results of your job executions. See Create Flow Webhook Task.

Connectivity:

• Support for ingest from read-only Snowflake databases. See Snowflake Connections.

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:

• Improvements to the Search panel enable faster discovery of transformations, functions, and other objects. See Search Panel.

Language:

...

...

...

...

...

...

Changes in System Behavior

None.

Key Bug Fixes

...

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:

• Scan nested folders to import datasets with parameters. See Create Dataset with Parameters.

Language:

...

...

...

...

...

...

...

Connectivity:

• Support for using non-default database for your Snowflake stage. See Snowflake Connections.

Changes in System Behavior

None.

Key Bug Fixes

...

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:

• Introducing user-defined macros, which enable saving and reusing sequences of steps. For more information, see Overview of Macros.

Connectivity:

• Support for direct publishing to Tableau Server. For more information, see Run Job Page.

• Support for Snowflake database connections. See Snowflake Connections.

Transformation:

• New cluster view for transforming by example. See Transformation by Example Page.

Job Execution:

• Support for detailed job monitoring for ingest and publishing jobs. See Overview of Job Monitoring.
• Parameterize output paths and table and file names. See Run Job Page.

Wrangle:

• Broader support for metadata references: For Excel files, $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 .

Changes in System Behavior

...

• In prior releases, the documentation listed UTF32-BE and UTF32-LE as supported file formats. These formats are not supported. Documentation has been updated to correct this error. See Supported File Encoding Types. 

Key Bug Fixes

...

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

...

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

For more information, see Source Metadata References.

...

• Early Preview Connection Types.

Changes in System Behavior

None.

Key Fixes

None.

New Known Issues

None.

February 26, 2021

Release 8.1

What's New

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.

  Info
  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

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

  D s webapp

  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

December 21, 2020

Release 7.10

What's New

Import:

• The maximum permitted size of a file uploaded through 

  D s webapp

   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

• When you choose to run a job, you can now choose to run a job on

  D s photon

  .

• D s product

  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:

• D s 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.

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

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

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

Key Bug Fixes

New Known Issues

November 18, 2020

Release 7.9

What's New

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 

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.

  Info
  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 

Beginning in this release, the 

Key Bug Fixes

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:

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

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. 
  

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

Key Bug Fixes

None.

New Known Issues

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 

  D s item
  item Engineering team

   is actively working to resolve the issue. Thank you for patience. If you have further questions, please contact 

  D s 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 Workspace Users Page.
• Explore details on individual users. See Workspace User Details Page.
• Assign and un-assign workspace roles to individual users. See Workspace 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. 

For more information, see Flow View Page.

Key Bug Fixes

New Known Issues

None.

August 19, 2020

Release 7.6

What's New

Flow View:

• Configure advanced settings on your flow and its job executions. See Flow Optimization Settings Dialog.

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.

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 

35.199.3.51/32
35.245.35.240/28

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

Key Fixes

New Known Issues

None.