Create a field that counts and groups “chains” of dates within +/- 3 days of each other in SQL. (Translate from PEEK function in QlikSense)

New to SQL and trying to translate a QlikSense calculation into Snowflake SQL