use like this

MERGE INTO derived_load_support.redshift_last_processed_dttm as t USING ( select 'iddna' as database_name, 'TEAM_DIM' as table_name, timestamp '2024-08-21 12:33:59.000001' as max_redshift_timestamp) as s ON s.database_name=t.database_name and s.table_name=t.table_name WHEN MATCHED THEN UPDATE SET (max_redshift_timestamp = s.max_redshift_timestamp ) WHEN NOT MATCHED THEN INSERT (database_name, table_name, max_redshift_timestamp) VALUES (s.database_name, s.table_name, s.max_redshift_timestamp)