CockroachDB

​

Overview

​

Prerequisites

​

General

• CockroachDB version v1.15.x or later.
• Allow Zenskar to connect to your CockroachDB host.

​

Create a dedicated read-only user in CockroachDB (recommended)

-- Create a dedicated Zenskar user
CREATE USER zenskar PASSWORD 'your_password_here';

-- Grant access to the required schema
GRANT USAGE ON SCHEMA <schema_name> TO zenskar;

-- Grant read-only access to all tables in the schema
GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO zenskar;

-- Ensure future tables in the schema are also readable
ALTER DEFAULT PRIVILEGES IN SCHEMA <schema_name> GRANT SELECT ON TABLES TO zenskar;

If you need access across multiple schemas, repeat the grants for each schema.

​

Set up a CockroachDB data-source connector via Zenskar dashboard

1. Log into your Zenskar dashboard.
2. In the left side bar, click Usage > Data Sources.
3. In the top-right corner, click + ADD DATA SOURCE.
4. On the Add New Data Source page, configure the CockroachDB connector.
5. Click on the SAVE SOURCE button.

​

Connector configuration

​

General configuration

​

Connector configuration

​

Data source access mode (read-only)

• Ideal for small-mid size database (less than 30GB).
• Ideal for periodical data ingestion.
• Optimized for quicker invoice generation.