Issue with relationships not showing in a database and cannot be configured (web interface)

Thanks for all the details provided in private.

I’m following up with a public resolution.

It appears that the issue was caused by insufficient rights given to the database user accessing your data on behalf of the Forest Admin cloud agent.
Althought it dit have CRUD permission on all tables of the given schema it was lacking a specific permissions to list records in the information_schema.constraint_column_usage, which prevented the agent for properly detecting relationships.

The way postgre handles this is to only return records for which the user has rights, and unfortunately it does not throw any errors that we could catch and return, which means that the introspection failure was silent.
This may even be specific to the google cloud postgre implementation:

I’m currently looking for a way to catch and handle this error correctly so that it may be correctly returned by the Forest Admin agent and shown to the user.

I will follow up on this post if and when a fix is applied.

In the meantime, I would advise you to ensure that the user created to accessing the database has the rights to view all records in information_schema

:pray: