Hello Incorta folks ( Incortites? Incortiacs? Home Incorting King/Queens? Surely not Incoherents! ),
I was on a webinar for another vendor and one of the things which caught my eye was the fact that their demo data was dated up to 2024.
"Hey," I thought to myself, "my demo data isn't dated up to 2024 and it's always kind of bugged me."
Then I thought why not fix it? So I did.
The attached Online Store schema export should contain tables with dates updated to reflect the current calendar. Logic at the end of this post.
Turns out the time dimension only runs through 2024 so that should get updated before Jan 25, but my energy was waning and more important tasks were calling. Do feel free.
If you've read this far here's an interesting nugget! I had originally created an MV for the address table named "AddressMeAsCaptain" because I have an odd sense of humor.
That's not the interesting part. I deleted that MV. I've saved a bunch of times since then.
But if you dig though the export there it is under the notebook folder complete with the date update logic ** and the result set for the MV ** which is terribly interesting to me. I'd have assumed the result set would have been stored in a parquet file and not read when zipping the export. "Hmmmmm" as they say, "interesting."
In any case, here it is. If you fix my mistakes and/or extend it pls post a reply w/ an updated export and we'll all pay it forward to new Incorta folks...
======Applied wherever there is a date field ==========
select
CountryRegionCode
, CountryRegionName
, date_add(modifieddate, ModifiedDateDaysUntil ) ModifiedDate
from OnlineStore.countryregion
JOIN
(select max(modifieddate) MaxOriginalModifiedDate
, datediff(current_date, max(modifieddate)) as ModifiedDateDaysUntil
from OnlineStore.address ) mxdt
ON 1 = 1
===========999================
-- IncortaOne@PMsquare.com --
.svg "Captain"){kind=icon}
.png "Community Manager"){kind=icon}
