error in sparl SQL
Hi ,If i comment NULL as TRX_PERIOD, NULL AS applied_period, mv is loading successfully, uncomment getting below error.Please let me know what is the issue in the query
Forum Posts
Resolved! Why are primary keys important?
We noticed that starting in 2023.7 we are getting error messages in the loader status, if the Enforce Primary Key Constraint option isn't selected with Primary keys setup in the table. Screenshot below. Someone on our team asked why we even need pri...
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...
Schema load schedule behavior
I have a schema which takes ~ 13 hours to load doing a full load.Last night it finished ~ 1:30 a.m. which is 1/2 hour *past* the scheduled incremental build time.I would have expected the scheduler to queue the incremental build and run it directly 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...
