Connect DataDatabases
CrateDB
You connect CrateDB from the DataSquares connection wizard. CrateDB native HTTP /_sql (port 4200) — distributed SQL; information_schema discovery.
-
In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.
-
Pick CrateDB on that page (search or browse by category).
-
Fill in the connection details below, then test the connection and save.
Connection details
Section titled “Connection details”| Field | What to enter |
|---|---|
| Host | The hostname or IP address of your CrateDB server. |
| Port | Prefilled with 4200 (the CrateDB default) — change it if your server listens elsewhere. |
| Database | The database to connect to. |
| Username / Password | Credentials for a user with read access to the tables you want to analyze. |
| TLS | On by default: Use SSL/TLS encryption connects encrypted and verifies the server certificate. Tick Trust self-signed certificate for a private CA; turn TLS off only for a server that has none. |
Grant the connection user read-only access — DataSquares only ever reads from your source.
Related
Section titled “Related”- Connector catalog — everything DataSquares connects to.
- Quickstart — from connection to shared dashboard.