Tessra
Menu
ProductIntegrationsDocsCortexDemo

Paste these commands into Snowflake to run your first governed action.

RequestPolicyApprovalExecutionReceipt

Tessra

Configure approvals

Humans approve in product channels—not inside a SQL session. Wire Slack or email in your Tessra deployment UI.

Slack

  • Install the Tessra Slack app (or OAuth) per your environment.
  • Map channels / workspaces where approval prompts should land.
  • Approvers use in-message actions; Tessra records the decision.

Email

  • Enable email as a fallback or primary channel if supported.
  • Links in the message deep-link into the approval surface.

What happens on approval

Request → Policy → Approval → Execution → Receipt

  • Policy returns REQUIRE_APPROVAL → status waits.
  • Human approves in Slack/email → Tessra stores approval.
  • Executor dispatches → callback → terminal receipt.

Example flow

  1. Agent submits amount in the mid band.
  2. Poll shows WAIT_FOR_APPROVAL.
  3. Approver confirms in Slack.
  4. Poll moves to execution, then terminal success.

SQL

Use GET_ACTION_STATUS / GET_ACTION_STATUS_FOR_CORTEX until terminal is true.