All Functions (Alphabetical)¶
This topic provides a list of all Snowflake systemdefined (i.e. builtin) 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 endofmonth 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 tDigest 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 tDigest state. 

Uses SpaceSaving to return an approximation of the most frequent values in the input, along with their approximate frequencies. 

Returns the SpaceSaving 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 SpaceSaving 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 , Semistructured 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. 

Halfopen intervals are denoted with one square bracket and one parenthesis. 

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 fixedpoint decimal (does not match floatingpoint values), with optional precision and scale. 

Casts a VARIANT value to a floatingpoint 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 (i.e. 

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 nonNULL records. 

B 

Decodes a Base64encoded string to a binary. 

Decodes a Base64encoded 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 nonNULL 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 nonNULL 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 nonNULL 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 “ifthenelse” 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 (1based) 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 7bit ASCII) into the character that matches the input Unicode. 

Returns the first nonNULL 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 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 nonnull 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 nonNULL records for the specified columns, or the total number of records. 

Returns the population covariance for nonnull pairs in a group. 

Returns the sample covariance for nonnull pairs in a group. 

Finds the cumulative distribution of a value with regard to other values within the same window partition. 

Returns the account of the user currently logged into the system. 

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 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 threeletter dayofweek 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 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 semistructured 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 64bit hash value. 

Returns an aggregate signed 64bit hash value over the (unordered) set of input rows. 
Aggregate Functions , Window Functions , Utility & Hash Functions 

Calculates the great circle distance in kilometers between two points on the Earth’s surface, using the Haversine formula. 

Decodes a hexencoded string to a binary. 

Decodes a hexencoded 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 

Singlelevel 

If 

Allows matching of strings based on comparison with a pattern. 

Allows caseinsensitive 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 fixedpoint decimal value or integer. 

Returns TRUE if its VARIANT argument contains a floatingpoint value, fixedpoint 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 , Semistructured 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. 

K 

Returns the population excess kurtosis of nonNULL 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 a input string or binary value. 

Allows casesensitive matching of strings based on comparison with a pattern. 

Allows casesensitive matching of strings based on comparison with one or more patterns. 

Allows casesensitive 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 ( 

Leftpads a string with characters from another string, or leftpads 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 32character hexencoded string containing the 128bit MD5 message digest. 

Returns a 16byte 

Returns the 128bit MD5 message digest interpreted as a signed 128bit 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 threeletter 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 normaldistributed 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 , Semistructured 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 keyvalue 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 floatingpoint 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 (1based) 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 pseudorandom 64bit 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 nonnull pairs in a group, where 

Returns the average of the dependent variable for nonnull pairs in a group, where 

Returns the number of nonnull number pairs in a group. 

Returns the intercept of the univariate linear regression line for nonnull pairs in a group. 

Returns the coefficient of determination for nonnull pairs in a group. 

Returns the slope of the linear regression line for nonnull pairs in a group. 

Returns REGR_COUNT(y, x) * VAR_POP(x) for nonnull pairs. 

Returns REGR_COUNT(expr1, expr2) * COVAR_POP(expr1, expr2) for nonnull pairs. 

Returns REGR_COUNT(y, x) * VAR_POP(y) for nonnull 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. 

Rightpads a string with characters from another string, or rightpads 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 wraparound. 

Returns a 40character hexencoded string containing the 160bit SHA1 message digest. 

Returns a 20byte binary containing the 160bit SHA1 message digest. 

Returns a hexencoded string containing the Nbit SHA2 message digest, where N is the specified output digest size. 

Returns a binary containing the Nbit SHA2 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 nonNULL 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 and returns the requested part. 

This table function splits a string (based on a specified delimiter) and flattens the results into rows. 

Returns the squareroot of a nonnegative 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 nonNULL values. 

Returns the population standard deviation (square root of variance) of nonNULL values. 

Returns the sample standard deviation (square root of sample variance) of nonNULL 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 nonNULL records for 

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. 

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 enables 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). 

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 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 fixedpoint number. 

Converts an expression to a doubleprecision floatingpoint 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 errorhandling 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 that performs the same operation (i.e. converts an input expression to a date), but with errorhandling 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 fixedpoint number), but with errorhandling 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 doubleprecision floatingpoint number), but with errorhandling 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 that performs the same operation (i.e. converts an input expression into a time), but with errorhandling 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 errorhandling 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 4122compliant 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 nonNULL records in a group. 

Returns the sample variance of nonNULL records in a group. 

Returns the sample variance of nonNULL records in a group. 

Returns the population variance of nonNULL 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 equiwidth 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 Zipfdistributed integer, for 