Data import tables

The Microsoft Dataverse data import tables are used to create data maps, configure and run data imports, and log failure information.

The following table lists the tables that are used to configure, run, and log failures for import operations.

Table	Description
Data Import (Import)	Status and ownership information for the import job.
Import Source File (ImportFile)	Logical source file.
ImportLog	Failure reason and other detailed information for a record that failed to import.

The following table lists the tables that are used for creating data maps.

Table	Description
Data Map (ImportMap)	Data map that is used for import.
ColumnMapping	Mapping between a column in the source file and a target column in Dataverse.
LookUpMapping	Mapping between a column in the source file, or an output of a complex transformation and a target column of type EntityReference. Used in conjunction with column mapping or complex transformation mapping.
OwnerMapping	Mapping between a user specified in the source file and a user in Dataverse.
List Value Mapping (PickListMapping)	Mapping between a column in the source file and a target column of OptionSetValue, Boolean, state, or status type in Dataverse. Used in conjunction with column mapping.
TransformationMapping	Complex transformation mapping.
TransformationParameterMapping	Parameter mapping that is used in complex transformation mapping.

Feedback