I looked around for scripts to create a Date Dimension table for our warehouse and they were all way more complex and platform specific than they needed to be. Thinking of it as an extractor allowed me to implement in a fairly small number of lines of code, and to actually create the table becomes a trivial ETL.
I intentionally left holidays and fiscal periods out of the Extraction since they vary from country to country and company to company. I expect holidays and fiscal would either be implemented as Transform or would be entered into the resulting Date Dimension table manually. The manual option is made more practical with the option in #32 which adds an option to InsertUpdate to only add new rows and not overwrite them.
Hi @kdebisschop . We forked the library here and we fixed some issues and added some features. The changelog is available here. Our objective is to keep this great library alive. If you find any bug or want to contribute to keep the package alive, do not hesitate!
ecourtial
commented
4 years ago
I looked around for scripts to create a Date Dimension table for our warehouse and they were all way more complex and platform specific than they needed to be. Thinking of it as an extractor allowed me to implement in a fairly small number of lines of code, and to actually create the table becomes a trivial ETL.
I intentionally left holidays and fiscal periods out of the Extraction since they vary from country to country and company to company. I expect holidays and fiscal would either be implemented as Transform or would be entered into the resulting Date Dimension table manually. The manual option is made more practical with the option in #32 which adds an option to InsertUpdate to only add new rows and not overwrite them.