LAG and LEAD function
I used the LAG and LEAD function in community and it worked fine. But when I used them while working on actual datasets (via a direct database connect), it seems that the functions are not available since the words lag and lead didn't turn red. And the query give me a syntax errro.
anyone able to use these functions while connecting to a database?
I use them when connected to Snowflake DB, and can confirm they work just fine.
you might need to check your DB has support for them.