Teradata supports referencing an alias before it is declared, but Snowflake does not. The transformation for this scenario is to take the referenced table and change the alias for the table name it references.
Teradata
-- Case 1, THERE IS A REFERENCE TO TABLE2 IN THE SET CLAUSE WITHOUT A FROMUPDATE CRASHDUMPS.TABLE1 iSET COLUMN4 = CRASHDUMPS.TABLE2.COLUMN3WHERE i.COLUMN1 = CRASHDUMPS.TABLE2.COLUMN1AND i.COLUMN3 ='L';-- CASE 2, FORWARD ALIASUPDATE iFROM CRASHDUMPS.TABLE2, CRASHDUMPS.TABLE1 iSET COLUMN4 = CRASHDUMPS.TABLE2.COLUMN3WHERE i.COLUMN1 = CRASHDUMPS.TABLE2.COLUMN1AND i.COLUMN3 ='L';
Snowflake
-- Case 1, THERE IS A REFERENCE TO TABLE2 IN THE SET CLAUSE WITHOUT A FROMUPDATE CRASHDUMPS.PUBLIC.TABLE1 AS iSET i.COLUMN4 = CRASHDUMPS.TABLE2.COLUMN3WHERE i.COLUMN1 = CRASHDUMPS.TABLE2.COLUMN1AND i.COLUMN3 ='L';-- CASE 2, FORWARD ALIASUPDATE CRASHDUMPS.PUBLIC.TABLE1 AS i SET i.COLUMN4 = CRASHDUMPS.TABLE2.COLUMN3 FROM CRASHDUMPS.PUBLIC.TABLE2WHERE i.COLUMN1 = CRASHDUMPS.TABLE2.COLUMN1AND i.COLUMN3 ='L';