CockroachDB Connector

Extract CockroachDB tables with full refresh or cursor-based incremental sync. Supports read-only SQL access, SSL mode, and optional incremental lookback.

SourceCommunity

Start Free View Documentation

Evaluating against Fivetran? See how Supaflow handles CockroachDB pricing, connector quality, and Snowflake deployment side-by-side.

Supaflow vs Fivetran

Why Supaflow

All connectors included

Every connector is available on every plan. Pricing does not increase with connector count.

Pay for compute, not rows

Credit-based pricing. Usage scales with your pipelines, not with row counts.

One platform

Ingestion, dbt Core transformation, reverse ETL, and orchestration in a single workspace.

Capabilities

Full Refresh and Incremental Sync

Use full refresh for smaller or static tables, or cursor-based incremental sync for tables with reliable date or timestamp columns. The connector does not use CockroachDB changefeeds or CDC.

Read-Only SQL Access

Connect with a dedicated CockroachDB SQL user and grant only the database, schema, and table privileges Supaflow needs to read selected tables.

SSL Mode and Network Configuration

Configure Host, Port, Database Name, User, Password, and SSL Mode. The connector supports disable, allow, prefer, require, verify-ca, and verify-full, with prefer as the default.

Incremental Lookback Window

Configure a lookback period up to 24 hours so incremental syncs re-read a short window before the previous cursor position when writes can arrive out of order.

Supported Objects

Database Objects

Tables

Tables in the configured CockroachDB database that the connecting user has SELECT permission on.

How It Works

Prepare CockroachDB access

Create a dedicated read-only SQL user with CONNECT on the database, USAGE on the schema, and SELECT on the tables you want to sync. If your cluster restricts inbound access, allow Supaflow IP 18.214.240.61 or use your approved private network path.

Enter connection details

Provide the CockroachDB host, port (default 26257), database name, user, password, and SSL Mode. The default SSL Mode is prefer; use disable only for insecure local or development clusters.

Choose sync behavior

Select tables in your pipeline and use full refresh or cursor-based incremental sync. For incremental sync, choose a cursor column that advances when rows are inserted or updated.

Test and save

Click Test & Save to verify the connection. Supaflow discovers accessible tables and refreshes metadata according to the schema refresh interval.

Use Cases

CockroachDB analytics replication

Sync operational CockroachDB tables into your warehouse for analytics without running heavy reporting queries against production.

Multi-service database consolidation

Create separate CockroachDB sources for service-owned databases and load selected tables into one analytics environment.

Incremental warehouse updates

Use cursor-based incremental sync for large tables that have reliable updated-at style columns.

Frequently Asked Questions

Does the CockroachDB connector support changefeeds or CDC?

No. The CockroachDB connector supports full refresh and cursor-based incremental sync. It does not read CockroachDB changefeeds and does not detect hard deletes from the source.

Can one source sync multiple CockroachDB databases?

No. Each CockroachDB source is configured for one database. Create another source for each additional database you want to sync.

Can I sync CockroachDB views?

The current connector discovers tables in the configured database. Views are not exposed as supported objects on this source page.

How are CockroachDB schemas represented?

When CockroachDB reports a schema, Supaflow includes it in the object namespace. Objects are qualified as database.schema.table when a schema is present.

Which cursor columns can I use for incremental sync?

Use a reliable date or timestamp column that advances when rows are inserted or updated. Tables without a reliable cursor column should use full refresh.

Which SSL modes are supported?

The source accepts disable, allow, prefer, require, verify-ca, and verify-full. The default is prefer. Use disable only for insecure local or development clusters.

Do I need to whitelist an IP address?

If your CockroachDB cluster restricts inbound connections, allow Supaflow IP 18.214.240.61 or connect through your approved private network path.

What happens with late-arriving updates?

Use the optional lookback period to re-read a short window before the previous cursor position. This can capture rows written slightly out of order, but the cursor column still needs to be reliable.