Skip to main content

Connect to Vertica

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.

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 toggle between SQL mode for raw SQL statements or the GUI mode for structured writes.

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