Skip to main content

model_registry_model_versions

Creates, updates, deletes, gets or lists a model_registry_model_versions resource.

Overview

Namemodel_registry_model_versions
TypeResource
Iddatabricks_workspace.ml.model_registry_model_versions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
model_versionobject

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectname, version, deployment_nameGet a model version.
searchselectdeployment_namefilter, max_results, order_by, page_tokenSearches for specific model versions based on the supplied filter.
createinsertdeployment_name, name, sourceCreates a model version.
updateupdatedeployment_name, name, versionUpdates the model version.
deleteexecname, version, deployment_nameDeletes a model version.
delete_tagexecname, version, key, deployment_nameDeletes a model version tag.
get_latestexecdeployment_name, nameGets the latest version of a registered model.
set_tagexecdeployment_name, name, version, key, valueSets a model version tag.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
deployment_namestringThe Databricks Workspace Deployment Name (default: dbc-abcd0123-a1bc)
keystringName of the tag. The name must be an exact match; wild-card deletion is not supported. Maximum size is 250 bytes.
namestringName of the registered model that the tag was logged under.
versionstringModel version number that the tag was logged under.
filterstringString filter condition, like "name='my-model-name'". Must be a single boolean condition, with string values wrapped in single quotes.
max_resultsintegerMaximum number of models desired. Max threshold is 10K.
order_byarrayList of columns to be ordered by including model name, version, stage with an optional "DESC" or "ASC" annotation, where "ASC" is the default. Tiebreaks are done by latest stage transition timestamp, followed by name ASC, followed by version DESC.
page_tokenstringPagination token to go to next page based on previous search query.

SELECT examples

Get a model version.

SELECT
model_version
FROM databricks_workspace.ml.model_registry_model_versions
WHERE name = '{{ name }}' -- required
AND version = '{{ version }}' -- required
AND deployment_name = '{{ deployment_name }}' -- required
;

INSERT examples

Creates a model version.

INSERT INTO databricks_workspace.ml.model_registry_model_versions (
name,
source,
description,
run_id,
run_link,
tags,
deployment_name
)
SELECT
'{{ name }}' /* required */,
'{{ source }}' /* required */,
'{{ description }}',
'{{ run_id }}',
'{{ run_link }}',
'{{ tags }}',
'{{ deployment_name }}'
RETURNING
model_version
;

UPDATE examples

Updates the model version.

UPDATE databricks_workspace.ml.model_registry_model_versions
SET
name = '{{ name }}',
version = '{{ version }}',
description = '{{ description }}'
WHERE
deployment_name = '{{ deployment_name }}' --required
AND name = '{{ name }}' --required
AND version = '{{ version }}' --required
RETURNING
model_version;

Lifecycle Methods

Deletes a model version.

EXEC databricks_workspace.ml.model_registry_model_versions.delete 
@name='{{ name }}' --required,
@version='{{ version }}' --required,
@deployment_name='{{ deployment_name }}' --required
;