How to Persist Predictions

MindsDB provides a range of options for persisting predictions and forecasts. Let's explore all possibilities to save the prediction results.

Every time you want to get predictions, you need to query the model, usually joined with an input data table, like this:

SELECT input.product_name, input.review, output.sentiment
FROM mysql_demo_db.amazon_reviews AS input
JOIN sentiment_classifier AS output;

However, querying the model returns the result set that is not persistent by default. For future use, it is recommended to persist the result set instead of querying the model again with the same data.

MindsDB enables you to save predictions into a view or a table or download as a CSV file. </Note>

Creating a View

After creating the model, you can save the prediction results into a view.

CREATE VIEW review_sentiment (

    -- querying for predictions
    SELECT input.product_name, input.review, output.sentiment
    FROM mysql_demo_db.amazon_reviews AS input
    JOIN sentiment_classifier AS output
    LIMIT 10

);

Now the review_sentiment view stores sentiment predictions made for all customer reviews.

Creating a Table

After creating the model, you can save predictions into a database table.

CREATE TABLE local_postgres.question_answers (

    -- querying for predictions
    SELECT input.article_title, input.question, output.answer
    FROM mysql_demo_db.questions AS input
    JOIN question_answering_model AS output
    LIMIT 10

);

Here, the local_postgres database is a PostgreSQL database connected to MindsDB with a user that has the write access.

Now the question_answers table stores all prediction results.

Downloading a CSV File

After executing the SELECT statement, you can download the output as a CSV file.

Click the Export button and choose the CSV option.