Topics with Label: Materialized Views

Resolved! Update and add values in a materialized view using incremental load

Hi all,I have quite a big MV that's takes about and 1.5 hours to finish loading, I've tried using incremental load but it doesn't seem to update values only append. I want to know if there's a way to keep data up till a certain date, and everything a...

Activity with in window of time

If I have a site and I want to bucket visitors in to 'Super Active,' 'Active,' 'Kinda Active,' and 'Meh' based on a rolling n-day window of activity ( e.g. 30 visits is 'Super' 2 is 'Meh' )That seems pretty straightforward for a given end date ( alth...

Resolved! Can we use analytic functions like LEAD or LAG in Incorta Sparksql?

Can we use analytic functions like LEAD or LAG in Incorta Sparksql?