Pretty similar feature wise and intended use, I did a direct comparison and went for Metabase because it allows you to schedule reports delivered to email/slack (only allows you to schedule individual queries, not entire dashboards).

I didn't demo redash so can't comment on the actual use comparison.