June 3rd, 2022

Improving Manufacturing Quality with H2O.ai and Snowflake

RSS icon RSS Category: Cloud, Computer Vision, H2O AI Cloud, Machine Learning, Manufacturing, Snowflake

Manufacturers are rapidly expanding their machine learning use cases by leveraging the deep integration between Snowflake’s Data Cloud and the H2O AI Cloud

Many current manufacturing quality checks require that sensor data and image data be processed and analyzed separately. Standard tooling presents challenges in storing and referencing these data types together. Often, comparison on sensor metrics can be automated as the data is represented as numeric values. But images often required a separate, and sometimes manual,  process for analysis.

With new integration capabilities between Snowflake and H2O.ai, sensor data and images stored in the Snowflake Data Cloud can now be used by H2O.ai models directly in a SQL statement. This enables fast, consistent validation of the manufacturing components being analyzed in near real time. Additionally, since H2O machine learning predictions are available using standard SQL, any application or downstream manufacturing tooling can also access model predictions.

Combining both sensor and image data has been shown to improve overall product quality, leading to reduced manufacturing costs, increased operational efficiencies and a better customer experience.


 Quality Improvements with Machine Learning

Getting a prediction on an image is as simple as writing a SQL statement, as H2O models can be used as SQL functions.  And because H2O models are available via a SQL function, any application that uses Snowflake as the system of record can leverage this new powerful combination.

Including images along with traditional numerical and string data significantly elevates real-time inferencing. The above SQL uses an image stored in the Snowflake Stage table and passes a presigned URL to the scoring function so the image can be accessed by the scorer. The image is then processed and scored, with the resulting prediction returned to Snowflake. This diagram shows how simple it is to put these new capabilities to use. 

Images are initially captured as components leave the assembly line and stored in a Snowflake Stage table. Using the H2O model, a SQL command then runs predictions on the images and other sensor data. These predictions are available to flow directly back to the assembly line or be consumed by process control applications that reflect analysis of the manufacturing process.

This application is not limited to manufacturing. Adding images to your machine learning scoring have benefits across all industries from healthcare to insurance and construction.

Find out more about Snowflake and H2O.ai’s partnership at www.h2o.ai/snowflake.

About the Author

Eric Gudgion
Eric Gudgion

Eric is a Senior Principal Solutions Architect, he is passionate about performance and scalability. Eric’s role enables him to help customers adopt h2o within their enterprises.

Leave a Reply

Recap of H2O World India 2023: Advancements in AI and Insights from Industry Leaders

On April 19th, the H2O World  made its debut in India, marking yet another milestone

May 29, 2023 - by Parul Pandey
Enhancing H2O Model Validation App with h2oGPT Integration

As machine learning practitioners, we’re always on the lookout for innovative ways to streamline and

May 17, 2023 - by Parul Pandey
Building a Manufacturing Product Defect Classification Model and Application using H2O Hydrogen Torch, H2O MLOps, and H2O Wave

Primary Authors: Nishaanthini Gnanavel and Genevieve Richards Effective product quality control is of utmost importance in

May 15, 2023 - by Shivam Bansal
AI for Good hackathon
Insights from AI for Good Hackathon: Using Machine Learning to Tackle Pollution

At H2O.ai, we believe technology can be a force for good, and we're committed to

May 10, 2023 - by Parul Pandey and Shivam Bansal
H2O democratizing LLMs
Democratization of LLMs

Every organization needs to own its GPT as simply as we need to own our

May 8, 2023 - by Sri Ambati
h2oGPT blog header
Building the World’s Best Open-Source Large Language Model: H2O.ai’s Journey

At H2O.ai, we pride ourselves on developing world-class Machine Learning, Deep Learning, and AI platforms.

May 3, 2023 - by Arno Candel

Request a Demo

Explore how to Make, Operate and Innovate with the H2O AI Cloud today

Learn More