.. _auto_database_import_dataset:

*IMPORT DATASET INTO DATABASE*
==============================

Inserts dataset rows as new records into an existing database. Pick the target database, feed a dataset, and map the dataset columns to the database fields. Existing records are not modified.

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

Tagged: ``database``, ``datarecord``, ``dataset``, ``import``, ``insert``, ``record``, ``mapper``, ``data_io``.

Inputs
------

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

   * - Label
     - ID
     - Type
     - Default
     - Required
     - Description
   * - Database
     - database_id
     - remote_lookup
     - —
     - ✓
     - Target existing database to insert into.
   * - Dataset
     - dataset
     - dataset
     - —
     - ✓
     - Dataset whose rows are inserted as new records.
   * - Map dataset columns to database fields
     - column_map
     - mapper
     - —
     - ✓
     - Maps each dataset column to a database field. Right side is fetched from the selected database's columns.

Outputs
-------

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

   * - Label
     - ID
     - Type
     - Description
   * - Database Id
     - database_id
     - integer
     - The database that received the records.
   * - Inserted
     - inserted_count
     - scalar
     - Number of records inserted.
   * - Skipped
     - skipped_count
     - scalar
     - Number of dataset rows skipped (no mapped columns).
   * - Inserted Records
     - records
     - dataset
     - Ids of the inserted records.

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

- data.io
- platform.data_management

.. 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_import_dataset</code>. Schema hash: <code>cce0c0a8b950</code>. Hand-curated docs in <code>workerexamples/</code> override this page when present.
   </p>