Data Resource - SQL Select Query
About
A SQL Select data resource is a SQL DML Request that contains a SELECT statement.
Howto
Execution
A SQL file containing a select statement can be executed if it's represented as an sql request (ie SQL runtime data resource uri)
For instance,
- for a top-5-clients.sql select sql file
- located in the current directory
- that should be executed against a sqlite database
The runtime data resource data uri would be:
(top-5-clients.sql@cd)@sqlite
Attribute
| Name | Default | Description |
|---|---|---|
| select-metadata-detections | describe, temporary-view, false-equality | Define a list of detection methods used to capture the structure if not defined via a data-definition |
All common data-definition attributes are also allowed (columns, …)
Support
Prepared Statement
We support configurable select statement with prepared statements
How to execute multiple SELECT statements in one script
We support as of today, only one select statement by SQL Fetch.
Why? Because a request returns only one resource.
If you want to execute multiple SELECT statements in one script, you need to use the split operator in a pipeline.