how to add a constant value (1) in an empty column in snowflake-matillion

Question

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  avg  test_no
1   445     89   1
2   434     85   1
3   378     75   1
4   421     84   1

Answer 1

In Snowflake, you would modify the table using:

update t
    set test_no = 1;

I assume that Matillion supports this as well.

Answer 2

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