Operation query.table in plugin tabular v0.5.0
Execute a sql query against an (Arrow) table.
The default relation name for the sql query is 'data', but can be modified by the 'relation_name' config option/input.
If the 'query' module config option is not set, users can provide their own query, otherwise the pre-set one will be used.
| Author(s) | Markus Binsteiner (markus@frkl.io) |
| Tags | tabular |
| Operation type | custom_module |
Inputs
| Name | Description | Type | Required? | Default |
|---|---|---|---|---|
| query | The query, use the value of the 'relation_name' input as table, e.g. 'select * from data'. | string | true | null |
| table | The table to query | table | true | null |
| relation_name | The name the table is referred to in the sql query. | string | true | "data" |
Outputs
| Name | Description | Type | Required? | Default |
|---|---|---|---|---|
| query_result | The query result. | table | true | null |
Module configuration
Module query.table
No configuration options set