Steps

1. Create a User

1. Go to the SQL Console
2. Create a user named KUBIT. The Kubit team will generate and share a strong password which you should use to create the user.

CREATE USER KUBIT IDENTIFIED WITH sha256_password BY '*****';

2. Create Roles

1. Create a role named KUBIT_R
   sql

   CREATE ROLE OR REPLACE KUBIT_R;

2. Create a role named KUBIT_W
   sql

   CREATE ROLE OR REPLACE KUBIT_W;

3. Set roles to user:
   sq

   GRANT KUBIT_R TO KUBIT;
   GRANT KUBIT_W TO KUBIT;

3. Create a Database

Create a database named KUBIT_DB

CREATE DATABASE KUBIT_DB;

4. Grant Permissions

1. Grant KUBIT_W the permissions to read and write from KUBIT_DB database. This will allow us to create any auxiliary tables or views there

GRANT SELECT,INSERT,ALTER,CREATE,DROP,TRUNCATE,SHOW,CLUSTER ON KUBIT_DB.* TO KUBIT_W;

2. Add read-only (SELECT) permissions to the KUBIT_R role to the intended tables/views and KUBIT_DB

GRANT SELECT ON KUBIT_DB TO KUBIT_R;
GRANT SELECT ON INFORMATION_SCHEMA.* TO KUBIT_R;
GRANT SELECT ON system.parts TO KUBIT_R;
GRANT SELECT ON table/view TO KUBIT_R;

5. Setup IP Whitelisting

Here's the list of Kubit's IP addresses to allow.

6. Setting up the connection in Kubit

When configuring the JDBC URL in Kubit you will need to pass on the &compress=0 parameter.