Deploy Models
Manage Model Versions
Deploy Models
Manage Model Versions
Creating a Model
To create a model, use the CREATE MODEL statement.
CREATE MODEL mindsdb.home_rentals
FROM example_db
(SELECT * FROM demo_data.home_rentals)
PREDICT rental_price
USING engine = 'lightwood',
tag = 'my model';
Now, your model has one version. You can verify by querying the models_versions table.
SELECT *
FROM mindsdb.models_versions
WHERE name = 'home_rentals';
On execution, we get:
+------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+
|NAME |PROJECT|ACTIVE|VERSION|STATUS |ACCURACY|PREDICT |UPDATE_STATUS|MINDSDB_VERSION|ERROR |SELECT_DATA_QUERY |TRAINING_OPTIONS |TAG |
+------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+
|home_rentals|mindsdb|true |1 |complete|0.999 |rental_price|up_to_date |22.11.3.2 |[NULL]|SELECT * FROM demo_data.home_rentals|{'target': 'rental_price', 'using': {}}|my model|
+------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+
Retraining a Model
To retrain a model, use the RETRAIN statement.
RETRAIN mindsdb.home_rentals;
Let’s query for the model versions again.
SELECT *
FROM mindsdb.models_versions
WHERE name = 'home_rentals';
On execution, we get:
+------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+
|NAME |PROJECT|ACTIVE|VERSION|STATUS |ACCURACY|PREDICT |UPDATE_STATUS|MINDSDB_VERSION|ERROR |SELECT_DATA_QUERY |TRAINING_OPTIONS |TAG |
+------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+
|home_rentals|mindsdb|false |1 |complete|0.999 |rental_price|up_to_date |22.11.3.2 |[NULL]|SELECT * FROM demo_data.home_rentals|{'target': 'rental_price', 'using': {}}|my model|
|home_rentals|mindsdb|true |2 |complete|0.999 |rental_price|up_to_date |22.11.3.2 |[NULL]|SELECT * FROM demo_data.home_rentals|{'target': 'rental_price', 'using': {}}|my model|
+------------+-------+------+-------+--------+--------+------------+-------------+---------------+------+------------------------------------+---------------------------------------+--------+
Using Active Model Version
To use the currently active model version, run this query:
SELECT *
FROM mindsdb.home_rentals AS p
JOIN example_db.demo_data.home_rentals AS d;
Using Specific Model Version
To use a specific model version, even if it is set to inactive, run this query:
SELECT *
FROM mindsdb.home_rentals.1 AS p
JOIN example_db.demo_data.home_rentals AS d;
Setting Model Version as Active
To set a specific model version as active, run the UPDATE statement:
UPDATE mindsdb.models_versions
SET active = 1
WHERE version = 1
AND name = 'home_rentals';
Deleting Specific Model Version
To delete a specific model version, run the DELETE FROM statement:
DELETE FROM mindsdb.models_versions
WHERE version = 2
AND name = 'home_rentals';
Please note that you cannot delete the version that is active.
Deleting All Model Versions
To delete all models version, run the DROP MODEL statement:
DROP MODEL mindsdb.home_rentals;