The problem I’m having
What is the technique for creatiing payroll forecast accruals?
The context of why I’m trying to do this
I have ADP sourced payroll data. I want to forecast a rolling 12 months foward. I receive a payroll csv with daily data. I use ADF to ingest the file, insert into a Snowflake staging table and create a fact table. How would I add future accruals into the fact table?
What I’ve already tried
Some example code or error messages
Put code inside backticks to preserve indentation which is especially important for Python and YAML!