PostgreSQL (or Panoply)
Before you start
Please make sure you allow Narrator to connect to your warehouse:
- Automated Setup (recommended): Connect your warehouse using an Admin Database User and Narrator will create a new user and grant itself access
- Manual Setup: You create a new user and you manage its access
Enter the connection details
- HOST: narrator-client.cohenxbcpk4g.us-east-1.redshift.amazonaws.com
- PORT: 5439
- WAREHOUSE: data_warehouse
Follow the Automated or Manual Setup then hit
Test and Save
Simply connect your warehouse using an admin database user.
Then, Narrator will automatically...
- Create a normal user for Narrator
- Create a group called
- Add the new narrator user to the group
- Grant create access to all the new narrator user to create schemas and tables
- Alter the default privileges to make sure any table created by narrator grants access to the entire group
- Go through each schema in your warehouse and grant the narrator user
USAGEon the schema and
SELECTon every table.
You can do all this yourself by going through the manual setup
Run the SQL below to create a user, substituting your own password
CREATE USER narrator_user password 'insert_generated_password'
Create a group and add
narrator_user to the group, This allows WLM and permissions to be managed easier. You can do this by running the SQL below.
CREATE GROUP narrator; ALTER GROUP narrator add user narrator_user;
Grant create access. This allows Narrator to create schemas and tables.
-- grant access to create on their database GRANT CREATE ON DATABASE INSERT_WAREHOUSE_NAME_HERE TO narrator_user;
(Optional) Give yourself and any group access to anything Narrator creates. This is recommended.
-- Alter the default group access ALTER DEFAULT PRIVILEGES for user narrator_user GRANT SELECT ON tables to group narrator, group INSERT_COMMON_GROUPS_HERE
Common groups are your analyst group or BI group
Get all the schema grant queries
select 'GRANT USAGE on schema ' || nspname || ' to group narrator; GRANT SELECT ON ALL TABLES in schema ' || nspname || ' to group narrator;' as query from pg_namespace where nspname not ilike 'pg_%' order by nspname asc
Run the Grant statements from the above query for all the schemas you want Narrator to be able to read from.
GRANT USAGE on schema INSERT_SCHEMA_NAME_HERE to group narrator; GRANT SELECT ON ALL TABLES in schema INSERT_SCHEMA_NAME_HERE to group narrator;
Connect your warehouse using the user and password that you just created.
Our data team is here to help! Here are a couple ways to get in touch...
💬 Chat us from within Narrator
💌 Email us at [email protected]
Updated 9 months ago