使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
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?

主题
分析
标签
Amazon Redshift
语言
English
AK
已提问 1 个月前139 查看次数
1 回答
0

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

AWS
Don_D
已回答 1 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。

回答问题的准则

相关内容