Snowflake SP - 10 - Real Time Stored Procedures

[@vshannkarind]

Hi Bro,
I have around 12 CTE's with same logic , only difference is start and end date coulmns are different ,how to use object construct with Array concept in Snowflake or most optimized method in Snowflake?

[@mrjana520]

1. Then write a UDF with start and end date as params and use that function in logic.
2. Will do a video on Object construct in near future.

[@vshannkarind]

@mrjana520 thank you