Setting up CockroachDB
1. Add integration
Select CockroachDB from the integrations page.
2. Configure settings
Fill out the form with the following settings:| Setting | Required | Description |
|---|---|---|
| Name | ✓ | Name that will be displayed to users when selecting this integration in Superblocks |
| Host | ✓ | Hostname or IP address to connect to |
| Port | ✓ | Port to use when connecting to CockroachDB |
| Database Name | ✓ | Name of database to connect to |
| Database Username | ✓ | Username to use to connect |
| Database Password | ✓ | Password for database username |
| Enable SSL | ✗ | Connect via SSL if selected |
| Use a self-signed SSL certificate | ✗ | Provide Server CA, Client Key, and Client Cert if selected |
3. Test and save
Click Test Connection to check that Superblocks can connect to the data source.If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for Hybrid or Cloud-Prem deployments).
4. Set profiles
Optionally, configure different profiles for separate development environments.CockroachDB connected!
Now you can use CockroachDB in any Application, Workflow, or Scheduled Job.
Now you can use CockroachDB in any Application, Workflow, or Scheduled Job.
Creating CockroachDB steps
Connect to your CockroachDB integration from Superblocks by creating steps in Application APIs, Workflows and Scheduled Jobs. You can configure a Superblocks CockroachDB integration with read only, read/write, or write only users. You can then configure a Superblocks CockroachDB step to read from a database, as well as modify/delete data. To get started, enter your SQL query into the text area of the CockroachDB step. Then click “Run” to see the Result and Executed SQL statement below.