.. _auto_dataset_create_sql_table:

*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.

When to use
-----------

Classification: **process**.

Tagged: ``csv_columns``, ``dataset``, ``query``, ``sql``, ``table_creation``.

Inputs
------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20 20 20

   * - 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
-------

.. list-table::
   :header-rows: 1
   :widths: 20 20 20 20

   * - 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 <https://www.d3view.com/api/workflow/example?id=dataset_create_sql_table>`_

.. raw:: html

   <hr style="margin-top:2em">
   <p style="font-size:11px;color:#888">
   Auto-generated from <code>transformation</code> schema. Worker id: <code>dataset_create_sql_table</code>. Schema hash: <code>b520eec652c9</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>