Skip to main content


Vertica gives a top-tier, unified analytics platform that will always be free of the hidden framework. Connecting DronaHQ to Vertica lets you construct UIs rapidly on top of your Vertica information. For instance, you could fabricate an instrument to adjust metadata tables. You can peruse information from Vertica and afterward compose information back to it either straightforwardly, or through a different API.


  1. Authentication Requirements: To establish a connection with your Vertica instance, you will require specific authentication credentials. You have the choice of either of the following two credential options:

    • Vertica database username and password.
    • Alternative authentication methods (excluding AWS IAM authentication).
  2. Connection Details:

    • Hostname of the Vertica database.
    • Port number for database communication.
    • The designated database name within the Vertica host.
  3. Firewall Rules:

    • Set up your firewall settings to permit DronaHQ's IP whitelist for access to your Vertica host.

Configuring Connector in DronaHQ

Configure your database category using the provided details. Validate connection with Test connection and Save settings for secure database setup.


HostEnter the Host Domain or IP
PortEnter the Port number
Database NameEnter the Database name
UsernameEnter the Username
PasswordEnter the Password
Vertica with Sample details.
Vertica with Sample details.


Advanced OptionDescription
Connection OptionsThe key and value connection options in database configuration refer to specific settings (keys) and their corresponding values that dictate how the application connects to the database
Use Dynamic Database HostDynamically determine the host for the database connection.
Use Dynamic Database NameSet the database name dynamically, allowing easy switching between databases.
Use Dynamic Database Credentials Enable dynamic database credentials for secure and convenient management.
Whitelist IP Enhance security by restricting database access to specific whitelisted IP addresses.

Adding Database Queries

After configuring the connector, access it in your Connector Library.

Click Add query once the connection is established. Create queries, run them, and view responses.

Write Queries
Write Queries

Use double curly brackets for dynamic variables. Test with sample values before saving. Link dynamic variables to controls/actions for runtime use.

Saved queries appear under your connector in Connector Library.

Supported Query Operations

Raw SQL QueryExecute various SQL operations directly, e.g., SELECT * FROM TableName;
Stored Procedure CallCall stored procedures, e.g., EXEC usp_GetInfo; to perform specific tasks or retrieve data from the database.

Using Vertica Connector

Data Bind using Data Query

Read/Display Data Query for Vertica:

Begin by constructing an SQL query to extract data from your Vertica database. For example, let's consider a scenario where you want to retrieve all data from the Persons table. The SQL query is:

Query used:

SELECT * FROM Persons;

Query explanation:

This SQL query retrieves all rows and columns from the Persons table within the Vertica database.

Query example for retrieving data from Vertica database.
Query example for retrieving data from Vertica database.

Integrate the fetched data into your application's interface.

a. Access the Controls section and introduce the Table grid control.

b. Navigate to Data Bind Options -> Quick Select -> Database Queries.

c. Opt for the Vertica connector and choose the query that aligns with your data presentation goals.