Skip to main content
Redshift

Integrate via Direct Connect

Updated over 2 months ago

Introduction

Kubit can access your data in Amazon Redshift cluster directly with restricted access.

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>';
  2. Grant the Kubit user permissions to access all of your data:

    GRANT SELECT on ALL TABLES IN SCHEMA public TO kubit;
  3. 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;

Did this answer your question?