Redshift SQL query to populate calendar date table

I am trying to write a redshift sql query to populate a table with dates for 50 years of dates, calculate working days, weekly, monthly calculations etc. I have tried CTE and Recursive methods, but it seems I have some restrictions in my environment and they were not working.

Is there any alternatives? Or am I missing anything?