By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Redshift SQL query to populate calendar date table

0

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?

Topics
Analytics
Tags
Amazon Redshift
Language
English
AK
asked 18 days ago80 views
1 Answer
0

Please see this post for a detailed example: https://elliotchance.medium.com/building-a-date-dimension-table-in-redshift-6474a7130658

AWS
Don_D
answered 17 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content