Overview

SQL requests allow users to execute queries on specific DB connections for which they do not have permissions. Once approved, the requester can execute the approved query a single time and view the results.

Submitting an SQL Access Request

STEP 1 Access the SQL Request page through the following paths:

• Attempt to execute a restricted query in the Web Editor and click the SEND SQL Requests button
• Workflow > Submit Request > SQL Request

STEP 2 Select approval rules and assign approvers.

• Approval Rule: Choose an approval rule from the list created by the administrator in General > Approval Rules.
  • Approval rules determine who must approve the request. If the rule specifies approvers, they will be automatically assigned.
• Approver: Use the + button to add approvers at each stage of the approval workflow.
  • A single assignee can complete the approval request: Any one approver in a group can approve the request.
  • All assignees must approve this request: All assigned approvers must approve the request for it to proceed.

STEP 3 After entering all details, click the Submit button to send the request for approval.

• Title: Provide a title for the request.
• Connection: Select the target DB connection for SQL execution. Only connections where you have access will be shown.
• Database: Choose the specific database within the connection for the query execution.
• Content Type: Select how to provide the SQL query:
  • Text: Write the query (up to 9,999 lines, 10 million characters, or 5MB).
  • File: Upload a .sql file.
• Target Date: Specify the desired execution date for the query (default: request submission date).
• Due Date: Specify when the approval/execution will expire (default: one year from the request date).
• Reason for Request: Provide a reason for requesting SQL execution.

Approving a Request

STEP 1 Assigned approvers can navigate to Workflow > Received Requests > To Do to view pending requests.

STEP 2 Open the details page for the request and click the Approve button to complete the approval process.

Executing an Approved SQL Request

STEP 1 The requester can go to Workflow > Executions > To Do to view pending executions.

STEP 2 Open the request, review its details, and click the Execute button in the top-right corner to run the query.

• To cancel the execution, click the Cancel button instead.
• Once the execution is complete, check the Results tab in the request details page to see whether the execution was successful or failed.
• You can also view a history of executed requests under Workflow > Executions > Done.