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 lists the tables that are used to configure, run, and log failures for import operations.

Table name (display name) Description
import (data import) Status and ownership information for the import job.
importfile (import source file) Logical source file.
importlog (import log) Failure reason and other detailed information for a record that failed to import.

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

Table name (display name) Description
importmap (data map) Data map that is used for import.
columnmapping (column mapping) Mapping between a column in the source file and a target column in Dataverse.
lookupmapping (lookup mapping) 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 (owner mapping) Mapping between a user specified in the source file and a user in Dataverse.
picklistmapping (picklist mapping) 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 (transformation mapping) Complex transformation mapping.
transformationparametermapping (transformation parameter mapping) Parameter mapping that is used in complex transformation mapping.

See also

Import Data in Dynamics 365
Import table
ImportFile table
ImportLog table
ImportMap table

ColumnMapping table
LookupMapping table
OwnerMapping table
PicklistMapping table
TransformationMapping table
TransformationParameterMapping table

Sample: Export and Import a Data Map
Create data maps for import
Add transformation mappings for import
Configure data import
Run data import
Sample: Export and import a data map
Sample: Import data using complex data map