Request Title

{{requestTitle}}

Request title

• Example: Service DB Access Request

Assignees

{{assignees}}

Request approval assignees

• Example: STEP 1(Katie Wells), STEP 2(Kenny Park), STEP 3(Brant Hwang)

Comment

{{comment}}

Request comment

• Example: Requesting DB access permission for service operation purposes.

User Name

{{userName}}

Requester name

• Example: Keira Yoon

Email

{{email}}

Requester email

• Example: keira@email.com

Access Type

{{accessType}}

Request type

• DB Access Request
• SQL Request
• SQL Export Request
• Unmasking Request
• Server Access Request
• Access Role Request

Link

{{link}}

Request detail page link

• Example: https://{querypie_domain}/workflow/received-requests/to-do/detail/{workflow_uuid}

Workflow Uuid

{{workflowUuid}}

Request UUID

• Example: b63f9f94-11e5-4095-a399-be7d96e9ce06

Workflow Id

{{id}}

Request ID

• Example: 12

Urgent

{{urgent}}

Urgent request status

• true or false

10.2.0

Expiration Date

{{expirationDate}}

Expiration date

10.2.2 11.2.0 - Deprecated

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Access Expiration Date

{{accessExpirationDate}}

Access expiration date

11.2.0

Requested Privilege per Connection

{{connectionPrivilegeNames}}

Display requested privileges by connection as a list

• Example:
  • Connection A : Read/Write
  • Connection B : Read-Only

10.2.2

SQL Text

{{sqlText}}

SQL statement

• Maximum 100 characters (same for TEXT, FILE)

10.2.2

Content Type

{{contentType}}

SQL statement input method

• TEXT or FILE

10.2.2

Cluster Group Uuid

{{clusterGroupUuid}}

DB connection UUID

10.2.2

Cluster Group Name

{{clusterGroupName}}

DB connection name

10.2.2

Cluster Id

{{clusterId}}

DB connection ID

10.2.2

Database Type

{{databaseType}}

Database type

10.2.2

Database Name

{{databaseName}}

Database name

10.2.2

Use Ledger Approval Rule

{{useLedgerApprovalRule}}

Whether to use ledger approval rule

10.2.2

Target Date

{{targetDate}}

Execution target date

10.2.2 11.2.0 - Deprecated

Preferred Execution Date

{{preferredExecutionDate}}

Execution target date

11.2.0

Due Date

{{dueDate}}

Approval/execution expiration date

10.2.2 11.2.0 - Deprecated

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Execution Expiration Date

{{executionExpirationDate}}

Execution expiration date

11.2.0

Cluster Group Uuid

{{clusterGroupUuid}}

DB connection UUID

10.2.2

Cluster Group Name

{{clusterGroupName}}

DB connection name

10.2.2

Cluster Id

{{clusterId}}

DB connection ID

10.2.2

Database Type

{{databaseType}}

Database type

10.2.2

Database Name

{{databaseName}}

Database name

10.2.2

Export Type

{{exportType}}

Export type

• QUERY or TABLE

10.2.2

Export Detail

{{exportDetail}}

Export detail information

• For Query: Maximum 100 character query
• For Table: Table name

10.2.2

Target Date

{{targetDate}}

Execution target date

10.2.2

Preferred Execution Date

{{preferredExecutionDate}}

Execution target date

11.2.0

Due Date

{{dueDate}}

Approval/execution expiration date

10.2.2

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Execution Expiration Date

{{executionExpirationDate}}

Execution expiration date

11.2.0

Cluster Group Uuid

{{clusterGroupUuid}}

DB connection UUID

10.2.2

Cluster Group Name

{{clusterGroupName}}

DB connection name

10.2.2

Database Type

{{databaseType}}

Database type

10.2.2

Database Name

{{databaseName}}

Database name

10.2.2

Table Name

{{tableName}}

Table name

10.2.2

Column Names

{{columnNames}}

Display column names as a list

• Example: [actor_id, first_name, last_name, last_update]

10.2.2

Unmasking Expiration

{{unmaskingExpiration}}

Unmasking expiration time

• Example:
  • 10 Minutes
  • 2024-12-03T14:59:00

10.2.2

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Cluster Group Uuid

{{clusterGroupUuid}}

DB connection UUID

11.0.0

Cluster Group Name

{{clusterGroupName}}

DB connection name

11.0.0

Database Type

{{databaseType}}

Database type

11.0.0

Database Name

{{databaseName}}

Database name

11.0.0

Table Name

{{tableName}}

Table name

11.0.0

Column Names

{{columnNames}}

Display column names as a list

• Example: [actor_id, first_name, last_name, last_update]

11.0.0

Restricted Data Access Expiration

{{restrictedDataAccessExpiration}}

Access permission expiration time

• Example:
  • 10 Minutes
  • 2024-12-03T14:59:00

11.0.0

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Cluster Group Uuid

{{clusterGroupUuid}}

DB connection UUID

11.0.0

Cluster Group Name

{{clusterGroupName}}

DB connection name

11.0.0

Data Scope Type

{{dataScopeType}}

Choose one between Data Path and Tag

11.0.0

Database Type

{{databaseType}}

Database type

11.0.0

Database Name

{{databaseName}}

Database name

11.0.0

Table Name

{{tableName}}

Table name

11.0.0

Column Names

{{columnNames}}

Display column names as a list

• Example: [actor_id, first_name, last_name, last_update]

11.0.0

Expiration

{{expiration}}

Exception permission expiration time

• Example:
  • 10 Minutes
  • 2024-12-03T14:59:00

11.0.0

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Server Group Name

{{serverGroupName}}

Server group name

10.2.2

Server Names

{{serverNames}}

Display server names as a list

• Example:
  • Server A
  • Server B

10.2.2

Server Accounts

{{serverAccounts}}

Display server accounts as a list

• Example:
  • dev
  • ec2-user

10.2.2

Expiration Date

{{expirationDate}}

Expiration date

10.2.2 11.2.0 - Deprecated

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Access Expiration Date

{{accessExpirationDate}}

Access expiration date

11.2.0

Trigger Condition

{{triggerCondition}}

Permission grant start condition

11.2.0

Duration

{{duration}}

Time in minutes that server access permission is valid

11.2.0

Server Group Name

{{serverGroupName}}

Server group name

10.2.2

Server Names

{{serverNames}}

Display server names as a list

• Example:
  • Server A
  • Server B

10.2.2

Server Accounts

{{serverAccounts}}

Display server accounts as a list

• Example:
  • dev
  • ec2-user

10.2.2

Expiration Date

{{expirationDate}}

Expiration date

10.2.2 11.2.0 - Deprecated

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Privilege Expiration Date

{{accessExpirationDate}}

Privilege expiration date

11.2.0

Trigger Condition

{{triggerCondition}}

Permission grant start condition

11.2.0

Duration

{{duration}}

Time in minutes that server privilege is valid

11.2.0

Service

{{service}}

Target service for role request

• SAC, KAC, WAC

10.2.2

Role Name

{{roleName}}

Role name

10.2.2

Expiration Date

{{expirationDate}}

Expiration date

10.2.2 11.2.0 - Deprecated

Approval Expiration Date

{{approvalExpirationDate}}

Approval expiration date

11.2.0

Role Expiration Date

{{roleExpirationDate}}

Role expiration date

11.2.0