Assume that the table is hierarchically partitioned by day for the last 3 months, month for the past year, and year from then onwards, and the table is sales.f_sales. Assume that the new records are … (View Post)

Why would you need to do that? I know three - all pretty intuitive - ways to add minutes to timestamps. * knowing that a minute is 1/1440 of a day, add n times 1/1440 to an input timestamp * use the … (View Post)

Or, with the existing calendar from my preceding answer - just a complex join with the calendar: WITHticket(tkid,tkname,cre_dt,res_dt) AS ( SELECT 1,'3rd ticket', DATE '2023-09-01', DATE '2023-09-04'… (View Post)

Then, you need to create a distinct "calendar" between creation and resolution date for each ticket: 1. UNION SELECT ticket id and start date with ticket id and resolution date, to get a li… (View Post)

In general - form follows function. So I'd need to know the nature of the more you're mentioning. Without any additional info, the safest way is to: * model star models rather than snow flake * use V… (View Post)