How to Submit a Workflow for SQL Requests

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.