<div dir="ltr"><div>Typically these types of queries make use of the DATE_DIM. However Counting weekdays within a data range can be accomplished without the use of DIM_DATE:</div><div><br></div><div><a href="https://medium.com/snowflake/counting-weekdays-snowflake-tidbit-of-the-day-c6eb30f847c1">https://medium.com/snowflake/counting-weekdays-snowflake-tidbit-of-the-day-c6eb30f847c1</a></div></div>