I am connecting to an RDS with my root user, that has permissions to access any schema in that RDS, but the RDS connection setup dialog is asking for a specific schema.
I would like to be able not to input any schema, and just have a general RDS connection that will allow me to use any custom SQL query, for one or many schema in that RDS.
Hope I was more clear about what I am looking for.
I setup an RDS to a specific DB schema, with a root user that have access to all schema in that RDS (DB)
and created a SQL query that is doing UNION of several schema… and it worked