Importing csv using Datagrip (table with identity column)

Question

How to import CSV file into SQL Server table with identity column using DataGrip.

More precisely, how to exclude the identity column during the import or force importing the identity column?

Answer 1

Assume, you've got a table

create table test_identity_insert(

  x bigint primary key identity(1,1),

  y int
);
go

You need to change data mappings