Connection Information and Examples
After configuring a network path, use the Connection Info panel and Connection Examples popover to connect an application to the warehouse. Both are on the warehouse's Connection page.
Connection information
The Connection Info panel shows the details your applications need to connect to the warehouse.
| Field | Description |
|---|---|
| Warehouse ID | Unique identifier for the warehouse. |
| Domain / IP | Hostname or IP address for MySQL and HTTP connections. |
| MySQL Protocol Port | Default: 9030. |
| HTTP Protocol Port | Default: 8080. |
| Username | Warehouse username. The default admin user is admin. |
| Password | Warehouse password. Click the edit icon to reset it. |
Connection examples
VeloDB Cloud uses the MySQL network protocol and is compatible with MySQL command-line tools, JDBC and ODBC drivers, and data visualization tools.
MySQL client
mysql -h <host> -P <port> -u <username> -p
JDBC
jdbc:mysql://<host>:<port>/<database>?user=<username>&password=<password>
If the warehouse has multiple clusters, route to a specific cluster by appending @<cluster_name> to the database name:
jdbc:mysql://<host>:<port>/<database>@<cluster>?user=<username>&password=<password>
HTTP Stream Load
curl --location-trusted -u <username>:<password> \
-H "label:<load-label>" \
-H "column_separator:," \
-T data.csv \
http://<host>:<port>/api/<database>/<table>/_stream_load
To target a specific cluster, add the cloud_cluster header:
-H "cloud_cluster:<cluster>"
For the exact host and port, use the Connection Examples popover on the Connection page.