Aginity is a software that is used to connect to a Pivotal Greenplum database to execute queries.
A new schema was created by running the following queries:
create schema stg authorization dw_grp;
grant all on schema stg to dw_grp
grant all on schema stg to sbrady
After creating a new schema, users (sbrady) were still not able to see it in the Aginity view
Aginity doesn't show empty schema by default
Add an empty table to the schema
Change the Aginity preferences (Check the Aginity Administrator Guide for more information).