Run Query
Last updated
Was this helpful?
Last updated
Was this helpful?
This pre-built action, located under the @Generic element, instructs Avo Assure to execute the specified query on the database defined in the input value and stores the result in a dynamic variable.
Input Value: <DB IP/instance name/DB file path>; <DB port>;<DB username>;<DB password>;<DB name>; <Query>;<DB Number>;<collection/ warehouse>(Optional);<querytype/ schema>(Optional)
<DB IP/instance name/DB file path> (Required)
Specifies the database server location, instance identifier, or database file path
<DB port> (Required)
The port number used to connect to the database.
<DB username> (Required)
The username credential for database access.
<DB Password> (Required)
The password credential for database access.
<DB name> (Required)
Required name of the database to connect.
<Query> (Required)
Required SQL or Non SQL query to be executed.
<DB Number> (Required)
Database Number serves as a unique identifier for a specific database connection.
<collection/warehouse> (Optional)
Required the specific data container within the database to target.
<querytype/schema> (Optional)
Defines the nature of the query or specifies the database schema to be used.
Click below link to get more information about Supported Database in Avo Assure
Note: When using a Non-SQL Query to run a specific action, the user must provide either the collection name or the warehouse name in the input syntax.
Output Value:
<Dynamic Variable>
(Required)
This variable stores the outcome of the operation
<Dynamic Variable>
(Optional)
This variable stores the status as True or False
Example:
Execute Database Query The Run Query(DB) action takes values from the Input Value column, including database connection details and a query. It connects to the specified database and executes the query provided. The result of the query is stores in {Outcome} Variable, while the execution status is saved in the {Status} variable with the following possible values:
True – if the query runs successfully
False – if the query execution fails
