PostgreSQL

Supported Hosting Solutions

AWS RDS PostgreSQLAWS Aurora PostgreSQLPostgreSQL on-prem

Additional Information

Sync New Data Assets

If you create a new PostgreSQL schema in your database, we need you to re-grant our permissions.

To sync your new assets into Select Star, follow these steps:

1. GRANT us access to the new Schema:

GRANT USAGE ON SCHEMA <schema_name> TO selectstar;
GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO selectstar;
ALTER DEFAULT PRIVILEGES IN SCHEMA <schema_name> GRANT SELECT ON TABLES TO selectstar;

2. Go to Select Star > Settings > Data

3. Find your Data Source, and click on Configure

4. Click Refresh

5. Click Next, and make sure your new Schema is selected.

We are always happy to help if you have any other questions! Send us an email.