This guide describes how to connect Aporia to an PostgreSQL data source in order to monitor your ML Model in production.
We will assume that your model inputs, outputs and optionally delayed actuals can be queried with SQL. This data source may also be used to connect to your model's training set to be used as a baseline for model monitoring.
Create a read-only user for PostgreSQL access
In order to provide access to PostgreSQL, create a read-only user for Aporia in PostgreSQL.
Please use the SQL snippet below to create the user for Aporia. Before using the snippet, you will need to populate the following:
<aporia_password>: Strong password to be used by the user.
<your_database>: PostgreSQL database with your ML training / inference data.
<your_schema>: PostgreSQL schema with your ML training / inference data.
CREATEUSER aporia WITH PASSWORD '<aporia_password>';