Fungsi SQL BigQuery

Extracts an array of scalars from a native JSON value as ARRAY<STRING>.

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

Returns the last day of the specified period (month, quarter, or year).

Returns the last value in the window frame for each row.

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.