Fungsi SQL BigQuery

Converts a JSON value to BOOL using flexible, lax type conversion.

Converts a JSON value to FLOAT64 using flexible, lax type conversion.

Converts a JSON value to INT64 using flexible, lax type conversion.

Converts a JSON value to STRING using flexible, lax type conversion.

Accesses a value from a subsequent row in the partition based on the specified offset.

Mengembalikan nilai terkecil dari daftar ekspresi.

Extracts a specified number of characters from the left (beginning) of a string. A more readable shorthand than SUBSTR for extracting leading characters.

Returns the number of characters in a string. For BYTES, returns the number of bytes.

Calculates the natural logarithm (base e) of a number.

Calculates the logarithm with a configurable base.

Calculates the base-10 logarithm (common logarithm).

Returns TRUE if ALL values in the group are TRUE. Acts as an aggregated AND operator, useful for verifying that every condition in a set is met.

Returns TRUE if AT LEAST ONE value in the group is TRUE. Acts as an aggregated OR operator, useful for checking whether any condition in a set is met.

Converts all characters in a string to lowercase. Supports Unicode characters.

Pads the left side of a string with characters until it reaches a specified length. Left padding.

Removes characters from the left side (beginning) of a string. Left trim for leading characters.

Membuat DATE dari komponen year, month, dan day.

Returns the maximum value from a column or expression. Supports numeric, string, date/time, and boolean types in BigQuery.

Menghitung MD5 hash dari input. Return BYTES.

Returns the minimum value from a column or expression. Supports numeric, string, date/time, and boolean types in BigQuery.