All Functions (Alphabetical)¶
This topic provides a list of all Snowflake system-defined (i.e. built-in) functions, scalar or table, in alphabetical order.
The list includes:
The name of each function.
A summary of each function.
A list of the categories that the function belongs in.
Function Name |
Summary |
Category |
|---|---|---|
A |
||
Returns the absolute value of a numeric expression. |
||
Computes the inverse cosine (arc cosine) of its input; the result is a number in the interval |
||
Computes the inverse (arc) hyperbolic cosine of its input. |
||
Adds or subtracts a specified number of months to a date or timestamp, preserving the end-of-month information. |
||
Returns some value of the expression from the group. |
||
Uses HyperLogLog to return an approximation of the distinct cardinality of the input (i.e. |
||
Returns an approximated value for the desired percentile (i.e. if column |
||
Returns the internal representation of the t-Digest state (as a JSON object) at the end of aggregation. |
||
Combines (merges) percentile input states into a single output state. |
||
Returns the desired approximated percentile value for the specified t-Digest state. |
||
Uses Space-Saving to return an approximation of the most frequent values in the input, along with their approximate frequencies. |
||
Returns the Space-Saving summary at the end of aggregation. |
||
Combines (merges) input states into a single output state. |
||
Returns the approximate most frequent values and their estimated frequency for the given Space-Saving state. |
||
Returns an estimation of the similarity (Jaccard index) of inputs based on their MinHash states. |
||
Returns an estimation of the similarity (Jaccard index) of inputs based on their MinHash states. |
||
Returns the input values, pivoted into an ARRAY. |
Aggregate Functions , Window Functions , Semi-structured Data Functions |
|
Returns an array containing all elements from the source array as well as the new element. |
||
Returns a concatenation of two arrays. |
||
Returns a compacted array with missing and null values removed, effectively converting sparse arrays into dense arrays. |
||
Returns an array constructed from zero, one, or more inputs. |
||
Returns an array constructed from zero, one, or more inputs; the constructed array omits any NULL input values. |
||
Returns |
||
Returns an array containing all elements from the source array as well as the new element. |
||
Returns an array that contains the matching elements in the two input arrays. |
||
Returns the index of the first occurrence of an element in an array. |
||
Returns an array containing the new element as well as all elements from the source array. |
||
Returns the size of the input array. |
||
Returns an array constructed from a specified subset of elements of the input array. |
||
Returns an input array converted to a string by casting all values to strings (using TO_VARCHAR) and concatenating them (using the string from the second argument to separate the elements). |
||
Compares whether two arrays have at least one element in common. |
||
This family of functions can be used to perform strict casting of VARIANT values to other data types. |
||
Casts a VARIANT value to an array. |
||
Casts a VARIANT value to a binary string. |
||
Casts a VARIANT value to a BOOLEAN value. |
||
Casts a VARIANT value to a string. |
||
Casts a VARIANT value to a date. |
||
Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with optional precision and scale. |
||
Casts a VARIANT value to a floating-point value. |
||
Casts a VARIANT value to an integer. |
||
Casts a VARIANT value to an object. |
||
Casts a VARIANT value to a time value. |
||
Casts a VARIANT value to the respective TIMESTAMP value. |
||
Returns the ASCII code for the first character of a string. |
||
Computes the inverse sine (arc sine) of its argument; the result is a number in the interval |
||
Computes the inverse (arc) hyperbolic sine of its argument. |
||
Computes the inverse tangent (arc tangent) of its argument; the result is a number in the interval |
||
Computes the inverse tangent (arc tangent) of the ratio of its two arguments. |
||
Computes the inverse (arc) hyperbolic tangent of its argument. |
||
This table function is used for querying the Automatic Clustering history for given tables within a specified date range. |
||
Returns the average of non-NULL records. |
||
B |
||
Decodes a Base64-encoded string to a binary. |
||
Decodes a Base64-encoded string to a string. |
||
Encodes the input (string or binary) using Base64 encoding. |
||
Returns |
||
Returns the length of a string or binary value in bits. |
||
Returns the bitwise AND of two numeric expressions. |
||
Returns the bitwise AND value of all non-NULL numeric records in a group. |
Aggregate Functions , Window Functions , Bitwise Expression Functions |
|
Returns the bitwise negation of a numeric expression. |
||
Returns the bitwise OR of two numeric expressions. |
||
Returns the bitwise OR value of all non-NULL numeric records in a group. |
Aggregate Functions , Window Functions , Bitwise Expression Functions |
|
Shifts the bits for a numeric expression |
||
Shifts the bits for a numeric expression |
||
Returns the bitwise XOR of two numeric expressions. |
||
Returns the bitwise XOR value of all non-NULL numeric records in a group. |
Aggregate Functions , Window Functions , Bitwise Expression Functions |
|
Computes the Boolean AND of two numeric expressions. |
||
Returns the logical (boolean) |
Aggregate Functions , Window Functions , Conditional Expression Functions |
|
Computes the Boolean NOT of a single numeric expression. |
||
Computes the Boolean OR of two numeric expressions. |
||
Returns the logical (boolean) |
Aggregate Functions , Window Functions , Conditional Expression Functions |
|
Computes the Boolean XOR of two numeric expressions (i.e. one of the expressions, but not both expressions, is TRUE). |
||
Returns the logical (boolean) |
Aggregate Functions , Window Functions , Conditional Expression Functions |
|
C |
||
Works like a cascading “if-then-else” statement. |
||
Converts a value of one data type into another data type. |
||
Returns the cubic root of a numeric expression. |
||
Returns values from |
||
Searches for the first occurrence of the first argument in the second argument and, if successful, returns the position (1-based) of the first argument in the second argument. |
||
Checks the validity of a JSON document. |
||
Checks the validity of an XML document. |
||
Converts a Unicode code point (including 7-bit ASCII) into the character that matches the input Unicode. |
||
Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL. |
||
Returns a copy of the original string, but with the specified |
||
Returns the collation specification of the expression. |
||
Compresses the input string or binary value with a compression method. |
||
Concatenates one or more strings, or concatenates one or more binary values. |
||
Concatenates two or more strings, or concatenates two or more binary values. |
||
Returns a window event number for each row within a window partition when the value of the argument |
||
Returns a window event number for each row within a window partition based on the result of the boolean argument |
||
Returns true if |
||
Converts a timestamp to another time zone. |
||
This table function can be used to query Snowflake data loading history along various dimensions. |
||
Returns the correlation coefficient for non-null pairs in a group. |
||
Computes the cosine of its argument; the argument should be expressed in radians. |
||
Computes the hyperbolic cosine of its argument. |
||
Computes the cotangent of its argument; the argument should be expressed in radians. |
||
Returns either the number of non-NULL records for the specified columns, or the total number of records. |
||
Returns the population covariance for non-null pairs in a group. |
||
Returns the sample covariance for non-null pairs in a group. |
||
Finds the cumulative distribution of a value with regard to other values within the same window partition. |
||
Returns the account used by the user’s current session. |
||
Returns the version of the client from which the function was called. |
||
Returns the name of the database in use for the current session. |
||
Returns the current date of the system. |
||
Returns the name of the region for the account where the current user is logged in. |
||
Returns the name of the role in use for the current session. |
||
Returns the name of the schema in use by the current session. |
||
Returns active search path schemas. |
||
Returns a unique system identifier for the Snowflake session corresponding to the present connection. |
||
Returns the SQL text of the statement that is currently executing. |
||
Returns the current time for the system. |
||
Returns the current timestamp for the system. |
||
Returns the transaction id of an open transaction in the current session. |
||
Returns the name of the user currently logged into the system. |
||
Returns the current Snowflake version. |
||
Returns the name of the warehouse in use for the current session. |
||
D |
||
This table function can be used to query the history of data transferred from Snowflake tables into a different cloud storage provider’s network (i.e. from Snowflake on AWS, Google Cloud Platform, or Microsoft Azure into the other cloud provider’s network) and/or geographical region within a specified date range. |
||
Returns the refresh history for a secondary database. |
||
DATABASE_REFRESH_PROGRESS , DATABASE_REFRESH_PROGRESS_BY_JOB |
The DATABASE_REFRESH_PROGRESS family of functions can be used to query the status of a database refresh along various dimensions. |
|
This table function can be used to query the average daily storage usage, in bytes, for a single database (or all the databases in your account) within a specified date range. |
||
Creates a date from individual numeric components that represent the year, month, and day of the month. |
||
Extracts the specified date or time part from a date, time, or timestamp. |
||
Truncates a |
||
Adds the specified value for the specified date or time part to a date, time, or timestamp. |
||
Calculates the difference between two date, time, or timestamp expressions based on the date or time part requested. |
||
Extracts the three-letter day-of-week name from the specified date or timestamp. |
||
Compares the select expression to each search expression in order. |
||
Decompresses the compressed |
||
Decompresses the compressed |
||
Converts radians to degrees. |
||
Returns the rank of a value within a group of values, without gaps in the ranks. |
||
E |
||
Computes the Levenshtein distance between two input strings. |
||
Returns TRUE if the first expression ends with second expression. |
||
Compares whether two expressions are equal. |
||
Computes Euler’s number |
||
This function converts an EXPLAIN plan from JSON to a table. |
||
This table function can be used to query information about the staged data files included in the metadata for a specified external table. |
||
This table function can be used to query information about the metadata history for an external table. |
||
Extracts the specified date or time part from a date, time, or timestamp. |
||
F |
||
Computes the factorial of its input. |
||
Returns the first value within an ordered group of values. |
||
Flattens (explodes) compound values into multiple rows. |
||
Returns values from |
||
G |
||
Creates rows of data based either on a specified number of rows, a specified generation period (in seconds), or both. |
||
Extracts a value from an object or array; returns NULL if either of the arguments is NULL. |
||
Returns a DDL statement that can be used to recreate the specified object. |
||
Extracts a field value from an object; returns NULL if either of the arguments is NULL. |
||
Returns a list of objects that a specified object references. |
||
Extracts a value from semi-structured data using a path name. |
||
Returns the largest value from a list of expressions. |
||
Describes which of a list of expressions are grouped in a row produced by a GROUP BY query. |
||
Describes which of a list of expressions are grouped in a row produced by a GROUP BY query. |
||
H |
||
Returns a signed 64-bit hash value. |
||
Returns an aggregate signed 64-bit hash value over the (unordered) set of input rows. |
||
Calculates the great circle distance in kilometers between two points on the Earth’s surface, using the Haversine formula. |
||
Decodes a hex-encoded string to a binary. |
||
Decodes a hex-encoded string to a string. |
||
Encodes the input using hexadecimal (also ‘hex’ or ‘base16’) encoding. |
||
Uses HyperLogLog to return an approximation of the distinct cardinality of the input (i.e. |
||
Returns the HyperLogLog state at the end of aggregation. |
||
Combines (merges) input states into a single output state. |
||
Returns the cardinality estimate for the given HyperLogLog state. |
||
Converts input in BINARY format to OBJECT format. |
||
Converts input in OBJECT format to BINARY format. |
||
Extracts the corresponding time part from a time or timestamp value. |
||
I |
||
Single-level |
||
If |
||
Allows matching of strings based on comparison with a pattern. |
||
Allows case-insensitive matching of strings based on comparison with one or more patterns. |
||
Tests whether its argument is or is not one of the members of an explicit list or the result of a subquery. |
||
Returns the input string ( |
||
Replaces a substring of the specified length, starting at the specified position, with a new string or binary value. |
||
Compares whether two expressions are equal (or not equal). |
||
Determines whether an expression is NULL or is not NULL. |
||
This family of functions serves as Boolean predicates that can be used to determine the data type of a value stored in a VARIANT column. |
||
Returns TRUE if its VARIANT argument contains an ARRAY value. |
||
Returns TRUE if its VARIANT argument contains a binary string. |
||
Returns TRUE if its VARIANT argument contains a Boolean value. |
||
Returns TRUE if its VARIANT argument contains a string value. |
||
Verifies whether a VARIANT value contains a DATE value. |
||
Returns TRUE if its VARIANT argument contains a fixed-point decimal value or integer. |
||
Returns TRUE if its VARIANT argument contains a floating-point value, fixed-point decimal, or integer. |
||
Returns TRUE if its VARIANT argument contains an integer value. |
||
Returns true if its VARIANT argument is a JSON null value. |
Conditional Expression Functions , Semi-structured Data Functions |
|
Returns TRUE if its VARIANT argument contains an OBJECT value. |
||
Verifies whether a VARIANT value contains a TIME value. |
||
Verifies whether a VARIANT value contains the respective TIMESTAMP value. |
||
J |
||
Parses the first argument as a JSON string and returns the value of the element pointed to by the path in the second argument. |
||
K |
||
Returns the population excess kurtosis of non-NULL records. |
||
L |
||
Accesses data in a previous row in the same result set without having to join the table to itself. |
||
Returns the last day of the specified date part for a date or timestamp. |
||
Returns the ID of a specified query in the current session. |
||
Returns the transaction ID of the last transaction that was either committed or rolled back in the current session. |
||
Returns the last value within an ordered group of values. |
||
Accesses data in a subsequent row in the same result set without having to join the table to itself. |
||
Returns the smallest value from a list of expressions. |
||
Returns a leftmost substring of its input. |
||
Returns the length of an input string or binary value. |
||
Allows case-sensitive matching of strings based on comparison with a pattern. |
||
Allows case-sensitive matching of strings based on comparison with one or more patterns. |
||
Allows case-sensitive matching of strings based on comparison with one or more patterns. |
||
Returns the concatenated input values, separated by the |
||
Returns the natural logarithm of a numeric expression. |
||
Returns the current time for the system. |
||
Returns the current timestamp for the system. |
||
Returns the logarithm of a numeric expression. |
||
The LOGIN_HISTORY family of table functions can be used to query login attempts by Snowflake users along various dimensions. |
||
Returns the input string ( |
||
Left-pads a string with characters from another string, or left-pads a binary value with bytes from another binary value. |
||
Removes leading characters, including whitespace, from a string. |
||
M |
||
This table function is used for querying the materialized views refresh history for a specified materialized view within a specified date range. |
||
Returns a 32-character hex-encoded string containing the 128-bit MD5 message digest. |
||
Returns a 16-byte |
||
Returns the 128-bit MD5 message digest interpreted as a signed 128-bit big endian number. |
||
Determines the median of a set of values. |
||
Returns the minimum or maximum value for the records within |
||
Returns a MinHash state containing an array of size |
||
Combines input MinHash states into a single MinHash output state. |
||
Returns the remainder of input |
||
Returns the most frequent value for the values within |
||
Extracts the three-letter month name from the specified date or timestamp. |
||
N |
||
Returns the date of the first specified DOW (day of week) that occurs after the input date. |
||
Returns a normal-distributed floating point number, with specified |
||
Returns the nth value (up to 1000) within an ordered group of values. |
||
Divides an ordered data set equally into the number of buckets specified by |
||
Returns NULL if |
||
If |
||
Returns values depending on whether the first input is NULL. |
||
O |
||
Returns one OBJECT per group. |
Aggregate Functions , Window Functions , Semi-structured Data Functions |
|
Returns an OBJECT constructed from the arguments. |
||
Returns an object containing the contents of the input (i.e.source) object with one or more keys removed. |
||
Returns an object consisting of the input object with a new key-value pair inserted (or an existing key updated with a new value). |
||
Returns the length of a string or binary value in bytes. |
||
P |
||
Returns a JSON object consisting of all the components from a valid INET (Internet Protocol) or CIDR (Classless Internet Domain Routing) IPv4 or IPv6 string. |
||
Interprets an input string as a JSON document, producing a VARIANT value. |
||
Returns a JSON object consisting of all the components (fragment, host, path, port, query, scheme) in a valid input URL/URI. |
||
Interprets an input string as an XML document, producing an OBJECT value. |
||
Returns the relative rank of a value within a group of values. |
||
Return a percentile value based on a continuous distribution of the input column (specified in |
||
Returns a percentile value based on a discrete distribution of the input column (specified in |
||
Returns the value of pi as a floating-point value. |
||
This table function can be used to query the history of data loaded into Snowflake tables using Snowpipe within a specified date range. |
||
Searches for the first occurrence of the first argument in the second argument and, if successful, returns the position (1-based) of the first argument in the second argument. |
||
Returns a number (x) raised to the specified power (y). |
||
Returns the date of the first specified DOW (day of week) that occurs before the input date. |
||
Q |
||
The QUERY_HISTORY family of table functions can be used to query Snowflake query history along various dimensions. |
||
R |
||
Converts degrees to radians. |
||
Each call returns a pseudo-random 64-bit integer. |
||
Returns a random string of specified |
||
Returns the rank of a value within an ordered group of values. |
||
Returns the ratio of a value within a group to the sum of the values within the group. |
||
Returns true if the subject matches the specified pattern. |
||
Returns the number of times that a pattern occurs in a string. |
||
Returns the position of the specified occurrence of the regular expression pattern in the string subject. |
||
Returns true if the subject matches the pattern. |
||
Returns the subject with the specified pattern (or all occurrences of the pattern) either removed or replaced by a replacement string. |
||
Returns the substring that matches a regular expression within a string. |
||
Returns the average of the independent variable for non-null pairs in a group, where |
||
Returns the average of the dependent variable for non-null pairs in a group, where |
||
Returns the number of non-null number pairs in a group. |
||
Returns the intercept of the univariate linear regression line for non-null pairs in a group. |
||
Returns the coefficient of determination for non-null pairs in a group. |
||
Returns the slope of the linear regression line for non-null pairs in a group. |
||
Returns REGR_COUNT(y, x) * VAR_POP(x) for non-null pairs. |
||
Returns REGR_COUNT(expr1, expr2) * COVAR_POP(expr1, expr2) for non-null pairs. |
||
Returns REGR_COUNT(y, x) * VAR_POP(y) for non-null pairs. |
||
Returns NULL if the first argument is NULL; otherwise, returns the second argument. |
||
Returns NULL if the second argument is NULL; otherwise, returns the first argument. |
||
Builds a string by repeating the input for the specified number of times. |
||
Removes all occurrences of a specified substring, and optionally replaces them with another string. |
||
This table function can be used to query the replication history for a specified database within a specified date range. |
||
Returns the result set of a previous command (within 24 hours of when you executed the query) as if the result was a table. |
||
Reverses the order of characters in a string, or of bytes in a binary value. |
||
Returns a rightmost substring of its input. |
||
Returns true if the subject matches the specified pattern. |
||
Returns rounded values for |
||
Returns a unique row number for each row within a window partition. |
||
Right-pads a string with characters from another string, or right-pads a binary value with bytes from another binary value. |
||
Removes trailing characters, including whitespace, from a string. |
||
Returns the length of its argument, minus trailing whitespace, but including leading whitespace. |
||
S |
||
Returns a sequence of monotonically increasing integers, with wrap-around. |
||
Returns a 40-character hex-encoded string containing the 160-bit SHA-1 message digest. |
||
Returns a 20-byte binary containing the 160-bit SHA-1 message digest. |
||
Returns a hex-encoded string containing the N-bit SHA-2 message digest, where N is the specified output digest size. |
||
Returns a binary containing the N-bit SHA-2 message digest, where N is the specified output digest size. |
||
Returns the sign of its argument. |
||
Computes the sine of its argument; the argument should be expressed in radians. |
||
Computes the hyperbolic sine of its argument. |
||
Returns the sample skewness of non-NULL records. |
||
Returns a string that contains a phonetic representation of the input string. |
||
Builds a string consisting of the specified number of blank spaces. |
||
Splits a given string with a given separator and returns the result in an array of strings. |
||
Splits a given string at a specified character and returns the requested part. |
||
This table function splits a string (based on a specified delimiter) and flattens the results into rows. |
||
Returns the square-root of a non-negative numeric expression. |
||
Returns the square of a numeric expression, i.e. a numeric expression multiplied by itself. |
||
This table function can be used to query the average daily data storage usage, in bytes, for all the Snowflake stages in your account within a specified date range. |
||
Returns true if |
||
Returns the sample standard deviation (square root of sample variance) of non-NULL values. |
||
Returns the population standard deviation (square root of variance) of non-NULL values. |
||
Returns the sample standard deviation (square root of sample variance) of non-NULL values. |
||
Converts a JSON “null” value to a SQL NULL value. |
||
Tokenizes a given string and returns the requested part. |
||
Tokenizes a string with the given set of delimiters and flattens the results into rows. |
||
Tokenizes the given string using the given set of delimiters and returns the tokens as an array. |
||
Returns the portion of the string or binary value from |
||
Returns the sum of non-NULL records for |
||
Returns the current timestamp for the system, but in the UTC time zone. |
||
Aborts the specified session. |
||
Aborts the specified transaction, if it is running. |
||
Cancels all active/running queries in the specified session. |
||
Cancels the specified query (or statement) if it is currently active/running. |
||
Computes the average depth of the table according to the specified columns (or the clustering key defined for the table). |
||
Returns clustering information, including average clustering depth, for a table based on one or more columns in the table. |
||
Calculates the clustering ratio for a table, based on one or more columns in the table. |
||
Returns the name of the task currently executing when invoked from the statement or stored procedure defined by the task. |
||
Returns a JSON object showing the refresh history for a secondary database. |
||
SYSTEM$DATABASE_REFRESH_PROGRESS , SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB |
The SYSTEM$DATABASE_REFRESH_PROGRESS family of functions can be used to query the status of a database refresh along various dimensions. |
|
This function converts EXPLAIN output from JSON to formatted text. |
||
Given the text of a SQL statement, this function generates the EXPLAIN plan in JSON. |
||
Returns a new SCIM access token that is valid for six months. |
||
Returns an AWS IAM policy statement that must be added to the Amazon SNS topic policy in order to grant the Amazon SQS messaging queue created by Snowflake to subscribe to the topic. |
||
Retrieves the return value for the predecessor task in a tree of tasks. |
||
Returns the commit time of the last DML change performed on a table or a view. |
||
Forces a pipe paused using ALTER PIPE to resume. |
||
Retrieves a JSON representation of the current status of a pipe. |
||
Explicitly sets the return value for a task. |
||
Returns the client secrets in a string. |
||
Returns a timestamp indicating the transactional point when the stream contents were last consumed using a DML statement. |
||
Indicates whether a specified stream contains change data capture (CDC) records. |
||
Recursively resumes all dependent tasks tied to a specified root task. |
||
Returns a string representing the SQL data type associated with an expression. |
||
Aborts the next run of the specified task if the system had already started to process it (i.e. its state is EXECUTING). |
||
Determines whether your External OAuth access token is valid or has expired and needs to be regenerated. |
||
Waits for the specified amount of time before proceeding. |
||
Returns hostnames and port numbers to add to your firewall’s whitelist so that you can access Snowflake from behind your firewall. |
||
Returns hostnames and port numbers for AWS PrivateLink and Azure Private Link deployments to add to your firewall’s whitelist so that you can access Snowflake from behind your firewall. |
||
T |
||
Computes the tangent of its argument; the argument should be expressed in radians. |
||
Computes the hyperbolic tangent of its argument. |
||
This table function returns the list of child tasks for a given root (i.e. parent) task in a simple tree of tasks. |
||
This table function can be used to query the history of task usage within a specified date range. |
||
Creates a time from individual numeric components. |
||
Calculates the beginning or end of a “slice” of time, where the length of the slice is a multiple of a standard unit of time (minute, hour, day, etc.). |
||
Adds the specified value for the specified date or time part to a date, time, or timestamp. |
||
Calculates the difference between two date, time, or timestamp expressions based on the specified date or time part. |
||
Creates a timestamp from individual numeric components. |
||
Adds the specified value for the specified date or time part to a date, time, or timestamp. |
||
Calculates the difference between two date, time, or timestamp expressions based on the specified date or time part. |
||
Converts the input expression into an array. |
||
Converts the input expression to a binary value. |
||
Coverts the input text or numeric expression to a Boolean value. |
||
Converts the input expression to a string. |
||
Converts an input expression to a date. |
||
Converts an input expression to a fixed-point number. |
||
Converts an expression to a double-precision floating-point number. |
||
Converts any VARIANT value to a string containing the JSON representation of the value. |
||
Converts the input value to an object. |
||
Converts an input expression into a time. |
||
Converts an input expression into the corresponding timestamp. |
||
Converts any value to VARIANT value or NULL (if input is NULL). |
||
Converts any VARIANT value to a string containing the XML representation of the value. |
||
Translates |
||
Removes leading and trailing characters from a string. |
||
Rounds the input expression down to the nearest (or equal) integer closer to zero, or to the nearest equal or smaller value with the specified number of places after the decimal point. |
||
Truncates a date, time, or timestamp to the specified part. |
||
A special version of BASE64_DECODE_BINARY that returns a NULL value if an error occurs during decoding. |
||
A special version of BASE64_DECODE_STRING that returns a NULL value if an error occurs during decoding. |
||
A special version of CAST , :: that is available for a subset of data type conversions. |
||
A special version of HEX_DECODE_BINARY that returns a NULL value if an error occurs during decoding. |
||
A special version of HEX_DECODE_STRING that returns a NULL value if an error occurs during decoding. |
||
A special version of PARSE_JSON that returns a NULL value if an error occurs during parsing. |
||
A special version of TO_BINARY that performs the same operation (i.e. converts an input expression to a binary value), but with error handling support (i.e. if the conversion cannot be performed, it returns a NULL value instead of raising an error). |
||
A special version of TO_BOOLEAN that performs the same operation (i.e. converts an input expression to a Boolean value), but with error-handling support (i.e. if the conversion cannot be performed, it returns a NULL value instead of raising an error). |
||
A special version of TO_DATE , DATE that performs the same operation (i.e. converts an input expression to a date), but with error-handling support (i.e. if the conversion cannot be performed, it returns a NULL value instead of raising an error). |
||
A special version of TO_DECIMAL , TO_NUMBER , TO_NUMERIC that performs the same operation (i.e. converts an input expression to a fixed-point number), but with error-handling support (i.e if the conversion cannot be performed, it returns a NULL value instead of raising an error). |
||
A special version of TO_DOUBLE that performs the same operation (i.e. converts an input expression to a double-precision floating-point number), but with error-handling support (i.e. if the conversion cannot be performed, it returns a NULL value instead of raising an error). |
||
A special version of TO_TIME , TIME that performs the same operation (i.e. converts an input expression into a time), but with error-handling support (i.e. if the conversion cannot be performed, it returns a NULL value instead of raising an error). |
||
A special version of TO_TIMESTAMP / TO_TIMESTAMP_* that performs the same operation (i.e. converts an input expression into a timestamp), but with error-handling support (i.e. if the conversion cannot be performed, it returns a NULL value instead of raising an error). |
||
Reports the type of a value stored in a VARIANT column. |
||
U |
||
Returns the Unicode code point for the first Unicode character in a string. |
||
Returns a uniformly random number, in the inclusive range [ |
||
Returns the input string |
||
Generates either a version 4 (random) or version 5 (named) RFC 4122-compliant UUID as a formatted string. |
||
V |
||
Validates the files loaded in a past execution of the COPY INTO <table> command and returns all the errors encountered during the load, rather than just the first error. |
||
This table function can be used to validate data files processed by Snowpipe within a specified time range. |
||
Returns the population variance of non-NULL records in a group. |
||
Returns the sample variance of non-NULL records in a group. |
||
Returns the sample variance of non-NULL records in a group. |
||
Returns the population variance of non-NULL records in a group. |
||
W |
||
This table function can be used to query the activity history (defined as the “query load”) for a single warehouse within a specified date range. |
||
This table function can be used in queries to return the hourly credit usage for a single warehouse (or all the warehouses in your account) within a specified date range. |
||
Constructs equi-width histograms, in which the histogram range is divided into intervals of identical size, and returns the bucket number into which the value of an expression falls, after it has been evaluated. |
||
X |
||
Extracts an XML element object (often referred to as simply a “tag”) from a content of outer XML element object by the name of the tag and its instance number (counting from 0). |
||
Y |
||
Extracts the corresponding date part from a date or timestamp. |
||
Z |
||
Returns 0 if its argument is null; otherwise, returns its argument. |
||
Returns a Zipf-distributed integer, for |