You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Performance issue with writeback operations to Snowflake table using EPM Integration agent

in Planning

Hello,

I am trying to load some data in Snowflake table using EPM Integration agent. It is crossing default batch timeout of 30 minutes to load just 5k rows and integration fails. We tried to restart integration agent to see if that fix the issue but It didn't help. We also limited the batch size to 1000 to see how much time it takes to load 1000 rows. It took more then 15 minutes to process it as I can see in process log.

Is it a generic performance problem with writeback operations using integration agent or can it be related to Snowflake?

Can anyone please suggest any solution of it.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!