My usecase is to ingest data from ServiceNow into Snowflake, with no tranformation. I’m creating simple pipeline with 2 snaps - ServiceNow Query and Snowflake BulkLoad
The service now table has 2.5 M rows, it is taking about 7hrs to read this data from service now .
How to improve the performance??