Fungsi SQL BigQuery

Returns the sign of a number: -1, 0, or 1.

Menghitung nilai sinus dari sudut dalam radian.

Splits a string into an array based on a delimiter. Very useful for parsing CSV-style data.

Calculates the square root of a number.

Checks whether a string begins with a specified prefix. Returns a boolean.

Calculates the sample standard deviation of numeric values. Measures how spread out the data is from its mean. An alias for STDDEV_SAMP.

Calculates the population standard deviation of numeric values. Uses the N divisor formula (not N-1), suitable when the data represents an entire population.

Calculates the sample standard deviation of numeric values. Uses the N-1 divisor formula (Bessel's correction), suitable for sample data that represents a larger population.

Concatenates string values from multiple rows into a single string with a specified delimiter. Very useful for creating lists or comma-separated values in BigQuery.

Finds the first position of a substring within a string. A simplified version of INSTR.

Menghitung luas area dari objek GEOGRAPHY polygon dalam meter persegi.

Mengkonversi GEOGRAPHY ke GeoJSON string.

Mengkonversi GEOGRAPHY ke Well-Known Text (WKT) string.

Memeriksa apakah geography_1 sepenuhnya mengandung geography_2.

Menghitung jarak terpendek antara dua objek GEOGRAPHY dalam meter.

Membuat GEOGRAPHY dari Well-Known Text (WKT) string.

Membuat GEOGRAPHY point dari koordinat longitude dan latitude.

Memeriksa apakah dua objek GEOGRAPHY memiliki intersection (bersinggungan atau overlap).

Menghitung panjang total dari linestring atau perimeter polygon dalam meter.

Menggabungkan dua objek GEOGRAPHY menjadi satu. ST_UNION_AGG untuk aggregate.

Extracts a portion of characters from a string starting at a specified position. An alias for SUBSTRING, highly useful for data extraction and parsing.

Extracts a portion of characters from a string. Identical to SUBSTR, available for standard SQL compatibility.

Calculates the total sum of numeric values in a column. Supports multiple numeric types and is highly efficient for large-scale data analysis in BigQuery.

Menghitung nilai tangen dari sudut dalam radian.