Creating a macro that runs monthly and deletes old data?

[13howardD]

I want to create a macro that runs monthly and removes older intermediate data. So I want to target any of my models that starts with int_ and delete data older than 6 months. What’s the best way to implement this?

[a_slack_user]

Rather than delete data, could you add a time constraint to your materialization? date(event_timestamp) > DATEADD(month2, 6URRENT_DATE())

_{Note: @Troy Carpenter originally posted this reply in Slack. It might not have transferred perfectly.}