MindsDB provides a range of options for persisting predictions and forecasts. Let’s explore all possibilities to save the prediction results.
Reasons to Save Predictions
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.
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 );
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 );
local_postgres database is a PostgreSQL database connected to MindsDB with a user that has the write access.
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.
Export button and choose the