Datasource Query

Impure

Executes a SQL SELECT query and returns a list of rows (each row is a map of column and value).

Pure Function

No

Execute Inputs

Execution

INPUT

Execution Input.

Execute Outputs

Complete

OUTPUT

Fires when the data is successfully inserted into the cube.

Data Inputs

Datasource

INPUT

Name of the datasource to use.

Query

INPUT

The SELECT query to execute.

Parameters

INPUT

Optional list of parameters to substitute for ? placeholders.

Data Outputs

Result

OUTPUTarray

List of rows returned by the query.

Multiple

Settings

Throw on SQL Error

BOOLEAN

If true, will throw an error if a SQL error occurs during query.

Default: true

Debug

STRING

Break on node when executing.

Default: No

Options:

NoBeforeInputsBeforeProcessingAfterProcessing