Hi,I have an incremental table where I load data once a week. It’s been 6 months, and the data has already exceeded 30 GB (~500 million rows). Now, if I want to restrict the history to only the last 3 months, is there a way to do this? I don’t want t...

Hi,I'm trying to achieve a rolling sum with a max condition. Basically trying to do a rolling sum but before we roll the 1st row sum to the next row we have to check with a condition if the rolling value is less than or equal to Zero. If it is less t...

Hi,I have start date (File Date) and end date in the table and i want to repeat the rows for each day from start date to end date. Is there any way that I can achieve this in MV? Please see screenshot - Appreciate your help in Advance. Thanks.

Hi,I'm trying to write a query in MV (Spark SQL) which excludes the items ending with "_X" I understand underscore ("_") is single character wildcard in SQL and should be addressed as '%[_]x' or '%\_x' which will include the Underscore (_).  But it s...