Built-in functions

Translation reference for all the supported built-in functions by SnowConvert for BigQuery.

For more information about built-in functions and their Snowflake equivalents, also see Common built-in functions.

Aggregate Functions

BigQuery	Snowflake
ANY_VALUE	ANY_VALUE Note: Unlike BigQuery, Snowflake does not ignore NULLs . Additionally, Snowflake's OVER() clause does not support the use of ORDER BY or explicit window frames.
ANY_VALUE( expr1, HAVING MAX expr2) ANY_VALUE( expr1, HAVING MIN expr2)	MAX_BY(expr1, expr1) MIN_BY(expr1, expr2)
AVG	AVG
COUNT	COUNT
COUNTIF	COUNT_IF
LOGICAL_AND	BOOLAND_AGG
LOGICAL_OR	BOOLOR_AGG
MAX	MAX
MIN	MIN
SUM	SUM

Conditional Expressions

BigQuery	Snowflake
COALESCE	COALESCE
IF	IFF
IFNULL	IFNULL
NULLIF	NULLIF

Conversion Functions

BigQuery	Snowflake
SAFE_CAST	TRY_CAST

Date Functions

BigQuery	Snowflake
CURRENT_DATE CURRENT_DATE()	CURRENT_DATE CURRENT_DATE()
FORMAT_DATE	TO_CHAR Note: For further details on this translation, please consult this page.

Datetime Functions

BigQuery	Snowflake
CURRENT_DATETIME CURRENT_DATETIME()	CURRENT_TIMESTAMP :: TIMESTAMP_NTZ CURRENT_TIMESTAMP() :: TIMESTAMP_NTZ

Geography Functions

BigQuery	Snowflake
ST_GEOGFROMTEXT	ST_GEOGFROMTEXT Note: For further details on this translation, please consult this page.
ST_GEOGPOINT	ST_POINT Note: For further details on this translation, please consult this page.

JSON Functions

BigQuery	Snowflake
JSON_VALUE / JSON_EXTRACT_SCALAR	JSON_EXTRACT_PATH_TEXT Notes: SnowConvert automatically translates BigQuery JSON paths to their Snowflake equivalents.
LAX_INT64	PUBLIC.LAX_INT64_UDF Notes: SnowConvert generates a UDF to obtain an equivalent behavior.
LAX_BOOL	PUBLIC.LAX_BOOL_UDF Notes: SnowConvert generates a UDF to obtain an equivalent behavior.

Mathematical Functions

BigQuery	Snowflake
ABS	ABS
LEAST	LEAST
MOD	MOD
ROUND(X) ROUND(X, Y) ROUND(X, Y, 'ROUND_HALF_EVEN') ROUND(X, Y, 'ROUND_HALF_AWAY_FROM_ZERO')	ROUND(X) ROUND(X, Y) ROUND(X, Y, 'HALF_TO_EVEN') ROUND(X, Y, 'HALF_AWAY_FROM_ZERO')

Navigation Functions

BigQuery	Snowflake
FIRST_VALUE	FIRST_VALUE
LAG	LAG
LEAD	LEAD
LAST_VALUE	LAST_VALUE

Numbering Functions

BigQuery	Snowflake
RANK	RANK
ROW_NUMBER	ROW_NUMBER

String Functions

BigQuery	Snowflake
CHARACTER_LENGTH CHAR_LENGTH	LENGTH
CONCAT	CONCAT
FROM_BASE64	TRY_BASE64_DECODE_BINARY Notes: BigQuery defaults to BASE64 for binary data output, but Snowflake uses HEX. In Snowflake, you can use the BASE64_ENCODE function or set BINARY_OUTPUT_FORMAT to 'BASE64' to view binary data in BASE64.
FROM_HEX	TRY_HEX_DECODE_BINARY Notes: BigQuery defaults to BASE64 for binary data output, but Snowflake uses HEX. In Snowflake, you can use the BASE64_ENCODE function or set BINARY_OUTPUT_FORMAT to 'BASE64' to view binary data in BASE64.
LEFT	LEFT
LENGTH	LENGTH
LOWER	LOWER
LPAD	LPAD
LTRIM	LTRIM
STARTS_WITH	STARTSWITH
REPLACE	REPLACE
RIGHT	RIGHT
RPAD	RPAD
RTRIM	RTRIM
SPLIT	SPLIT
SUBSTR(string, position) SUBSTRING(string, position) SUBSTR(sttring, position, length) SUBSTRING(sttring, position, length)	SUBSTR(string, IFF(position < -LENGTH(string), 1, position)) SUBSTRING(string, IFF(position < -LENGTH(string), 1, position)) SUBSTR(sttring, IFF(position < -LENGTH(string), 1, position), length) SUBSTRING(sttring, IFF(position < -LENGTH(string), 1, position), length)
UPPER	UPPER

Timestamp Functions

BigQuery	Snowflake
CURRENT_TIMESTAMP CURRENT_TIMESTAMP()	CURRENT_TIMESTAMP CURRENT_TIMESTAMP()