JSON

IS_BOOLEAN

Snowflake

Mengecek apakah nilai VARIANT adalah boolean.

Tipe hasil: BOOLEANDiperbarui: 6 Jan 2026

Syntax

SQL

IS_BOOLEAN(variant_expression)

variant_expressionVARIANTwajib

VARIANT untuk dicek

SQL

1 SELECT
2   IS_BOOLEAN(PARSE_JSON('true')) as json_bool,
3   IS_BOOLEAN(PARSE_JSON('"true"')) as json_string;

Boolean vs string.

Hasil

json_bool: TRUE, json_string: FALSE

1	SELECT
2	IS_BOOLEAN(PARSE_JSON('true')) as json_bool,
3	IS_BOOLEAN(PARSE_JSON('"true"')) as json_string;