Illegal field name when using dbt_utils.pivot

I think your second argument might be incorrect? I don’t know what the original table structure is, but it looks like in the original code snippet your second argument to pivot is a date column and not a numeric.