Automated deployment and replacement of Scoring Code in Snowflake¶

Create a DataRobot-managed Snowflake prediction environment to deploy DataRobot Scoring Code in Snowflake. With DataRobot management enabled, the external Snowflake deployment has access to MLOps management, including automatic Scoring Code replacement.

Create a Snowflake prediction environment¶

To deploy a model in Snowflake, first create a custom Snowflake prediction environment:

1. Open the Console > Prediction environments page and click + Add prediction environment.

   

2. In the Add prediction environment dialog box, configure the prediction environment settings:

   

   • Enter a descriptive Name and an optional Description of the prediction environment.

   • Select Snowflake from the Platform dropdown.

   • Select theManaged by DataRobot option to allow this prediction environment to automatically package and deploy DataRobot Scoring Code models through the Management Agent.

   The Supported Model Formats settings are automatically set to DataRobot Scoring Code and can't be changed, as this is the only model format supported by Snowflake.

3. In the Management settings section, select a Data Connection and the related Credentials, and then select the Snowflake Schemas. Snowflake schemas are collections of Snowflake tables.

   

   Snowflake credentials required

   DataRobot management of Scoring Code in Snowflake requires an existing Data Connection to Snowflake with stored Credentials. If you don't have an existing Snowflake data connection, the No Data Connections found alert appears, directing you to Go to Data Connections to create a Snowflake connection.

   

4. After you configure the environment settings, click Add environment.

Deploy a model to the Snowflake prediction environment¶

Once you've created a Snowflake prediction environment, you can deploy a model to it:

1. On the Registry > Model directory page, in the table of registered models, click the registered model containing the version you want to deploy, opening the list of versions.

   Model support

   Snowflake prediction environments do not support models without Scoring Code support.

2. From the list of versions, click the Scoring Code enabled version you want to deploy, opening the registered model version panel.

   

3. In the upper-right corner of any tab in the registered model version panel, click Deploy.

   

4. In the Prediction history and service health settings, under Choose prediction environment, click Change.

   

5. In the Select prediction environment panel, click Snowflake, and then click the prediction environment you want to deploy to.

   

6. (Optional) Open the Advanced environment settings and define additional Environment key-value pairs to provide extra parameters to the Snowflake deployment interface.

7. Configure the remaining deployment settings, and then click Deploy model.

Once the model is deployed to Snowflake, you can use the code snippet from the Predictions > Portable predictions tab to score data in Snowflake.

Restart a Snowflake prediction environment¶

When you update database settings or credentials for the Snowflake data connection used by the prediction environment, restart the environment to apply those changes to the environment:

1. Click Deployments > Prediction environments page, and then select the Snowflake prediction environment from the list.

2. Below the prediction environment settings, under Service Account, click Restart Environment.