DB Table Custom Read

Overview

DB Table Custom Read executes a custom SQL read query and maps results to a user-defined JSON schema.

Use this tool when query shape is complex (joins, computed columns, grouped results) and not covered by built-in read nodes.

Input

SQL Query

string required

Custom SQL select query.

Supports runtime interpolation using Template Expressions.

JSON Schema

string required

Defines expected output object structure for parsed query results.

The UI schema builder can generate this and also updates downstream output typing.

Output

Number of Read Rows

integer

Count of rows returned by the query.

Update Dashboard Data

boolean

Indicates dashboard data update status for this read operation.

Query Data Output

Result payload shape follows provided JSON Schema.