Window

CONDITIONAL_TRUE_EVENT

Snowflake

Menghitung berapa kali kondisi berubah dari FALSE ke TRUE dalam window.

Tipe hasil: INTEGERDiperbarui: 6 Jan 2026

Syntax

SQL

CONDITIONAL_TRUE_EVENT(condition) OVER ([PARTITION BY ...] ORDER BY ...)

Parameter

conditionBOOLEANwajib

Kondisi untuk dievaluasi

Contoh Penggunaan

Count Login Events

SQL

1 SELECT
2   user_id,
3   event_time,
4   event_type,
5   CONDITIONAL_TRUE_EVENT(event_type = 'login') OVER (
6     PARTITION BY user_id
7     ORDER BY event_time
8   ) as login_count
9 FROM user_events;

Menghitung berapa kali user login.

Kembali ke Snowflake Functions

1	SELECT
2	user_id,
3	event_time,
4	event_type,
5	CONDITIONAL_TRUE_EVENT(event_type = 'login') OVER (
6	PARTITION BY user_id
7	ORDER BY event_time
8	) as login_count
9	FROM user_events;