I'm attempting to provision self hosted Retool on AWS with an external RDS database. I've created the five environment variables to provide credentials and connection info, and I intend Retool to use a database I've created on the instance like retool and a schema within that db, also called retool. When the ECS service starts and migration is attempted, it fails with:
Error running database migrations: MigrationError: Migration 20170801051119-add-ssl-column-to-resources.js (up) failed: Original error: relation "public.resources" does not exist
The table resources does exist in the schema I'd like retool to use, but not in public, which I don't want to be used.
How can I ensure Retool uses the schema? The created db user is also named retool.