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

A Brief Overview of AI Governance for Responsible Machine Learning Systems

Our paper “A Brief Overview of AI Governance for Responsible Machine Learning Systems” was recently

November 30, 2022 - by Navdeep Gill, Abhishek Mathur and Marcos V. Conde
H2O World Dallas Customer Talks

After three long years of not having an #H2OWorld, we finally held our first one

November 24, 2022 - by Vinod Iyengar
New in Wave 0.24.0

Another Wave release has arrived with quite a few exciting new features. Let's quickly go

November 21, 2022 - by Martin Turoci
Fallback Featured Image
H2O.ai Raises $40 Million to Democratize Artificial Intelligence for the Enterprise

Series C round led by Wells Fargo and NVIDIA MOUNTAIN VIEW, CA – November 30, 2017

November 20, 2022 - by
H2O.ai Placed Furthest in Completeness of Vision in 2021 Gartner Data Science and Machine Learning Magic Quadrant in the Visionaries Quadrant. — Copy

At H2O.ai, our mission is to democratize AI, and we believe driving value from data

November 18, 2022 - by Read Maloney, SVP of Marketing
H2O.ai Expands Market Footprint in Healthcare AI by Signing Hackensack Meridian Health and Other Key Providers

We’re excited to attend the HLTH conference this week in Las Vegas, NV. This industry

November 14, 2022 - by Prashant Natarajan

Start Your Free Trial