DATASET CREATE SQL TABLE¶
Loads a dataset into a temporary SQL table and optionally runs a query against it. Use this worker when downstream steps need SQL-based filtering, column selection, or aggregation over a d3VIEW dataset.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Dataset | dataset_1 | dataset | — | The d3VIEW dataset to load into a SQL table; optional if a pre-existing table is already available downstream. | |
| Query to run if any | query | scalar | — | Optional SQL query (or comma-separated column names) to execute against the created table; leave blank to skip querying and only register the table. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Table UID | table_name | text | Unique identifier (UID) of the SQL table created from the input dataset, used to reference it in subsequent SQL workers. |
| Query Result | result | textarea | Text output containing the results of the optional query; empty if no query was provided. |
Disciplines¶
- data.dataset.transform
- data.io.sql
Runnable example¶
A runnable example is registered for this worker. Open the example workflow on the d3VIEW canvas: /api/workflow/example?id=dataset_create_sql_table
Auto-generated from transformation schema. Worker id: dataset_create_sql_table. Schema hash: b520eec652c9. Hand-curated docs in workerexamples/ override this page when present.