Customer is not able to see an empty schema in Aginity Software

Products

• VMware Tanzu Greenplum

Issue/Introduction

Symptoms:

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.

Environment

Cause

Aginity does not show an empty schema by default.

Resolution

To resolve this issue, either:

1. Add an empty table to the schema.

2. Change the Aginity preferences (Check the Aginity Administrator Guide for more information).