Have installed AppSmith on AWS. Have successfully connected to the DB
However when I try to then use the DB to actually do a query it says it cant see the tables.
When I connect using a DB query tool, I can see the 3 different schemas. The one I care about is called “dbo”
Is there anything special I need to do to specify a schema in the connection
- AppSmith hosted on AWS (self hosted)
- All networking connections are confirmed to work and connect as expected
- Trying to connect to Postgres DB (RDS Postgres)