CODEWITHSUNDEEP
snowflake-cloud-data-platformteradatanormalizeteradata-covalent
abdoulsn
abdoulsn

Reputation: 1159

Teradata normalize equivalent in Snowflake

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?

Upvotes: 0

Views: 296

Answers (0)

Related Questions