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.

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

​

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.