Skip to main content

model_transition_requests

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

Overview

Namemodel_transition_requests
TypeResource
Iddatabricks_workspace.machinelearning.model_transition_requests

Fields

The following fields are returned by SELECT queries:

Fetched all open requests successfully.

NameDatatypeDescription
idstring
user_idstring
activity_typestring
commentstring
creation_timestampinteger
from_stagestring
last_updated_timestampinteger
system_commentstring
to_stagestring

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listtransitionrequestsselectdeployment_nameGets a list of all open stage transition requests for the model version.
createtransitionrequestinsertdeployment_nameCreates a model version stage transition request.
deletetransitionrequestdeletedeployment_nameCancels a model version stage transition request.
approvetransitionrequestexecdeployment_nameApproves a model version stage transition request.
rejecttransitionrequestexecdeployment_nameRejects a model version stage transition request.
transitionstageexecdeployment_nameTransition a model version's stage. This is a Databricks workspace version of the

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)

SELECT examples

Gets a list of all open stage transition requests for the model version.

SELECT
id,
user_id,
activity_type,
comment,
creation_timestamp,
from_stage,
last_updated_timestamp,
system_comment,
to_stage
FROM databricks_workspace.machinelearning.model_transition_requests
WHERE deployment_name = '{{ deployment_name }}' -- required;

INSERT examples

Creates a model version stage transition request.

INSERT INTO databricks_workspace.machinelearning.model_transition_requests (
data__name,
data__version,
data__stage,
data__comment,
deployment_name
)
SELECT
'{{ name }}',
'{{ version }}',
'{{ stage }}',
'{{ comment }}',
'{{ deployment_name }}'
RETURNING
request
;

DELETE examples

Cancels a model version stage transition request.

DELETE FROM databricks_workspace.machinelearning.model_transition_requests
WHERE deployment_name = '{{ deployment_name }}' --required;

Lifecycle Methods

Approves a model version stage transition request.

EXEC databricks_workspace.machinelearning.model_transition_requests.approvetransitionrequest 
@deployment_name='{{ deployment_name }}' --required
@@json=
'{
"name": "{{ name }}",
"version": "{{ version }}",
"stage": "{{ stage }}",
"archive_existing_versions": "{{ archive_existing_versions }}",
"comment": "{{ comment }}"
}';