CrateDB
by Crate.io
Distributed SQL database for real-time analytics on time-series and document data, with an HTTP endpoint for SQL.
- Category
- Cloud & Data Platforms
- Type
- Real-time analytics database
- Interface
- REST API
- Built with
- Connect Any API
- Credentials
- Username and password, Signed JWT
- Docs
- CrateDB API docs
02Data
What you can sync.
- Sql query results
- Tables
- Schemas
Load CrateDB sql query results into your Lake and model it in the Warehouse with the rest of your stack.
Need more? Name any other CrateDB data the API returns, and the AI adds it to the connector.
03Credentials
Credentials you will need.
- A username and password
- A signed JWT
CrateDB uses a username and password or a signed JWT. You add the credentials once, when the AI asks for them, and it tells you where to create them in Crate.io if you need help.
04How it works
How it works in DataMind.
-
Pick CrateDB.
Open Lake, pick CrateDB in the source picker and name the connection. Connect Any API opens with a ready prompt that points the AI at the CrateDB API docs.
-
Answer a few questions.
The AI reads the CrateDB 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.
It builds the connector, tests it and shows you sample rows. Then CrateDB data loads into your Lake on your schedule, ready for the Warehouse, DataPrism BI and AI Minds.
05Related
