intermix.io connects to your Amazon Redshift cluster to collect event data. The intermix.io user will not have permission to see any of the data you have copied into your Amazon Redshift cluster. We only require access to see certain system logging tables, and the catalog which provides names and statistics on your tables (table metadata).
Run the following three commands (as an administrator) to create a user with the correct permission.
Please be sure that you are connected to the DEV database.
CREATE USER intermix PASSWORD '<your_password>' SYSLOG ACCESS UNRESTRICTED;
GRANT SELECT ON ALL TABLES IN SCHEMA pg_catalog to intermix;