Redshift

Integrate via Direct Cloud Access or S3 Storage Sharing

Overview

Kubit can access your data in Amazon Redshift cluster directly with restricted access, or through S3 storage sharing.  

728728

Grant Access

  1. Create a new user in sharing database. Please, consider password requirements while you’re generating the Kubit use password:
CREATE USER kubit WITH PASSWORD '<password>';
  1. Grant the Kubit user permissions to access all of your data:
GRANT SELECT on ALL TABLES IN SCHEMA public TO kubit;
  1. Or you can limit the access to specific tables or views:
GRANT USAGE ON SCHEMA public TO kubit;
GRANT SELECT ON TABLE public.table_1 TO kubit;
GRANT SELECT ON TABLE public.table_2 TO kubit;