CockroachDB

​

Current connection form

• Connection Name
• Host
• Port
• Database
• Username
• Password
• Port defaults to 26257.
• Database defaults to defaultdb in the current form.
• Use the builder to set the final Schema, Table, and Write mode.

​

Good first use cases

• distributed SQL read models
• application-facing tables in CockroachDB
• operational marts that should stay close to product infrastructure

​

Before you connect

• Create a write-capable SQL user for the target cluster and database.
• Confirm the exact cluster endpoint and target database.
• Start with one table that downstream users can validate quickly.

​

Step by step

1. Open Connections and click + New Connection.
2. Set the role to Destination and choose CockroachDB.
3. Fill the form with real values, for example:
   • Connection Name: Cockroach Reporting
   • Host: northstar-cluster.aws-us-east-1.cockroachlabs.cloud
   • Port: 26257
   • Database: defaultdb
   • Username: mf_writer
4. Click Test Connection and save the connection after the test succeeds.
5. In the builder’s Destination panel, configure:
   • Connection: Cockroach Reporting
   • Schema: analytics
   • Table: customer_orders
   • Write mode: Upsert
6. Save the pipeline and run one manual sync before enabling a schedule.

​

Real-world example

​

Troubleshooting

• If the connection test fails, verify the cluster endpoint, port, and SQL credentials.
• If validation fails in the builder, double-check the target schema and table naming.
• Run the first pipeline manually and inspect the destination rows before scheduling automated writes.