Welcome to Retool! We're a fast way to build custom internal software.

You'll find the 5 minute demo, quickstart guide, and documentation for each of our connectors and components here. If you've got any questions -- chat with us on the bottom right!

Get Started    Guides

Vertica Integration

Connecting Vertica to Retool

1. Get Vertica Details & Whitelist Retool IP Address

You can get your database connection details from whoever set up the database. You'll also need to get them to whitelist the Retool IP address:

2. Add to Retool

Create a new resource in Retool, and select "Vertica" as the type. Enter your database connection details.

We recommend setting up separate resources for read and write access to make it harder to accidentally cause unwanted changes to your database. When setting up a resource to write to your database, you can enable a simplified interface that can make standard SQL write queries to further reduce the chance of errors.

Resources > Add > Vertica

3. Create Queries

You can now select your newly-created Vertica resource from the Resource dropdown when creating queries in your Retool apps.

You can display the results of Vertica queries as with any other query in Retool:

Updated about a month ago

Vertica Integration

Connecting Vertica to Retool

Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.