Snowflake table updating very slowly
Posted: Fri Jan 31, 2020 3:38 am
Hi
I am trying to Update and insert a table in Snowflake via separate Jobs. Update is taking long time and not finishing in Monitor it says only 1 row is being processing all the time and it didn't go more than that.
I am using ODBC Stage and updating the data using 3 key columns and 5 non key columns are being updated
Volume:30000
Would you please advise if we can load quicker using another way such as bulk or any methods?
I am trying to Update and insert a table in Snowflake via separate Jobs. Update is taking long time and not finishing in Monitor it says only 1 row is being processing all the time and it didn't go more than that.
I am using ODBC Stage and updating the data using 3 key columns and 5 non key columns are being updated
Volume:30000
Would you please advise if we can load quicker using another way such as bulk or any methods?