Having this code in mssql i want to make it a snowflake supported code. Issue is in update part. Create procedure part can be done.

CREATE PROCEDURE [SchemaA].[UpdateRecords]
(
    @ExtractID bigint,
    @AgencyID bigint
)
AS
BEGIN
    DECLARE 
        @TransID bigint

    SET @TransID = 0

    UPDATE 
        [SchemaA].[TransactionTable]
    SET 
        @TransID = [TID] = (@TID + 1)
        
    FROM
        [SchemaA].[TransactionTable] t1
        LEFT OUTER JOIN [SchemaB].[ClientTable] t2
            ON t2.[AgencyID] = @AgencyID
                AND [SchemaA].[ConvertIDToString](t1.[ClientID]) = t2.[ClientCode]
        LEFT OUTER JOIN [SchemaA].[InvoiceTable] t3
            ON t3.[ExtractID] = @ExtractID
                AND t1.[InvoiceNumber] = t3.[InvoiceNumber] 
        LEFT OUTER JOIN [SchemaB].[PolicyTable] t4
            ON t4.[AgencyID] = @AgencyID
                AND [SchemaA].[ConvertIDToString](t3.[PolicyNumber]) = t4.[PolicyCode]
        LEFT OUTER JOIN [SchemaB].[BrokerTable] t5
            ON t5.[AgencyID] = @AgencyID
                AND t1.[BrokerID] = t5.[BrokerCode]
        LEFT OUTER JOIN [SchemaB].[DepartmentTable] t6
            ON t6.[AgencyID] = @AgencyID
                AND (t3.[DivisionID] + t3.[BranchID] + t3.[DeptID]) = t6.[DeptCode]
    WHERE
        t1.[ExtractID] = @ExtractID
END

I want this in snwoflake, the issue is snowflake doesn’t support left join in update.

I have tried this approach :

update t1
set v = 0
where t1.id in (
select t4.id
from t4 left join t3 
on t4.id = t3.id  
left join t2 on t3.id = t2.id
left join t1 on t2.id = t1.id);

Is this correct?