I'm working on convertion of sql from Teradata to snowflake, I've encoutered Normalize in sql with period(). Is there any equivalent in snowflake?
...
select normalize
id,
abc,
xyz,
period(time,
case
when
mtnt = mtnt_bb_l
and net_bb = net_bb_l
and DATEDIFF(MONTH,time,lead(time,1) over (....))>1
then add_months (time +1,1)
else lead(...)
end),
tms
from table
...
As you can see, normalize juste comme after select. is there any workround?