Pivotal Knowledge Base

Follow

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

Problem

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 new schema, users (sbrady) were still not able to see it in the Aginity view

Cause

Aginity doesn't show empty schema by default

Solution

Add an empty table to the schema

- OR -

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

 

 

Comments

Powered by Zendesk