Deprecation of the Vertica resource type
Retool is deprecating the dedicated Vertica resource type.
Retool will remove the resource type in Q1 2027, after two quarterly Stable releases. After removal, Vertica resources will stop working. Queries in apps and workflows that still point at those resources will fail. Retool will no longer ship the Vertica JDBC driver. Cloud organizations will not have a Vertica connection option after removal.
Self-hosted organizations can keep querying Vertica after removal by creating a JDBC resource and adding a Vertica JDBC driver that you provide. Retool will not migrate Vertica resources or their query references automatically.
- Download the Vertica JDBC driver from Vertica.
- Add the
.jarfile to your self-hosted instance. Follow the JDBC configuration steps forJDBC_DIRECTORY_PATH. - Create a JDBC resource with Driver name
com.vertica.jdbc.Driver, connection stringjdbc:vertica://HOSTNAME:5433/DATABASE?user=USERNAME&password=PASSWORD&DisableCopyLocal=true, and schema queryselect table_name, column_name, data_type, table_schema from columns. IncludeDisableCopyLocal=trueon the connection string. - Open each app and workflow query that uses the Vertica resource. Change the query to use the new JDBC resource, then test it.
JDBC resources do not support Retool-managed SSH tunnels. If your Vertica resource uses an SSH tunnel, or you have a large number of Vertica queries and need help finding them, contact Retool Support.