Introduction

Kubit enables direct access to your Amazon Redshift cluster, ensuring secure and controlled data interaction.

• Configure your Redshift for public accessibility while maintaining access control.
• Ensure the associated Security Group allows port 5439 access to the Kubit IP ranges.

Grant Access

1. Create a New User
   In your sharing database, create a user for Kubit. Ensure compliance with password requirements:

   SQL

   CREATE USER kubit WITH PASSWORD '<password>';

2. Grant Permissions
   Allow the Kubit user to access your data:

   SQL

   GRANT SELECT ON ALL TABLES IN SCHEMA public TO kubit;

3. Limit Access (Optional)
   Restrict access to specific tables or views if needed:

   SQL

   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;