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¶
| 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¶
| 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
Auto-generated from platform schema. Worker id: database_import_dataset. Schema hash: cce0c0a8b950. Hand-curated docs in workerexamples/ override this page when present.