How to lower the data import time in servicenow (import set to target table)

Obito · ‎10-04-2023

Hi all,

I have this requirement where I am importing 1,00,000 records into ServiceNow using data source. The csv file which I am importing is around 70MB and it is taking almost 3 hours to transform into target table from import set table. How I can lower this time. Please suggest me.

Thank you.

Ankur Bawiskar · ‎10-04-2023

@Obito

I would recommend doing the import during off-business hours.

if possible try to divide the rows from csv into 3 different csv files.

then import 3 files after gap of couple of hours.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Obito · ‎10-04-2023

Thank you. I will try this.