sql.connection.validate

Validate an external SQL connection (SELECT 1) and return server version

Overview

Property	Value
Workflow type	Atomic
Library	App-sql
Version	1.0

Input Schema

Field	Type	Required	Default	Description
organization_uuid	uuid	Yes	—	—
cloud_connection_uuid	uuid	Yes	—	—
actor	string	No	—	—

Output Schema

Field	Type	Required	Default	Description
organization_uuid	uuid	No	—	—
cloud_connection_uuid	uuid	No	—	—
actor	string	No	—	—
valid	boolean	No	—	—
dialect	string	No	—	—
host	string	No	—	—
database	string	No	—	—
server_version	string	No	—	—
validated_at	string	No	—	—
failure_reason	string	No	—	Engine-stamped human-readable failure reason
failed_at_state	string	No	—	Engine-stamped state when the workflow failed
failed_step	string	No	—	Engine-stamped step name (DAG path)
failed_layer	integer	No	—	Engine-stamped layer index (DAG path)
error	string	No	—	Engine-stamped exception message
error_type	string	No	—	Engine-stamped exception class name
failure_type	string	No	—	Engine-stamped failure category (atomic path)
failed_action	string	No	—	Engine-stamped action method that raised (atomic path)
failed_at	string	No	—	ISO timestamp when the fail action ran

States

State	Initial	Terminal	Success	Auto-advance	Description
initiated	Yes	No	—	execute	Inputs accepted
completed	No	Yes	Yes	—	Connection validated
failed	No	Yes	No	—	Validation failed

State Diagram

Transitions

From	Action	To	Description
initiated	execute	completed	—
* (any state)	fail	failed	—

API Usage

POST /api/workflows/start
Content-Type: application/json

{
  "workflow_type": "sql.connection.validate",
  "initial_data": {
    "organization_uuid": "value",
    "cloud_connection_uuid": "value"
  }
}