CockroachDB
by Cockroach Labs
Distributed SQL database compatible with the PostgreSQL wire protocol, self-hosted or as CockroachDB Cloud; read with SQL drivers.
- Category
- Cloud & Data Platforms
- Type
- Database
- Interface
- database interface
- Built with
- Connect Anything
- Credentials
- Username and password, Vendor credentials
02Data
What you can sync.
- Sql query results
- Tables
- Changefeeds
Load CockroachDB sql query results into your Lake and model it in the Warehouse with the rest of your stack.
Need more? Name any other CockroachDB data the API returns, and the AI adds it to the connector.
03Credentials
Credentials you will need.
- A username and password
- Other credentials
CockroachDB uses a username and password or other credentials. You add the credentials once, when the AI asks for them, and it tells you where to create them in Cockroach Labs if you need help.
04How it works
How it works in DataMind.
-
Pick CockroachDB.
Open Lake, pick CockroachDB in the source picker and name the connection. Connect Anything opens with a ready prompt that points the AI at the CockroachDB API docs.
-
Answer a few questions.
The AI reads the CockroachDB documentation, then asks which credentials you will use, which data to sync (for example sql query results and tables), whether you want a one-time load or a recurring sync, and which accounts or filters apply.
-
Your data lands in Lake.
The connector agent writes a Python connector for CockroachDB, tests it against the live API and shows you sample rows. Then the data loads into your Lake on your schedule, ready for the Warehouse, DataPrism BI and AI Minds.
