A SQL Select data resource is a SQL DML Request that contains a SELECT statement.
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,
The runtime data resource data uri would be:
(top-5-clients.sql@cd)@sqlite
| 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, …)
We support configurable select statement with prepared statements
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.