Skip to main content

Tutorial 2A: Snowflake integration and Snowpark Container Services

The following tutorial guides you through the integration of H2O eScorer with Snowflake and Snowpark Container Services (SPCS).

Connect to Snowflake​

To connect to Snowflake, navigate to the SNOWFLAKE option on the tab above and enter your Snowflake credentials. For more information on how to connect to Snowflake, see Snowflake support: Connect to the Snowflake Connector.

Deploy a model​

  • You can deploy your own model or upload a pre-existing model for deployment. For more information on how to deploy a model, see Snowflake support: Deploy a model.
  • Once you have successfully deployed a model, the next step is to score the model.

Score a model​

  • To score your model, navigate to Score on the tab above and select the appropriate option for Deployment Type. For more information on how to score a model, see Snowflake support: Score a model.
  • Scoring your model should look similar to this: scoring

Worksheet​

  1. You can run Snowflake SQL queries in eScorer by navigating to Worksheet on the tab, and entering your query in the given space.

  2. Click Run Query. worksheet

Operation monitoring​

  • You can look at how your model has been deployed by navigating to the Operation Monitoring option on the tab. This gives you additional information on how your model is performing in regards to cost and latency inside of the Snowflake environment.
  • Within this dashboard, you choose between Java UDFs, Container Services, or External Functions.
  • After choosing your option, enter the Start Date, End Date, and Model.
  • Click Go, when you are ready to view the results. operation-monitoring
note

Click View on the Learn more: Java UDFs Monitoring pop-up on the top left corner to view more information on Java UDFs monitoring.

Feedback