Operation query.table in plugin tabular v0.5.2
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