.. _auto_database_get_vector_column:

*GETS A VECTOR COLUMN FROM A DATABASE*
======================================

Retrieves a single named vector column from a d3VIEW database record and returns its values as a vector. Use this worker when a downstream step needs one array-valued column from a structured database without loading the entire table.

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

Tagged: ``column``, ``database``, ``datarecord``, ``fetch``, ``remote_lookup``, ``vector``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Database
     - database_id
     - remote_lookup
     - —
     - ✓
     - Remote reference to the target d3VIEW database (datarecord); select from the platform database registry — required, no default.
   * - Column Name
     - column_name
     - text
     - —
     - ✓
     - Exact name of the vector-typed column to retrieve from the selected database; case-sensitive, must match the column header stored in the record.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - Database Id
     - database_id
     - scalar
     - Pass-through reference to the source database that was queried, enabling downstream workers to chain further operations on the same record.
   * - Column Data
     - column_data
     - vector
     - The extracted column returned as a numeric or string vector; length equals the number of rows in the database for that column.

Disciplines
-----------

- data.io.sql

.. raw:: html

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