Snowflake recently announced the availability of Snowpark and Java functions in preview for all customers on AWS.
These two new features are a bridge into the data engineering world and data programmability. They open up Snowflake Data Cloud to additional personas such as data scientists and Java developers. And they invite engineers to use the language of their choice (e.g., Scala, Java) to interact with Snowflake and leverage the power of Snowflake Data Cloud.
With Java UDF, you can bring your own custom code and business logic to Snowflake and execute it in Snowflake, close to the data, while improving performance and optimizing costs.
Developers can continue to use their existing development environment to write their complex, custom logic, load it to Snowflake Data Cloud, register it as a function, and have it available to be used by any SQL user.
As members in the Snowpark Accelerated program, Informatica has announced support for Snowflake’s Java UDF via Informatica Cloud Data Management platform.
Informatica enables customers to leverage the power of Java UDF from within Informatica’s platform as part of a complete, cloud-native data management strategy for scaling Snowflake Data Cloud analytics and applications.
With this announcement, Informatica customers can combine the benefits of Java UDF with the benefits and strengths of Informatica Intelligent Data Management Cloud while they continue to use a single, unified data integration platform.
Developers can invoke their custom code from within the data integration pipeline, incorporate it into a single end-to-end flow and push it to be executed in Snowflake Data Cloud, close to their data. When large data volumes are involved, you can get significant performance gain by pushing the computation and processing close to the data.
Whether it is Java code that holds a proprietary, complex price calculation or your custom data quality and data validation logic that is too complex to achieve in SQL, you can now wrap it as a Java UDF and have it invoked from within your data integration pipeline as a simple function.
Customers can use the JavaScript UDF in a few ways:
JavaScript UDF code is executed as an integral part of the end-to-end mapping and is pushed to Snowflake Data Cloud for execution.
With this announcement, customers can now:
Informatica is excited to support Snowflake’s Java UDF. Our combined solutions simplify the lives of data engineers and data scientists and bring more data pipelines into Snowflake Data Cloud.
Next Steps
Jun 22, 2022
Jun 22, 2022