Trifacta, a data engineering cloud company, has announced advanced pushdown optimization capabilities for Snowflake. This innovation enables faster data transformation and emphasizes Trifacta’s leadership in data engineering to deliver consumable data for analytics and machine learning.
Further, Trifacta’s native support for Snowflake SQL allows data professionals to build the entire transformation logic, allowing users of all skill sets to work on huge data directly within Snowflake’s data cloud.
“Our research shows three-quarters of organizations use or plan to use the cloud for data and analytics. As cloud data warehousing and ELT approaches continue to grow, speed of execution and ease of use are critical for data professionals looking to transform large data sets for downstream analytics and machine learning,” said Matt Aslett, research director at Ventana Research. “Trifacta’s pushdown optimization for Snowflake comes at a critical time and solidifies the company’s position as a key innovator in data engineering.”
With data architectures transitioning to modern ELT (extract, load, transform) approaches, modern cloud data solutions are becoming key to loading the data before the transformation. Pushdown optimization techniques help data workers convert transformation steps into SQL scripts. Alternatively, data engineers who like to leverage code can complement their technical expertise with advanced and more complex data transformations using their own code.
Head of Snowflake’s Technology Alliances Tari Dwiek said, “This allows our customers to embrace both no-code and code-based options to interact directly with their data using Snowflake tables in near real-time, enabling faster data transformations than with traditional approaches.”
Trifacta’s co-founder and CTO Sean Kandel added, “Trifacta’s rich, intuitive interface provides previews of recommended transformations in real-time for analysts to review before committing the changes. With pushdown optimization for Snowflake, we are expanding our data engineering capabilities for users to run their recipes natively easily and quickly, reducing transformation time from hours to minutes.”
Key benefits of Trifacta’s pushdown optimization with Snowflake include:
- Increased Productivity – Pushdown optimization with Snowflake offers faster data transformations directly on Snowflake’s platform across entire tables, which eliminates the need to write complex SQL statements or code allowing users to focus on the data, increasing their productivity by more than two times.
- Quicker Data Transformations with High-Quality – Trifacta offers faster data transformations by leveraging the power of Snowflake’s platform. With pushdown optimization, data loading and transformation occurs simultaneously, delivering high-quality data, providing organizations and data professionals with the required insights for analytics and machine learning.
- Scale of Operations – Trifacta’s support of Snowflake leverages the scale of the cloud enabling data transformations across any scale of data from a few MBs to exabytes, Trifacta provides intelligent data transformations helping data professionals understand the information at the most granular level with the desired scale.
To learn more about Trifacta’s Pushdown Optimization for Snowflake, visit trifacta.com/snowflake