Snowflake

Connect to Snowflake

To connect to your Snowflake account to make use of your data and models, consider the following instructions:

1. In the Gene Mutation AI menu, click Snowflake.
2. In the Snowflake account box, enter your account identifier.
3. In the Username box, enter your username.
4. In the Password box, enter your password.
5. Click Connect.
   Note

   • Right after connecting to your Snowflake account, you will be required to define a default Snowflake warehouse, DB, schema, and stage.
   • When selecting a Snowflake warehouse, DB, schema, and stage in the following steps, the items in the lists will be based on the user's Snowflake account access privileges.
6. In the Snowflake warehouse list, search or select a warehouse.
7. In the Snowflake database list, search or select a database.
8. In the Snowflake schema list, search or select a shema.
9. In the Snowflake stage list, search or select a stage.
10. Click Submit.

Disconnect from Snowflake

To disconet from your Snowflake account:

1. In the Gene Mutation AI menu, click Snowflake.
2. Click Disconnect.

Change default Snowflake warehouse, DB, schema, and stage

After connecting to Snowflake and defining a default Snowflake warehouse, DB, schema, and stage, you can change the default values as follows:

1. In the Gene Mutation AI menu, click Snowflake.
2. Click Click here to select warehouse.
3. In the Snowflake warehouse list, search or select a warehouse.
4. In the Snowflake database list, search or select a database.
5. In the Snowflake schema list, search or select a shema.
6. In the Snowflake stage list, search or select a stage.
7. Click Submit.

Tabs

After successfully connecting to Snowflake and defining a default Snowflake warehouse, DB, schema, and stage, the following tabs are available on the Snowflake page:

• Explore
• Models
• Resources

Explore

The Explore tab will display all the tables available in the default database.

View Snowflake table

To view a Snowflake table consider the following instructions:

1. Connect to Snowflake.
   Note

   • To learn how to connect to Snowflake, see Connect to Snowflake.
   • While connecting to Snowflake, remember to select the correct warehouse containing the table you want to view.
2. On the Snowflake page, click the name of the Snowflake table you want to view.

Import Snowflake table

To make a Snowflake table (dataset) available for predictions, you need to import the table. To import a Snowflake table:

1. Connect to Snowflake.
   Note

   • To learn how to connect to Snowflake, see Connect to Snowflake.
   • While connecting to Snowflake, remember to select the correct warehouse containing the table you want to import.
2. On the Snowflake page, click the name of the Snowflake table you want to import.
3. Click Select complete table.

Models

The Models tab will display all the models available in the default warehouse.

The execution of these models to generate predictions (prognoses) occur within the Snowflake environment. The execution of these models in Snowflake contains scoring data while enabling the use of the scalability of the warehouse to reduce the time to score patients as the solution scales with the warehouse.

Note

These models refer to models built in H2O Driverless AI.

If you don't want to use one of the available models in the default Snowflake stage, you can upload a new model. To learn more, see Upload model.

Resources

The Resources tab enables you to access dynamically created artifacts (e.g., a Jupyter Notebook) from particular Snowflake models.

Artifacts

Available artifacts for a particular Snowflake model are as follows:

• Snowflake_Data_MarketPlace.scala
• Snowflake.ipynb
• Snowflake.sql
• Snowflake.udf
• Snowpark.DriverlessAI.ipynb
• Snowpark_Python_native.py
• Snowpark_Score.scala
• Snowpark.scala
• Snowsql
• GeneMutation_table_preperation.py

Download artifacts

You can download all generated artifacts for a particular Snowflake model one by one. To download an artifact from a particular Snowflake model:

1. Connect to Snowflake.
   Note

   • To learn how to connect to Snowflake, see Connect to Snowflake.
   • While connecting to Snowflake, remember to select the correct warehouse containing the model you want to download its artifacts.
2. On the Snowflake page, click the Resources tab.
3. In the Snowflake models list, select the model you want to download its artifacts.
4. Click List resources.
5. In the Resource type list, select an artifact.
   Note

   To learn about available model artifacts, see Artifcts.

6. Click Get data.

---

Feedback

• Submit and view feedback for this page
• Send feedback about H2O Health to cloud-feedback@h2o.ai