Easier iteration on Trifacta recipes with “lock/unlock column data types.” You now have more flexibility without constantly resetting the data types.
Publish arrays natively into Google BigQuery. This is part of our initiative to support a wide range of data types that you can publish directly onto cloud data warehouses such as BigQuery.
Faster data loading using Trifacta’s in-memory engine. This increases the number of output tables that can be cached for a recipe.
You can now avail additional use cases in your environment with new connectors for:
Strengthen the hybrid cloud environments with the General Availability of SSH Tunneling Connectivity Support. Data is encrypted during transit, thereby maintaining a secure transport session.
Automatically detect schema changes to keep your data accurate and updated continuously. Schema changes are detected for any changes to columns and you can configure your jobs to fail if undesired schema changes are detected.
Sample job IDs are now visible in the familiar Transformer view making it easy to quickly start working with your dataset, through better visibility.
Preserve and update metadata configuration that can be reused consistently and applied for new flows. This gives you complete flexibility with dataset configurations.
You can now have user-specific Customer Managed Encryption Keys (CMEKs) with Google Cloud Dataflow.
You can now avail additional use cases in your environment with new connectors for Instagram Ads.
Trifacta’s solution for SQL-based ELT on Snowflake is now Generally Available. With full pushdown on Snowflake, the data transformations are directly executed on Snowflake.
Keep your data fresh and updated with ‘Dataset Schema Refresh.’ This enables on-demand updating of your imported dataset schemas to capture changes to columns in your datasets.
We now provide increased flexibility with data transformations using Javascript User-Defined Functions (UDFs). These are custom functions to address specific use cases that can be imported into your Trifacta recipes.
REST API connections are supported on Trifacta enabling a generic interface to relational data. You can create connections to individual endpoints across hundreds of REST-based applications.
You can now avail additional use cases in your environment with new connectors for:
Custom SQL queries can now be run along with your Trifacta recipe with Pushdown on BigQuery.
Pick the desired size of your dataset sample within Trifacta, with an easy-to-use slider.
Create tasks to delete existing files or folders for better pipeline control.
Easy identification of flows to indicate sharing along with the list of collaborators.
Additional use case support with new connectors to Google Ads, Microsoft Advertising Connections, and Presto.
Pushdown Optimization became more interesting with full execution from files to BigQuery.
SQL scripts can be run easier from the flow interface giving you additional flexibility.
Run time processing is now possible with Trifacta’s in-memory processing engine on Google Cloud.
A wide range of user experience enhancements for better data engineering.