CREATE DATASOURCE demo
WITH
engine='postgres',
parameters={
"user":"user_name",
"port": 3307,
"password": "password",
"host": "127.0.0.1",
"database": "postgres"
};
SELECT * FROM demo.airline_passenger_satisfaction LIMIT 100;
CREATE PREDICTOR satisfaction_model_v1
FROM demo
(SELECT * FROM public.airline_passenger_satisfaction LIMIT 1000)
PREDICT satisfaction;
SELECT * FROM mindsdb.predictors WHERE name='satisfaction_model_v1';
DESCRIBE satisfaction_model_v1;
DESCRIBE satisfaction_model_v1.features;
SELECT satisfaction, satisfaction_confidence, satisfaction_explain
FROM mindsdb.satisfaction_model_1
WHERE age=47 AND Class='Business' AND gender='Male';