How To Add A Constant Value (1) In An Empty Column In Snowflake-matillion

my table looks like id total avg test_no 1 445 89 2 434 85 3 378 75 4 421 84 I'm working on matillion-snowflake I need my result to look like id total

Solution 1:

Just use a Calculator component and set the value of the calculated column to 1

Solution 2:

In Snowflake, you would modify the table using:

update t
    set test_no =1;

I assume that Matillion supports this as well.