How can I add generated forecast data to a fact table?

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!