Machine Learning Model DDL

The following DDL commands are used to create, view, and manage machine-learning models and their versions.

A model is a schema-level object that contains a machine learning model that has been trained and stored in the Snowpark ML Registry. Model commands let you create and manage models in SQL. You can also create and manage models in Python using the Snowpark ML Registry API.

Machine Learning Models

CREATE MODEL

Creates a new machine learning model in the current/specified schema or replaces an existing model.

ALTER MODEL

Modifies the properties for an existing model, including its name, tags, default version, or comment.

SHOW MODELS

Lists the machine learning models that you have privileges to access.

DROP MODEL

Removes a machine learning model from the current/specified schema.

Machine Learning Model Versions

ALTER MODEL … ADD VERSION

Adds a new version to an existing model from an internal stage.

ALTER MODEL … MODIFY VERSION

Modifies a version of a model, changing the version’s comment or metadata.

SHOW VERSIONS IN MODEL

Lists the versions in a machine learning model.