CREATE DATABASE
CREATE DATABASE
statement, as below.
SELECT
SELECT
statement.
CREATE MODEL
CREATE MODEL
statement, as below.
SHOW MODELS
command as below.
complete
before you can start making predictions.SELECT
SELECT
statement allows you to make predictions based
on features, where features are the input variables, or input columns, that are
used to make forecasts.
Let’s predict what would be the rental price of a 1000 square feet house with
two bathrooms.
CREATE JOB
CREATE JOB
statement to create a Job.
Now, let’s use a Job to set the model we’ve created to be retrained every two days, just like we might in production. You can retrain the model to improve predictions every time when either new data or new MindsDB version is available. And, if you want to retrain your model considering only new data, then go for finetuning it.
In the same job, we will create a table and insert these new predictions back into a database so the predictions are ready to be used by our hypothetical application.
my_integration
is your database connection name in MindsDB. Before executing this job, make sure to connect your database to MindsDB with a user who has write access to be able to create a table.
And there you have it! You created an end-to-end automated production ML system in a few short minutes.