Trying to update two columns in a simple Snowflake table with 106,000 rows took so long I abandoned it after one hour?
Doing the same with an Update statement in Snowflake took 2.2 seconds?
What am I doing wrong?
@Hendrik_Lombard what database are you working with? And how many rows does the input dataset have?
Snowflake table 570,000 x 20
Since Snowflake doesn't support queries with multiple statements by default, EasyMorph executes a separate SQL command for each unique value in the [TAX_ID] column.
I'm curious about what your UPDATE statement looks like?