run_sql
Run arbitrary SQL statements against SingleStore and fetch results for SELECT, DML, and DDL operations outside pipeline-specific tasks.
Instructions
Run one arbitrary SQL statement against SingleStore and return the results.
Use this for SELECT/DML/DDL that isn't pipeline-specific. For creating,
altering, starting, stopping, dropping or inspecting Pipelines, prefer
the dedicated pipeline tools -- they validate the statement type and are
easier to call correctly.
Args:
sql: The statement to execute.
database: Database to run it against (defaults to the connection's
configured database).
max_rows: Truncate returned rows to this many (does not affect how
many rows the statement itself processes).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| database | No | ||
| max_rows | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||