Import File dialog

Table name, structure and data mappings

Item	Description
Table	The name of the table.
Comment	The table comment.
Columns \| Keys \| Indexes \| Foreign Keys	Data mappings and definitions of columns, keys, and indexes. Double-click the line to start editing. The Mapped to field specifies relation of a data column from the file and the corresponding column in the database. If you clear this field, no data is added to the target column in the database. To remove a column, select the corresponding line and click the Remove button .

Item

Description

Table

The name of the table.

Comment

The table comment.

Columns | Keys | Indexes | Foreign Keys

Data mappings and definitions of columns, keys, and indexes. Double-click the line to start editing.

The Mapped to field specifies relation of a data column from the file and the corresponding column in the database. If you clear this field, no data is added to the target column in the database.

To remove a column, select the corresponding line and click the Remove button .

Data and DDL previews

Item	Description
Data Preview	The generated preview of how your data will be imported to the database.
DDL Preview	A statement or statements that JetBrains DataSpell will run to create a table. You can edit the statements in the DDL preview field.

Encoding, errors, and logs

Item	Description
Encoding	Select the character encoding for your data in the source file.
Write errors to file	Write errors that occur during the import in a text file.
Insert inconvertible values as null	Insert the `NULL` value into the table instead of the data that cannot be converted.

Last modified: 08 March 2021