DISTINCT ON syntax does not work on Snowflake

[steven-luabase]

In the stripe__daily_overview model distinct on is used, but this syntax is not compatible with Snowflake:

airbyte_dbt_stripe/models/stripe__daily_overview.sql

Lines 49 to 62 in 6887a14

	select distinct on (subscription_payments.subscription_id)
	subscription_payments.date,
	subscription_id,
	status,
	customer_email,
	canceled_at
	from
	subscription_payments
	where
	subscription_payments.date <= date_trunc('day', dt.date)
	order by
	subscription_id,
	date desc
	) as filtered_subs