QUERIES AN SQL TABLE¶
Executes an arbitrary SQL query against an existing platform database table and returns the results as both a formatted string preview and a dataset object. Use this worker to read, filter, or manipulate data stored in SQL tables within the d3VIEW platform; non-SELECT queries (INSERT, UPDATE, DELETE) are also supported but do not produce row outputs.
When to use¶
Tagged: database, db, query, select, sql, table, workflows.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Query | query | textarea | — | ✓ | Full SQL statement to execute (e.g. SELECT, INSERT, UPDATE, DELETE); must reference an already-existing table — use the create_sql_table worker first if the target table does not yet exist. Code-editor mode is enabled for multi-line authoring. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Status | status | string | Human-readable string indicating whether the query succeeded (including the executed statement) or failed (including the error message); always populated regardless of query type. |
| Results | results | string | Plain-text preview of the SELECT query result set, capped at the first 10 rows with a header noting total vs. hidden row counts; only populated when the query returns at least one row. |
| Results Dataset | results_dataset | dataset | Full result set of a SELECT query as a structured dataset object (array of row objects) suitable for downstream dataset-aware workers; only populated when the query returns at least one row. |
Disciplines¶
- data.io.sql
Auto-generated from platform schema. Worker id: sql_query_table. Schema hash: 367192d7b9d9. Hand-curated docs in workerexamples/ override this page when present.