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 | ||
| ABS | Returns the absolute value of a numeric expression. | Numeric functions |
| ACOS | Computes the inverse cosine (arc cosine) of its input; the result is a number in the interval [0, pi]. | Numeric functions |
| ACOSH | Computes the inverse (arc) hyperbolic cosine of its input. | Numeric functions |
| ADD_MONTHS | Adds or subtracts a specified number of months to a date or timestamp, preserving the end-of-month information. | Date & time functions |
| AGENT_RUN (SNOWFLAKE.CORTEX) | Runs a Cortex Agent without an agent object and returns the response as JSON. | String & binary functions |
| AGG | Evaluates and returns the value of a metric in a semantic view when you run a query. | Aggregate functions |
| AI_AGG | Reduces a column of text data using a natural language instruction. | Aggregate functions , String & binary functions |
| AI_CLASSIFY | Classifies text or images into categories that you specify. | String & binary functions |
| AI_COMPLETE (Prompt object) | Generates a response (completion) for a prompt object. | String & binary functions |
| AI_COMPLETE (Single image) | Generates a response (completion) for a text prompt using a supported language model. | String & binary functions |
| AI_COMPLETE (Single string) | Generates a response (completion) for a text prompt using a supported language model. | String & binary functions |
| AI_COMPLETE | Generates a response (completion) from text or an image using a supported language model. | String & binary functions , File functions |
| AI_COUNT_TOKENS | Returns an estimate of the number of tokens in a prompt for the specified large language model or task-specific function. | String & binary functions |
| AI_EMBED | Creates an embedding vector from text or an image. | String & binary functions |
| AI_EXTRACT (Document AI legacy models) | Extracts information from a file using a legacy Document AI model. | String & binary functions |
| AI_EXTRACT | Extracts information from an input string or file. | String & binary functions |
| AI_FILTER | Classifies free-form prompt inputs into a boolean. | String & binary functions |
| AI_PARSE_DOCUMENT | Returns the extracted content from a document on a Snowflake stage as a JSON-formatted string. | String & binary functions |
| AI_REDACT | Detects and redacts personally identifiable information (PII) from unstructured text data. | String & binary functions |
| AI_SENTIMENT | Returns overall and category sentiment in the given input text. | String & binary functions |
| AI_SIMILARITY | Computes a similarity score based on the vector cosine similarity value of the inputs’ embedding vectors. | String & binary functions |
| AI_SUMMARIZE_AGG | Summarizes a column of text data. | Aggregate functions , String & binary functions |
| AI_TRANSCRIBE | Transcribes text from an audio or video file with optional timestamps and speaker labels. | File functions |
| AI_TRANSLATE | Translates the given input text from one supported language to another. | String & binary functions |
| ALERT_HISTORY | This INFORMATION_SCHEMA table function can be used to query the history of alerts within a specified date range. | Information Schema , Table functions |
| ALL_USER_NAMES | Returns all user names in the current account. | Context functions |
| ANY_VALUE | Returns some value of the expression from the group. | Aggregate functions , Window functions |
| APPLICATION_CALLBACK_HISTORY | Returns information about the history of callback invocations for Snowflake Native Apps in your Snowflake account. | Information Schema , Table functions |
| APPLICATION_CONFIGURATION_VALUE_HISTORY | Table functions (Tables) | Table functions (Tables) |
| APPLICATION_JSON | Returns a JSON object that specifies the JSON message to use for a notification. | Notification functions |
| APPLICATION_SPECIFICATION_STATUS_HISTORY | Returns information about the history of the status changes for app specifications in your Snowflake account. | Information Schema , Table functions |
| APPROX_COUNT_DISTINCT | Uses HyperLogLog to return an approximation of the distinct cardinality of the input (i.e. HLL(col1, col2, ... ) returns an approximation of COUNT(DISTINCT col1, col2, ... )). | Aggregate functions , Window functions |
| APPROX_PERCENTILE | Returns an approximated value for the desired percentile (that is, if column c has n numbers, APPROX_PERCENTILE(c, p) returns a number such that approximately n * p of the numbers in c are smaller than the returned number). | Aggregate functions , Window functions |
| APPROX_PERCENTILE_ACCUMULATE | Returns the internal representation of the t-Digest state (as a JSON object) at the end of aggregation. | Aggregate functions , Window function syntax and usage |
| APPROX_PERCENTILE_COMBINE | Combines (merges) percentile input states into a single output state. | Aggregate functions , Window function syntax and usage |
| APPROX_PERCENTILE_ESTIMATE | Returns the desired approximated percentile value for the specified t-Digest state. | Aggregate functions , Window function syntax and usage |
| APPROX_TOP_K | Uses Space-Saving to return an approximation of the most frequent values in the input, along with their approximate frequencies. | Aggregate functions , Window functions |
| APPROX_TOP_K_ACCUMULATE | Returns the Space-Saving summary at the end of aggregation. | Aggregate functions , Window function syntax and usage |
| APPROX_TOP_K_COMBINE | Combines (merges) input states into a single output state. | Aggregate functions , Window function syntax and usage |
| APPROX_TOP_K_ESTIMATE | Returns the approximate most frequent values and their estimated frequency for the given Space-Saving state. | Aggregate functions , Window function syntax and usage |
| APPROXIMATE_JACCARD_INDEX | Returns an estimation of the similarity (Jaccard index) of inputs based on their MinHash states. | Aggregate functions , Window functions |
| APPROXIMATE_SIMILARITY | Returns an estimation of the similarity (Jaccard index) of inputs based on their MinHash states. | Aggregate functions , Window function syntax and usage |
| ARRAY_AGG | Returns the input values, pivoted into an array. | Aggregate functions , Window functions , Semi-structured and structured data functions |
| ARRAY_APPEND | Returns an array containing all elements from the source array as well as the new element. | Semi-structured and structured data functions |
| ARRAY_CAT | Returns a concatenation of two arrays. | Semi-structured and structured data functions |
| ARRAY_COMPACT | Returns a compacted array with missing and null values removed, effectively converting sparse arrays into dense arrays. | Semi-structured and structured data functions |
| ARRAY_CONSTRUCT | Returns an array constructed from zero, one, or more inputs. | Semi-structured and structured data functions |
| ARRAY_CONSTRUCT_COMPACT | Returns an array constructed from zero, one, or more inputs; the constructed array omits any NULL input values. | Semi-structured and structured data functions |
| ARRAY_CONTAINS | Returns TRUE if the specified value is found in the specified array. | Semi-structured and structured data functions |
| ARRAY_DISTINCT | Returns a new ARRAY that contains only the distinct elements from the input ARRAY. | Semi-structured and structured data functions |
| ARRAY_EXCEPT | Returns a new ARRAY that contains the elements from one input ARRAY that are not in another input ARRAY. | Semi-structured and structured data functions |
| ARRAY_FLATTEN | Flattens an ARRAY of ARRAYs into a single ARRAY. | Semi-structured and structured data functions |
| ARRAY_GENERATE_RANGE | Returns an ARRAY of integer values within a specified range (e.g. [2, 3, 4]). | Semi-structured and structured data functions |
| ARRAY_INSERT | Returns an array containing all elements from the source array as well as the new element. | Semi-structured and structured data functions |
| ARRAY_INTERSECTION | Returns an array that contains the matching elements in the two input arrays. | Semi-structured and structured data functions |
| ARRAY_MAX | Given an input ARRAY, returns the element with the highest value that is not a SQL NULL. | Semi-structured and structured data functions |
| ARRAY_MIN | Given an input ARRAY, returns the element with the lowest value that is not a SQL NULL. | Semi-structured and structured data functions |
| ARRAY_POSITION | Returns the index of the first occurrence of an element in an array. | Semi-structured and structured data functions |
| ARRAY_PREPEND | Returns an array containing the new element as well as all elements from the source array. | Semi-structured and structured data functions |
| ARRAY_REMOVE | Given a source ARRAY, returns an ARRAY with elements of the specified value removed. | Semi-structured and structured data functions |
| ARRAY_REMOVE_AT | Given a source ARRAY, returns an ARRAY with the element at the specified position removed. | Semi-structured and structured data functions |
| ARRAY_REVERSE | Returns an array with the elements of the input array in reverse order. | Semi-structured and structured data functions |
| ARRAY_SIZE | Returns the size of the input array. | Semi-structured and structured data functions |
| ARRAY_SLICE | Returns an array constructed from a specified subset of elements of the input array. | Semi-structured and structured data functions |
| ARRAY_SORT | Returns an ARRAY that contains the elements of the input ARRAY sorted in ascending or descending order. | Semi-structured and structured data functions |
| ARRAY_TO_STRING | 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). | Semi-structured and structured data functions |
| ARRAY_UNION_AGG | Returns an ARRAY that contains the union of the distinct values from the input arrays in a column. | Aggregate functions , Window functions |
| ARRAY_UNIQUE_AGG | Returns an ARRAY that contains all of the distinct values from the specified column. | Aggregate functions , Window functions |
| ARRAYS_OVERLAP | Compares whether two arrays have at least one element in common. | Semi-structured and structured data functions |
| ARRAYS_TO_OBJECT | Returns an OBJECT that contains the keys specified by one input ARRAY and the values specified by another input ARRAY. | Semi-structured and structured data functions |
| ARRAYS_ZIP | Returns an array of objects, each of which contains key-value pairs for an nth element in the input arrays. | Semi-structured and structured data functions |
| AS_*<object_type>* | You can use this family of functions to perform strict casting of VARIANT values to values of other data types. | Semi-structured and structured data functions |
| AS_ARRAY | Casts a VARIANT value to an ARRAY value. | Semi-structured and structured data functions |
| AS_BINARY | Casts a VARIANT value to a BINARY value. | Semi-structured and structured data functions |
| AS_BOOLEAN | Casts a VARIANT value to a BOOLEAN value. | Semi-structured and structured data functions |
| AS_CHAR , AS_VARCHAR | Casts a VARIANT value to a VARCHAR value. | Semi-structured and structured data functions |
| AS_DATE | Casts a VARIANT value to a DATE value. | Semi-structured and structured data functions |
| AS_DECIMAL , AS_NUMBER | Casts a VARIANT value to a fixed-point NUMBER value, with optional precision and scale. | Semi-structured and structured data functions |
| AS_DOUBLE , AS_REAL | Casts a VARIANT value to a floating-point value. | Semi-structured and structured data functions |
| AS_INTEGER | Casts a VARIANT value to an INTEGER. | Semi-structured and structured data functions |
| AS_OBJECT | Casts a VARIANT value to an OBJECT value. | Semi-structured and structured data functions |
| AS_TIME | Casts a VARIANT value to a TIME value. | Semi-structured and structured data functions |
| AS_TIMESTAMP_* | Casts a VARIANT value to the respective timestamp value. | Semi-structured and structured data functions |
| ASCII | Returns the ASCII code for the first character of a string. | String & binary functions |
| ASIN | Computes the inverse sine (arc sine) of its argument; the result is a number in the interval [-pi/2, pi/2]. | Numeric functions |
| ASINH | Computes the inverse (arc) hyperbolic sine of its argument. | Numeric functions |
| ATAN | Computes the inverse tangent (arc tangent) of its argument; the result is a number in the interval [-pi, pi]. | Numeric functions |
| ATAN2 | Computes the inverse tangent (arc tangent) of the ratio of its two arguments. | Numeric functions |
| ATANH | Computes the inverse (arc) hyperbolic tangent of its argument. | Numeric functions |
| AUTO_REFRESH_REGISTRATION_HISTORY | This table function can be used to query the history of data files registered in the metadata for a specified external table or directory table and the credits billed for these operations. | Information Schema , Table functions |
| AUTOMATIC_CLUSTERING_HISTORY | This table function is used for querying the Automatic Clustering history for given tables within a specified date range. | Information Schema , Table functions |
| AVAILABLE_LISTING_REFRESH_HISTORY | Returns the past 14 days of refresh history for an available listing or a database mounted from a listing using cross-cloud auto-fulfillment. | Information Schema , Table functions |
| AVAILABLE_LISTINGS | Returns all listings that are available for the consumer to discover and access. | Information Schema , Table functions |
| AVG | Returns the average of non-NULL records. | Aggregate functions , Window functions |
| B | ||
| BASE64_DECODE_BINARY | Decodes a Base64-encoded string to a binary. | String & binary functions |
| BASE64_DECODE_STRING | Decodes a Base64-encoded string to a string. | String & binary functions |
| BASE64_ENCODE | Encodes the input (string or binary) using Base64 encoding. | String & binary functions |
| [ NOT ] BETWEEN | Returns TRUE when the input expression (numeric or string) is within the specified lower and upper boundary. | Conditional expression functions |
| BIND_VALUES | This INFORMATION_SCHEMA table function returns information about the values of bind variables used in queries. | Information Schema , Table functions |
| BIT_LENGTH | Returns the length of a string or binary value in bits. | String & binary functions |
| BITAND | Returns the bitwise AND of two numeric or binary expressions. | Bitwise expression functions |
| BITAND_AGG | Returns the bitwise AND value of all non-NULL numeric records in a group. | Aggregate functions , Window functions , Bitwise expression functions |
| BITMAP_ABSOLUTE_POSITION | Computes the absolute bit position from a bucket number and a relative bit position. | Aggregate functions |
| BITMAP_AND | Returns a bitmap that is the result of a bitwise AND operation on two input bitmaps. | Aggregate functions |
| BITMAP_AND_AGG | Returns a bitmap that is the result of a bitwise AND operation on all input bitmaps in a group (intersection). | Aggregate functions |
| BITMAP_BIT_POSITION | Given a numeric value, returns the relative position for the bit that represents that value in a bitmap. | Aggregate functions |
| BITMAP_BUCKET_NUMBER | Given a numeric value, returns an identifier (“bucket number”) for the bitmap containing the bit that represents the value.. | Aggregate functions |
| BITMAP_CONSTRUCT_AGG | Returns a bitmap with bits set for each distinct value in a group. | Aggregate functions |
| BITMAP_COUNT | Given a bitmap that represents the set of distinct values for a column, returns the number of distinct value. | Aggregate functions |
| BITMAP_OR | Returns a bitmap that is the result of a bitwise OR operation on two input bitmaps. | Aggregate functions |
| BITMAP_OR_AGG | Returns a bitmap containing the results of a binary OR operation on the input bitmaps. | Aggregate functions |
| BITMAP_TO_ARRAY | Returns an ARRAY containing the positions of all bits that are set in the input bitmap. | Aggregate functions |
| BITNOT | Returns the bitwise negation of a numeric or binary expression. | Bitwise expression functions |
| BITOR | Returns the bitwise OR of two numeric or binary expressions. | Bitwise expression functions |
| BITOR_AGG | Returns the bitwise OR value of all non-NULL numeric records in a group. | Aggregate functions , Window functions , Bitwise expression functions |
| BITSHIFTLEFT | Shifts the bits for a numeric or binary expression n positions to the left. | Bitwise expression functions |
| BITSHIFTRIGHT | Shifts the bits for a numeric or binary expression n positions to the right. | Bitwise expression functions |
| BITXOR | Returns the bitwise XOR of two numeric or binary expressions. | Bitwise expression functions |
| BITXOR_AGG | Returns the bitwise XOR value of all non-NULL numeric records in a group. | Aggregate functions , Window functions , Bitwise expression functions |
| BOOLAND | Computes the Boolean AND of two numeric expressions. | Conditional expression functions |
| BOOLAND_AGG | Returns TRUE if all non-NULL Boolean records in a group evaluate to TRUE. | Aggregate functions , Window functions , Conditional expression functions |
| BOOLNOT | Computes the Boolean NOT of a single numeric expression. | Conditional expression functions |
| BOOLOR | Computes the Boolean OR of two numeric expressions. | Conditional expression functions |
| BOOLOR_AGG | Returns TRUE if at least one Boolean record in a group evaluates to TRUE. | Aggregate functions , Window functions , Conditional expression functions |
| BOOLXOR | Computes the Boolean XOR of two numeric expressions; that is, one of the expressions, but not both expressions, is true. | Conditional expression functions |
| BOOLXOR_AGG | Returns TRUE if exactly one Boolean record in the group evaluates to TRUE. | Aggregate functions , Window functions , Conditional expression functions |
| BUILD_SCOPED_FILE_URL | Generates a scoped Snowflake file URL to a staged file using the stage name and relative file path as inputs. | File functions |
| BUILD_STAGE_FILE_URL | Generates a Snowflake file URL to a staged file using the stage name and relative file path as inputs. | File functions |
| C | ||
| CASE | Works like a cascading “if-then-else” statement. | Conditional expression functions |
| CAST , :: | Converts a value of one data type into another data type. | Conversion functions |
| CBRT | Returns the cubic root of a numeric expression. | Numeric functions |
| CEIL | Returns values from input_expr rounded to the nearest equal or larger integer, or to the nearest equal or larger value with the specified number of places after the decimal point. | Numeric functions |
| CHARINDEX | 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. | String & binary functions |
| CHECK_JSON | Checks the validity of a JSON document. | Semi-structured and structured data functions |
| CHECK_XML | Checks the validity of an XML document. | Semi-structured and structured data functions |
| CHR , CHAR | Converts a Unicode code point (including 7-bit ASCII) into the character that matches the input Unicode. | String & binary functions |
| CLASSIFY_TEXT (SNOWFLAKE.CORTEX) | Classifies free-form text into categories that you provide. | String & binary functions |
| COALESCE | Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL. | Conditional expression functions |
| COLLATE | Returns a copy of the original string, but with the specified collation_specification property instead of the original collation_specification property. | String & binary functions |
| COLLATION | Returns the collation specification of the expression. | String & binary functions |
| COMPLETE (SNOWFLAKE.CORTEX) (multimodal) | Given an image and a prompt, generates a response (completion) using a language model. | String & binary functions |
| COMPLETE (SNOWFLAKE.CORTEX) | Given a prompt, generates a response (completion) using your choice of supported language model. | String & binary functions |
| COMPLETE_TASK_GRAPHS | Returns the status of a completed graph run. | Information Schema , Table functions |
| COMPRESS | Compresses the input string or binary value with a compression method. | String & binary functions |
| CONCAT , || | Concatenates one or more strings, or concatenates one or more binary values. | String & binary functions |
| CONCAT_WS | Concatenates two or more strings, or concatenates two or more binary values, and uses the first argument as a delimiter between the following strings. | String & binary functions |
| CONDITIONAL_CHANGE_EVENT | Returns a window event number for each row within a window partition when the value of the argument expr1 in the current row is different from the value of expr1 in the previous row. | Window functions |
| CONDITIONAL_TRUE_EVENT | Returns a window event number for each row within a window partition based on the result of the boolean argument expr1. | Window functions |
| CONTAINS | Returns true if expr1 contains expr2. | String & binary functions |
| CONVERT_TIMEZONE | Converts a timestamp to another time zone. | Date & time functions |
| COPY_HISTORY | This table function can be used to query Snowflake data loading history along various dimensions within the last 14 days. | Information Schema , Table functions |
| CORR | Returns the correlation coefficient for non-null pairs in a group. | Aggregate functions , Window functions |
| CORTEX_SEARCH_DATA_SCAN | This table function returns the data indexed by a Cortex Search service, including the columns defined in the source query and the computed vector embeddings for the search column. | Table functions |
| CORTEX_SEARCH_REFRESH_HISTORY | This table function returns information about each refresh (completed and running) of Cortex Search services. | Information Schema , Table functions |
| COS | Computes the cosine of its argument; the argument should be expressed in radians. | Numeric functions |
| COSH | Computes the hyperbolic cosine of its argument. | Numeric functions |
| COT | Computes the cotangent of its argument; the argument should be expressed in radians. | Numeric functions |
| COUNT | Returns either the number of non-NULL records for the specified columns, or the total number of records. | Aggregate functions , Window functions |
| COUNT_IF | Returns the number of records that satisfy a condition or NULL if no records satisfy the condition. | Aggregate functions , Window functions |
| COUNT_TOKENS (SNOWFLAKE.CORTEX) | Returns the number of tokens in a prompt for the large language model or the task-specific function specified in the argument. | String & binary functions |
| COVAR_POP | Returns the population covariance for non-null pairs in a group. | Aggregate functions , Window functions |
| COVAR_SAMP | Returns the sample covariance for non-null pairs in a group. | Aggregate functions , Window functions |
| CUME_DIST | Finds the cumulative distribution of a value with regard to other values within the same window partition. | Window functions |
| CUMULATIVE_PRIVACY_LOSSES | Returns the privacy budgets associated with a specific privacy policy. | Table functions |
| CURRENT_ACCOUNT | Returns the account locator used by the user’s current session. | Context functions |
| CURRENT_ACCOUNT_NAME | Returns the name of the current account. | Context functions |
| CURRENT_AVAILABLE_ROLES | Returns a list of all account-level roles granted to the current user. | Context functions |
| CURRENT_CLIENT | Returns the version of the client from which the function was called. | Context functions |
| CURRENT_DATABASE | Returns the name of the current database, which varies depending on where you call the function. | Context functions |
| CURRENT_DATE | Returns the current date of the system. | Context functions |
| CURRENT_IP_ADDRESS | Returns the IP address of the client that submitted the request. | Context functions |
| CURRENT_ORGANIZATION_NAME | Returns the name of the organization to which the current account belongs. | Context functions |
| CURRENT_ORGANIZATION_USER | Returns the name of the user currently logged into the system, but only if the user is an organization user. | Context functions |
| CURRENT_REGION | Returns the name of the region for the account where the current user is logged in. | Context functions |
| CURRENT_ROLE | Returns the name of the primary role in use for the current session when the primary role is an account-level role or NULL if the role in use for the current session is a database role. | Context functions |
| CURRENT_ROLE_TYPE | Calling the CURRENT_ROLE_TYPE function returns ROLE if the current active (primary) role in the session is an account role. | Context functions |
| CURRENT_SCHEMA | Returns the name of the current schema, which varies depending on where you call the function. | Context functions |
| CURRENT_SCHEMAS | Returns active search path schemas. | Context functions |
| CURRENT_SECONDARY_ROLES | Returns the secondary roles in use for the current session. | Context functions |
| CURRENT_SESSION | Returns a unique system identifier for the Snowflake session corresponding to the present connection. | Context functions |
| CURRENT_STATEMENT | Returns the SQL text of the statement that is currently executing. | Context functions |
| CURRENT_TASK_GRAPHS | Returns the status of a graph run that is currently scheduled or is executing. | Information Schema , Table functions |
| CURRENT_TIME | Returns the current time for the system. | Context functions |
| CURRENT_TIMESTAMP | Returns the current timestamp for the system in the local time zone. | Context functions |
| CURRENT_TRANSACTION | Returns the transaction id of an open transaction in the current session. | Context functions |
| CURRENT_USER | Returns the name of the user currently logged into the system. | Context functions |
| CURRENT_VERSION | Returns the current Snowflake version. | Context functions |
| CURRENT_WAREHOUSE | Returns the name of the warehouse in use for the current session. | Context functions |
| D | ||
| DATA_AGENT_RUN (SNOWFLAKE.CORTEX) | Runs a Cortex Agent and returns the response as JSON. | String & binary functions |
| DATA_METRIC_FUNCTION_EXPECTATIONS | Returns information about the expectations that exist in the account. | Information Schema , Table functions |
| DATA_METRIC_FUNCTION_REFERENCES | Returns a row for each object that has the specified data metric function assigned to the object or returns a row for each data metric function assigned to the specified object. | Information Schema , Table functions |
| DATA_QUALITY_MONITORING_EXPECTATION_STATUS | For a specified object, returns a row for every time a data metric function (DMF) with an expectation was run. | LOCAL schema , Table functions |
| DATA_QUALITY_MONITORING_RESULTS | Returns a row for each data metric function assigned to the specified object, which includes the evaluation result and other metadata of the data metric function on the object. | LOCAL schema , Table functions |
| DATA_TRANSFER_HISTORY | 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. | Information Schema , Table functions |
| DATABASE_REFRESH_HISTORY | Returns the refresh history for a secondary database. | Information Schema , Table functions |
| 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. | Information Schema , Table functions |
| DATABASE_REPLICATION_USAGE_HISTORY | This table function can be used to query the replication history for a specified database within a specified date range. | Information Schema , Table functions |
| DATABASE_STORAGE_USAGE_HISTORY | 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. | Information Schema , Table functions |
| DATASKETCHES_HLL | Returns an approximation of the distinct cardinality of the input (that is, DATASKETCHES_HLL(col1) returns an approximation of COUNT(DISTINCT col1)). | Aggregate functions , Window functions |
| DATASKETCHES_HLL_ACCUMULATE | Returns the sketch at the end of aggregation. | Aggregate functions , Window function syntax and usage |
| DATASKETCHES_HLL_COMBINE | Combines (merges) input sketches into a single output sketch. | Aggregate functions , Window function syntax and usage |
| DATASKETCHES_HLL_ESTIMATE | Returns the cardinality estimate for the given sketch. | Aggregate functions , Window function syntax and usage |
| DATE_FROM_PARTS | Creates a date from individual numeric components that represent the year, month, and day of the month. | Date & time functions |
| DATE_PART | Extracts the specified date or time part from a date, time, or timestamp. | Date & time functions |
| DATE_TRUNC | Truncates a DATE, TIME, or TIMESTAMP value to the specified precision. | Date & time functions |
| DATEADD | Adds the specified value for the specified date or time part to a date, time, or timestamp. | Date & time functions |
| DATEDIFF | Calculates the difference between two date, time, or timestamp expressions based on the date or time part requested. | Date & time functions |
| DAYNAME | Extracts the three-letter day-of-week name from the specified date or timestamp. | Date & time functions |
| DBT_PROJECT_EXECUTION_HISTORY | Returns the execution history of dbt Projects on Snowflake. | Information Schema , Table functions |
| DECODE | Compares the select expression to each search expression in order. | Conditional expression functions |
| DECOMPRESS_BINARY | Decompresses the compressed BINARY input parameter. | String & binary functions |
| DECOMPRESS_STRING | Decompresses the compressed BINARY input parameter to a string. | String & binary functions |
| DECRYPT | Decrypts a BINARY value using a VARCHAR passphrase. | Encryption functions |
| DECRYPT_RAW | Decrypts a BINARY value using a BINARY key. | Encryption functions |
| DEGREES | Converts radians to degrees. | Numeric functions |
| DENSE_RANK | Returns the rank of a value within a group of values, without gaps in the ranks. | Window function syntax and usage |
| DIV0 | Performs division like the division operator (/), but returns 0 when the divisor is 0 (rather than reporting an error). | Numeric functions |
| DIV0NULL | Performs division like the division operator (/), but returns 0 when the divisor is 0 or NULL (rather than reporting an error or returning NULL). | Numeric functions |
| ACCEPTED_VALUES (system data metric function) | Returns the number of records where the value of a column does not match a Boolean expression. | Data metric functions |
| AVG (system data metric function) | Returns the average value for the specified column in a table. | Data metric functions |
| BLANK_COUNT (system data metric function) | Returns the count of column values that are blank for the specified column in a table. | Data metric functions |
| BLANK_PERCENT (system data metric function) | Returns the percentage of column values that are blank for the specified column in a table. | Data metric functions |
| DATA_METRIC_SCHEDULED_TIME (system data metric function) | Returns the timestamp for when a DMF is scheduled to run or the current timestamp if the function is called manually. | Data metric functions |
| DUPLICATE_COUNT (system data metric function) | Returns the count of column values that have duplicates, including NULL values. | Data metric functions |
| FRESHNESS (system data metric function) | Returns how much time in seconds has elapsed since a table was last modified. | Data metric functions |
| MAX (system data metric function) | Returns the maximum value for the specified column in a table. | Data metric functions |
| MIN (system data metric function) | Returns the minimum value for the specified column in a table. | Data metric functions |
| NULL_COUNT (system data metric function) | Returns the total number of NULL values for the specified column in a table. | Data metric functions |
| NULL_PERCENT (system data metric function) | Returns the percentage of columns values that are NULL for the specified column in a table. | Data metric functions |
| ROW_COUNT (system data metric function) | Returns the total number of rows in a table. | Data metric functions |
| STDDEV (system data metric function) | Returns the standard deviation value for the specified column in a table. | Data metric functions |
| UNIQUE_COUNT (system data metric function) | Returns the total number of unique non-NULL values for the specified columns in a table. | Data metric functions |
| DP_INTERVAL_HIGH | Returns the upper bound of the noise interval, which is used by differential privacy to help analysts determine how much noise has been introduced into query results. | Differential privacy functions |
| DP_INTERVAL_LOW | Returns the lower bound of the noise interval, which is used by differential privacy to help analysts determine how much noise has been introduced into query results. | Differential privacy functions |
| DYNAMIC_TABLE_GRAPH_HISTORY | This table function returns information on all dynamic tables in the current account. | Information Schema , Table functions |
| DYNAMIC_TABLE_REFRESH_HISTORY | This table function returns information about each refresh (completed and running) of dynamic tables. | Information Schema , Table functions |
| DYNAMIC_TABLES | This table function returns metadata about dynamic tables, including aggregate lag metrics and the status of the most recent refreshes, within 7 days of the current time. | Information Schema , Table functions |
| E | ||
| EDITDISTANCE | Computes the Levenshtein distance between two input strings. | String & binary functions |
| EMAIL_INTEGRATION_CONFIG | Returns a JSON object that specifies the email notification integration, recipients, and subject line to use for an email notification. | Notification functions |
| EMBED_TEXT_768 (SNOWFLAKE.CORTEX) | Creates a vector embedding of 768 dimensions from English-language text. | String & binary functions |
| EMBED_TEXT_1024 (SNOWFLAKE.CORTEX) | Creates a vector embedding of 1024 dimensions from text. | String & binary functions |
| ENCRYPT | Encrypts a VARCHAR or BINARY value using a VARCHAR passphrase. | Encryption functions |
| ENCRYPT_RAW | Encrypts a BINARY value using a BINARY key. | Encryption functions |
| ENDSWITH | Returns TRUE if the first expression ends with the second expression. | String & binary functions |
| ENTITY_SENTIMENT (SNOWFLAKE.CORTEX) | Returns sentiment scores for English-language text, including overall sentiment and specific sentiment for specified entities. | String & binary functions |
| [ NOT ] EQUAL_NULL | Compares whether two expressions are equal. | Conditional expression functions |
| ESTIMATE_REMAINING_DP_AGGREGATES | Returns the estimated number of aggregation functions that can be run before the limit of a privacy budget is reached. | Differential privacy functions , Table functions |
| EXECUTE_AI_EVALUATION | Start or get the status of a Cortex Agent evaluation run. | System functions |
| EXP | Computes Euler’s number e raised to a floating-point value. | Numeric functions |
| EXPLAIN_JSON | This function converts an EXPLAIN plan from JSON to a table. | System functions |
| EXTERNAL_FUNCTIONS_HISTORY | This table function retrieves the history of external functions called by Snowflake for your entire Snowflake account. | Information Schema , Table functions |
| EXTERNAL_TABLE_FILES | This table function can be used to query information about the staged data files included in the metadata for a specified external table. | Information Schema , Table functions |
| EXTERNAL_TABLE_FILE_REGISTRATION_HISTORY | This table function can be used to query information about the metadata history for an external table. | Information Schema , Table functions |
| EXTRACT | Extracts the specified date or time part from a date, time, or timestamp. | Date & time functions |
| EXTRACT_ANSWER (SNOWFLAKE.CORTEX) | Extracts an answer to a given question from a text document. | String & binary functions |
| EXTRACT_SEMANTIC_CATEGORIES | Returns a set of categories (semantic and privacy) for each supported column in the specified table or view. | System functions |
| F | ||
| FACTORIAL | Computes the factorial of its input. | Numeric functions |
| FILTER | Filters an array based on the logic in a lambda expression. | Semi-structured and structured data functions |
| FINETUNE (‘CANCEL’) (SNOWFLAKE.CORTEX) | Cancels the specified fine-tuning job from the current schema. | String & binary functions |
| FINETUNE (‘CREATE’) (SNOWFLAKE.CORTEX) | Creates a fine-tuning job. | String & binary functions |
| FINETUNE (‘DESCRIBE’) (SNOWFLAKE.CORTEX) | Describes the properties of a fine-tuning job. | String & binary functions |
| FINETUNE (‘SHOW’) (SNOWFLAKE.CORTEX) | Lists all the fine-tuning jobs in the current account. | String & binary functions |
| FINETUNE (SNOWFLAKE.CORTEX) | This function lets you create and manage large language models customized for your specific task. | String & binary functions |
| FIRST_VALUE | Returns the first value within an ordered group of values. | Window function syntax and usage |
| FL_GET_CONTENT_TYPE | Returns the content type (also known as the MIME type) of a FILE. | File functions |
| FL_GET_ETAG | Returns the content hash (ETAG) of a FILE. | File functions |
| FL_GET_FILE_TYPE | Returns the file type (modality) of a FILE. | File functions |
| FL_GET_LAST_MODIFIED | Returns the last modified date of a FILE. | File functions |
| FL_GET_RELATIVE_PATH | Returns the relative path of a FILE. | File functions |
| FL_GET_SCOPED_FILE_URL | Returns the scoped URL of a FILE. | File functions |
| FL_GET_SIZE | Returns the size, in bytes, of a FILE. | File functions |
| FL_GET_STAGE | Returns the stage name of a FILE. | File functions |
| FL_GET_STAGE_FILE_URL | Returns the stage URL of a FILE. | File functions |
| FL_IS_AUDIO | Checks if the input is an audio FILE. | File functions |
| FL_IS_COMPRESSED | Checks if the input is a compressed FILE. | File functions |
| FL_IS_DOCUMENT | Checks if the input is a document FILE. | File functions |
| FL_IS_IMAGE | Checks if the input is an image FILE. | File functions |
| FL_IS_VIDEO | Checks if the input is a video FILE. | File functions |
| FLATTEN | Flattens (explodes) compound values into multiple rows. | Table functions , Semi-structured and structured data functions |
| FLOOR | Returns values from input_expr rounded to the nearest equal or smaller integer, or to the nearest equal or smaller value with the specified number of places after the decimal point. | Numeric functions |
| G | ||
| GENERATE_COLUMN_DESCRIPTION | Generates a list of columns from a set of staged files that contain semi-structured data using the INFER_SCHEMA function output. | Metadata functions |
| GENERATE_POSTGRES_ACCESS_TOKEN_FOR_USER | Generates a short-lived access token for a Snowflake user to use as a password when logging into a Snowflake Postgres instance that has the AUTHENTICATION_AUTHORITY attribute set to POSTGRES_OR_SNOWFLAKE. | Generates a short-lived access token for a Snowflake user to use as a password when logging into a Snowflake Postgres instance that has the AUTHENTICATION_AUTHORITY attribute set to POSTGRES_OR_SNOWFLAKE. |
| GENERATOR | Creates rows of data based either on a specified number of rows, a specified generation period (in seconds), or both. | Table functions |
| GET | Extracts a value from an ARRAY or an OBJECT (or a VARIANT that contains an ARRAY or OBJECT). | Semi-structured and structured data functions |
| GET_ABSOLUTE_PATH | Retrieves the absolute path of a staged file using the stage name and path of the file relative to its location in the stage as inputs. | File functions |
| GET_AI_EVALUATION_DATA (SNOWFLAKE.LOCAL) | Retrieves evaluation data for a Cortex Agent evaluation run. | Table functions |
| GET_AI_OBSERVABILITY_LOGS (SNOWFLAKE.LOCAL) | Retrieve log data for a Cortex Agent observability event, such as a warning or failure. | Table functions |
| GET_AI_RECORD_TRACE (SNOWFLAKE.LOCAL) | Retrieve a single trace record from a Cortex Agent evaluation run. | Table functions |
| GET_ANACONDA_PACKAGES_REPODATA | Returns a list of third-party packages that are available from Anaconda. | System functions |
| GET_CONDITION_QUERY_UUID | Returns the query ID for the SQL statement executed for the condition of an alert. | Context functions |
| GET_CONFIGURATION_VALUE (SYS_CONTEXT function) | Returns the current value for the specified configuration. | Context functions |
| GET_CONTACTS | Returns the contacts associated with an object. | Table functions |
| GET_DDL | Returns a DDL statement that can be used to recreate the specified object. | Metadata functions |
| GET_IGNORE_CASE | Extracts a field value from an object; returns NULL if either of the arguments is NULL. | Semi-structured and structured data functions |
| GET_JOB_HISTORY | Returns the job history for Snowpark Container Services jobs that ran within the specified time range. | Table functions |
| GET_LINEAGE (SNOWFLAKE.CORE) | Given a Snowflake object, returns data lineage information upstream or downstream from that object. | Table functions |
| GET_OBJECT_REFERENCES | Returns a list of objects that a specified object references. | Table functions |
| GET_PATH , : | Extracts a value from semi-structured data using a path name. | Semi-structured and structured data functions |
| GET_PRESIGNED_URL | Generates a pre-signed URL to a file on a stage using the stage name and relative file path as inputs. | File functions |
| GET_PYTHON_PROFILER_OUTPUT (SNOWFLAKE.CORE) | Returns output containing a report generated by the Python code profiler. | System functions |
| GET_QUERY_OPERATOR_STATS | Returns statistics about individual query operators within a query that has completed. | System functions , Table functions |
| GET_RELATIVE_PATH | Extracts the path of a staged file relative to its location in the stage using the stage name and absolute file path in cloud storage as inputs. | File functions |
| GET_STAGE_LOCATION | Retrieves the URL for an external or internal named stage using the stage name as the input. | File functions |
| GETBIT | Given an INTEGER value, returns the value of a bit at a specified position. | Bitwise expression functions |
| GETDATE | Returns the current timestamp for the system in the local time zone. | Context functions |
| GETVARIABLE | Returns the value associated with a SQL variable name. | Context functions |
| GREATEST | Returns the largest value from a list of expressions. | Conditional expression functions |
| GREATEST_IGNORE_NULLS | Returns the largest non-NULL value from a list of expressions. | Conditional expression functions |
| GROUPING | Describes which of a list of expressions are grouped in a row produced by a GROUP BY query. | Aggregate functions |
| GROUPING_ID | Describes which of a list of expressions are grouped in a row produced by a GROUP BY query. | Aggregate functions |
| H | ||
| H3_CELL_TO_BOUNDARY | Returns the GEOGRAPHY object representing the boundary of an H3 cell. | Geospatial functions |
| H3_CELL_TO_CHILDREN | Returns an array of the INTEGER IDs of the children of an H3 cell for a given resolution. | Geospatial functions |
| H3_CELL_TO_CHILDREN_STRING | Returns an array of the VARCHAR values containing the hexadecimal IDs of the children of an H3 cell for a given resolution. | Geospatial functions |
| H3_CELL_TO_PARENT | Returns the ID of the parent of an H3 cell for a given resolution. | Geospatial functions |
| H3_CELL_TO_POINT | Returns the GEOGRAPHY object representing the Point that is the centroid of an H3 cell. | Geospatial functions |
| H3_COMPACT_CELLS | Returns an array of VARIANT values that contain the INTEGER IDs of fewer, larger H3 cells that cover the same area as the H3 cells in the input. | Geospatial functions |
| H3_COMPACT_CELLS_STRINGS | Returns an array of VARIANT values that contain the VARCHAR hexadecimal IDs of fewer, larger H3 cells that cover the same area as the H3 cells in the input. | Geospatial functions |
| H3_COVERAGE | Returns an array of IDs (as INTEGER values) identifying the minimal set of H3 cells that completely cover a shape (specified by a GEOGRAPHY object). | Geospatial functions |
| H3_COVERAGE_STRINGS | Returns an array of hexadecimal IDs (as VARCHAR values) identifying the minimal set of H3 cells that completely cover a shape (specified by a GEOGRAPHY object). | Geospatial functions |
| H3_GET_RESOLUTION | Returns the resolution of an H3 cell. | Geospatial functions |
| H3_GRID_DISK | Returns an array of the IDs of the H3 cells that are within the k-distance from the specified cell. | Geospatial functions |
| H3_GRID_DISTANCE | Returns the distance between two H3 cells specified by their IDs. | Geospatial functions |
| H3_GRID_PATH | Returns an array of the IDs of the H3 cells that represent the line between two cells. | Geospatial functions |
| H3_INT_TO_STRING | Converts the INTEGER value of an H3 cell ID to hexadecimal format. | Geospatial functions |
| H3_IS_PENTAGON | Returns TRUE if the boundary of an H3 cell represents a pentagon. | Geospatial functions |
| H3_IS_VALID_CELL | Returns TRUE if the input represents a valid H3 cell. | Geospatial functions |
| H3_LATLNG_TO_CELL | Returns the INTEGER value of the H3 cell ID for a given latitude, longitude, and resolution. | Geospatial functions |
| H3_LATLNG_TO_CELL_STRING | Returns the H3 cell ID in hexadecimal format (as a VARCHAR value) for a given latitude, longitude, and resolution. | Geospatial functions |
| H3_POINT_TO_CELL | Returns the INTEGER value of an H3 cell ID for a Point (specified by a GEOGRAPHY object) at a given resolution. | Geospatial functions |
| H3_POINT_TO_CELL_STRING | Returns the hexadecimal value of an H3 cell ID for a Point (specified by a GEOGRAPHY object) at a given resolution. | Geospatial functions |
| H3_POLYGON_TO_CELLS | Returns an array of INTEGER values of the IDs of H3 cells that have centroids contained by a Polygon (specified by a GEOGRAPHY object). | Geospatial functions |
| H3_POLYGON_TO_CELLS_STRINGS | Returns an array of VARCHAR values of the hexadecimal IDs of H3 cells that have centroids contained by a Polygon (specified by a GEOGRAPHY object). | Geospatial functions |
| H3_STRING_TO_INT | Converts an H3 cell ID in hexadecimal format to an INTEGER value. | Geospatial functions |
| H3_TRY_COVERAGE | A special version of H3_COVERAGE that returns NULL if an error occurs when it attempts to return an array of IDs (as INTEGER values) identifying the minimal set of H3 cells that completely cover a shape (specified by a GEOGRAPHY object). | Geospatial functions |
| H3_TRY_COVERAGE_STRINGS | A special version of H3_COVERAGE_STRINGS that returns NULL if an error occurs when it attempts to return an array of hexadecimal IDs (as VARCHAR values) identifying the minimal set of H3 cells that completely cover a shape (specified by a GEOGRAPHY object). | Geospatial functions |
| H3_TRY_GRID_DISTANCE | A special version of H3_GRID_DISTANCE that returns NULL if an error occurs when it attempts to return the distance between two H3 cells. | Geospatial functions |
| H3_TRY_GRID_PATH | A special version of H3_GRID_PATH that returns NULL if an error occurs when it attempts to return an array of VARIANT values that contain the IDs of the H3 cells that represent the line between two cells. | Geospatial functions |
| H3_TRY_POLYGON_TO_CELLS | A special version of H3_POLYGON_TO_CELLS that returns NULL if an error occurs when it attempts to return an array of INTEGER values of the IDs of H3 cells that have centroids contained by a Polygon (specified by a GEOGRAPHY object). | Geospatial functions |
| H3_TRY_POLYGON_TO_CELLS_STRINGS | A special version of H3_POLYGON_TO_CELLS_STRINGS that returns NULL if an error occurs when it attempts to return an array of VARCHAR values of the hexadecimal IDs of H3 cells that have centroids contained by a Polygon (specified by a GEOGRAPHY object). | Geospatial functions |
| H3_UNCOMPACT_CELLS | Returns an array of VARIANT values that contain the INTEGER IDs of H3 cells at the specified resolution that cover the same area as the H3 cells in the input. | Geospatial functions |
| H3_UNCOMPACT_CELLS_STRINGS | Returns an array of VARIANT values that contain the VARCHAR hexadecimal IDs of H3 cells at the specified resolution that cover the same area as the H3 cells in the input. | Geospatial functions |
| HASH | Returns a signed 64-bit hash value. | Hash functions |
| HASH_AGG | Returns an aggregate signed 64-bit hash value over the (unordered) set of input rows. | Aggregate functions , Window functions |
| HAVERSINE | Calculates the great-circle distance in kilometers between two points on the Earth’s surface, using the Haversine formula. | Geospatial functions |
| HEX_DECODE_BINARY | Decodes a hex-encoded string to a binary. | String & binary functions |
| HEX_DECODE_STRING | Decodes a hex-encoded string to a string. | String & binary functions |
| HEX_ENCODE | Encodes the input using hexadecimal (also ‘hex’ or ‘base16’) encoding. | String & binary functions |
| HLL | Uses HyperLogLog to return an approximation of the distinct cardinality of the input (i.e. HLL(col1, col2, ... ) returns an approximation of COUNT(DISTINCT col1, col2, ... )). | Aggregate functions , Window functions |
| HLL_ACCUMULATE | Returns the HyperLogLog state at the end of aggregation. | Aggregate functions , Window functions |
| HLL_COMBINE | Combines (merges) input states into a single output state. | Aggregate functions , Window functions |
| HLL_ESTIMATE | Returns the cardinality estimate for the given HyperLogLog state. | Aggregate functions , Window functions |
| HLL_EXPORT | Converts input in BINARY format to OBJECT format. | Aggregate functions , Window functions |
| HLL_IMPORT | Converts input in OBJECT format to BINARY format. | Aggregate functions , Window functions |
| HOUR / MINUTE / SECOND | Extracts the corresponding time part from a time or timestamp value. | Date & time functions |
| I | ||
| ICEBERG_TABLE_FILES | Returns information about the data files registered to an externally managed Apache Iceberg™ table at a specified point in time. | Table functions |
| ICEBERG_TABLE_SNAPSHOT_REFRESH_HISTORY | Returns metadata and snapshot information about the most recent refresh history for a specified externally managed Apache Iceberg™ table. | Table functions |
| IFF | Returns one of two values depending on whether a Boolean expression evaluates to true or false. | Conditional expression functions |
| IFNULL | If expr1 is NULL, returns expr2, otherwise returns expr1. | Conditional expression functions |
| [ NOT ] ILIKE | Performs a case-insensitive comparison to determine whether a string matches or does not match a specified pattern. | String & binary functions |
| ILIKE ANY | Performs a case-insensitive comparison to match a string against any of one or more specified patterns. | String & binary functions |
| [ NOT ] IN | Tests whether its argument is or is not one of the members of an explicit list or the result of a subquery. | Conditional expression functions |
| INFER_SCHEMA | Automatically detects the file metadata schema in a set of staged data files that contain semi-structured data and retrieves the column definitions. | Table functions |
| INITCAP | Returns the input string with the first letter of each word in uppercase and the subsequent letters in lowercase. | String & binary functions |
| INSERT | Replaces a substring of the specified length, starting at the specified position, with a new string or binary value. | String & binary functions |
| INTEGRATION | Returns a JSON object that specifies the notification integration to use to send a message. | Notification functions |
| INTERPOLATE_BFILL, INTERPOLATE_FFILL, INTERPOLATE_LINEAR | Updates rows in a time-series data set to gap-fill missing values based on surrounding values. | Window functions |
| INVOKER_ROLE | Returns the name of the account-level role of the object executing the query or NULL if the name of the role is a database role. | Context functions |
| INVOKER_SHARE | Returns the name of the share that directly accessed the table or view where the INVOKER_SHARE function is invoked, otherwise the function returns NULL. | Context functions |
| IS [ NOT ] DISTINCT FROM | Compares whether two expressions are equal (or not equal). | Conditional expression functions |
| IS [ NOT ] NULL | Determines whether an expression is NULL or is not NULL. | Conditional expression functions |
| IS_*<object_type>* | 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. | Semi-structured and structured data functions |
| IS_APPLICATION_ROLE_ACTIVATED (SYS_CONTEXT function) | Returns the VARCHAR value 'TRUE' if an application role is activated in the specified context. | Context functions |
| IS_APPLICATION_ROLE_IN_SESSION | Verifies whether the application role is activated in the consumer’s current session. | Context functions |
| IS_ARRAY | Returns TRUE if its VARIANT argument contains an ARRAY value. | Semi-structured and structured data functions |
| IS_BINARY | Returns TRUE if its VARIANT argument contains a binary string value. | Semi-structured and structured data functions |
| IS_BOOLEAN | Returns TRUE if its VARIANT argument contains a BOOLEAN value. | Semi-structured and structured data functions |
| IS_CHAR , IS_VARCHAR | Returns TRUE if its VARIANT argument contains a string value. | Semi-structured and structured data functions |
| IS_CONFIGURATION_SET (SYS_CONTEXT function) | Returns the VARCHAR value 'TRUE' if the specified configuration has a value set, that is, the configuration’s status is DONE. | Context functions |
| IS_DATABASE_ROLE_ACTIVATED (SYS_CONTEXT function) | Returns the VARCHAR value 'TRUE' if a database role is activated in the current session. | Context functions |
| IS_DATABASE_ROLE_IN_SESSION | Verifies whether the database role is in the user’s active primary or secondary role hierarchy for the current session or if the specified column contains a database role that is in the user’s active primary or secondary role hierarchy for the current session. | Context functions |
| IS_DATE , IS_DATE_VALUE | Returns TRUE if its VARIANT argument contains a DATE value. | Semi-structured and structured data functions |
| IS_DECIMAL | Returns TRUE if its VARIANT argument contains a fixed-point number or integer value. | Semi-structured and structured data functions |
| IS_DOUBLE , IS_REAL | Returns TRUE if its VARIANT argument contains a floating-point number, fixed-point number, or integer value. | Semi-structured and structured data functions |
| IS_GRANTED_TO_INVOKER_ROLE | Returns TRUE if the role returned by the INVOKER_ROLE function inherits the privileges of the specified role in the argument based on the context in which the function is called. | Context functions |
| IS_GROUP_ACTIVATED (SYS_CONTEXT function) | Returns the VARCHAR value 'TRUE' if the role representing an organization user group is activated in a given context. | Context functions |
| IS_GROUP_IMPORTED (SYS_CONTEXT function) | Returns the VARCHAR value 'TRUE' if the specified group is an organization user group that was imported into the current account. | Context functions |
| IS_INSTANCE_ROLE_IN_SESSION | Verifies whether the user’s active primary or secondary role hierarchy for the session inherits the specified instance role. | Context functions |
| IS_INTEGER | Returns TRUE if its VARIANT argument contains an integer value. | Semi-structured and structured data functions |
| IS_NULL_VALUE | Returns TRUE if its VARIANT argument is a JSON null value. | Conditional expression functions , Semi-structured and structured data functions |
| IS_OBJECT | Returns TRUE if its VARIANT argument contains an OBJECT value. | Semi-structured and structured data functions |
| IS_ORGANIZATION_USER | Returns TRUE if the argument is a Snowflake user who is an organization user. | Organization user and organization user group functions |
| IS_ORGANIZATION_USER_GROUP | Returns TRUE if the specified role was created when an administrator added an organization user group to the account. | Organization user and organization user group functions |
| IS_ORGANIZATION_USER_GROUP_IN_SESSION | Assuming a role was imported from an organization user group, verifies whether the role is in the user’s active primary or secondary role hierarchy for the session. | Context functions |
| IS_ROLE_ACTIVATED (SYS_CONTEXT function) | Returns the VARCHAR value 'TRUE' if an account role is activated in the current session. | Context functions |
| IS_ROLE_IN_SESSION | Verifies whether the specified account role is in the currently active primary or secondary role hierarchy. | Context functions |
| IS_TIME | Verifies whether a VARIANT argument contains a TIME value. | Semi-structured and structured data functions |
| IS_TIMESTAMP_* | Verifies whether a VARIANT argument contains the respective timestamp value. | Semi-structured and structured data functions |
| IS_USER_IMPORTED (SYS_CONTEXT function) | Returns the VARCHAR value 'TRUE' if the specified user is an organization user that was imported into the current account. | Context functions |
| J | ||
| JAROWINKLER_SIMILARITY | Computes the Jaro-Winkler similarity between two input strings. | String & binary functions |
| JSON_EXTRACT_PATH_TEXT | Parses the first argument as a JSON string and returns the value of the element pointed to by the path in the second argument. | Semi-structured and structured data functions |
| K | ||
| KURTOSIS | Returns the sample excess kurtosis of non-NULL records. | Aggregate functions , Window function syntax and usage |
| L | ||
| LAG | Accesses data in a previous row in the same result set without having to join the table to itself. | Window function syntax and usage |
| LAST_DAY | Returns the last day of the specified date part for a date or timestamp. | Date & time functions |
| LAST_QUERY_ID | Returns the ID of a specified query in the current session. | Context functions |
| LAST_SUCCESSFUL_SCHEDULED_TIME | Returns the timestamp representing the scheduled time for the most recent successful evaluation of the alert condition, where no errors occurred when executing the action. | Date & time functions |
| LAST_TRANSACTION | Returns the transaction ID of the last transaction that was either committed or rolled back in the current session. | Context functions |
| LAST_VALUE | Returns the last value within an ordered group of values. | Window function syntax and usage |
| LEAD | Accesses data in a subsequent row in the same result set without having to join the table to itself. | Window function syntax and usage |
| LEAST | Returns the smallest value from a list of expressions. | Conditional expression functions |
| LEAST_IGNORE_NULLS | Returns the smallest non-NULL value from a list of expressions. | Conditional expression functions |
| LEFT | Returns a leftmost substring of its input. | String & binary functions |
| LENGTH, LEN | Returns the length of an input string or binary value. | String & binary functions |
| [ NOT ] LIKE | Performs a case-sensitive comparison to determine whether a string matches or does not match a specified pattern. | String & binary functions |
| LIKE ALL | Performs a case-sensitive comparison to match a string against all of one or more specified patterns. | String & binary functions |
| LIKE ANY | Performs a case-sensitive comparison to match a string against any of one or more specified patterns. | String & binary functions |
| LISTAGG | Returns the concatenated input values, separated by the delimiter string. | Aggregate functions , Window function syntax and usage |
| LISTING_REFRESH_HISTORY | Returns the past 14 days of refresh history for a cross-cloud auto-fulfillment listing. | Information Schema , Table functions |
| LN | Returns the natural logarithm of a numeric expression. | Numeric functions |
| LOCALTIME | Returns the current time for the system. | Context functions |
| LOCALTIMESTAMP | Returns the current timestamp for the system in the local time zone. | Context functions |
| LOG | Returns the logarithm of a numeric expression. | Numeric functions |
| LOGIN_HISTORY , LOGIN_HISTORY_BY_USER | The LOGIN_HISTORY family of table functions can be used to query login attempts by Snowflake users along various dimensions. | Information Schema , Table functions |
| LOWER | Returns the input string with all characters converted to lowercase. | String & binary functions |
| LPAD | Left-pads a string with characters from another string, or left-pads a binary value with bytes from another binary value. | String & binary functions |
| LTRIM | Removes leading characters, including whitespace, from a string. | String & binary functions |
| M | ||
| MAP_CAT | Returns the concatenatation of two MAP values. | Semi-structured and structured data functions |
| MAP_CONTAINS_KEY | Determines whether the specified MAP contains the specified key. | Semi-structured and structured data functions |
| MAP_DELETE | Returns a MAP based on an existing MAP with one or more keys removed. | Semi-structured and structured data functions |
| MAP_ENTRIES | Returns an ARRAY value of key-value pair objects for each entry in a MAP value. | Semi-structured and structured data functions |
| MAP_INSERT | Returns a new MAP consisting of the input MAP with a new key-value pair inserted. | Semi-structured and structured data functions |
| MAP_KEYS | Returns the keys in a MAP. | Semi-structured and structured data functions |
| MAP_PICK | Returns a new MAP containing the specified key-value pairs from an existing MAP. | Semi-structured and structured data functions |
| MAP_SIZE | Returns the size of a MAP. | Semi-structured and structured data functions |
| MATERIALIZED_VIEW_REFRESH_HISTORY | This table function is used for querying the materialized views refresh history for a specified materialized view within a specified date range. | Information Schema , Table functions |
| MAX | Returns the maximum value for the records within expr. | Aggregate functions , Window functions |
| MAX_BY | Finds the row(s) containing the maximum value for a column and returns the value of another column in that row. | Aggregate functions |
| MD5 , MD5_HEX | Returns a 32-character hex-encoded string containing the 128-bit MD5 message digest. | String & binary functions |
| MD5_BINARY | Returns a 16-byte BINARY value containing the 128-bit MD5 message digest. | String & binary functions |
| MD5_NUMBER — Obsoleted | Returns the 128-bit MD5 message digest interpreted as a signed 128-bit big endian number. | String & binary functions |
| MD5_NUMBER_LOWER64 | Calculates the 128-bit MD5 message digest, interprets it as a signed 128-bit big endian number, and returns the lower 64 bits of the number as an unsigned integer. | String & binary functions |
| MD5_NUMBER_UPPER64 | Calculates the 128-bit MD5 message digest, interprets it as a signed 128-bit big endian number, and returns the upper 64 bits of the number as an unsigned integer. | String & binary functions |
| MEDIAN | Determines the median of a set of values. | Aggregate functions , Window functions |
| MIN | Returns the minimum value for the records within expr. | Aggregate functions , Window functions |
| MIN_BY | Finds the row(s) containing the minimum value for a column and returns the value of another column in that row. | Aggregate functions |
| MINHASH | Returns a MinHash state containing an array of size k constructed by applying k number of different hash functions to the input rows and keeping the minimum of each hash function. | Aggregate functions , Window functions |
| MINHASH_COMBINE | Combines input MinHash states into a single MinHash output state. | Aggregate functions , Window functions |
| MOD | Returns the remainder of input expr1 divided by input expr2. | Numeric functions |
| MODE | Returns the most frequent value for the values within expr1. | Aggregate functions , Window functions |
| MODEL_MONITOR_DRIFT_METRIC | Gets drift metrics from a model monitor. | Model monitor functions |
| MODEL_MONITOR_PERFORMANCE_METRIC | Gets performance metrics from a model monitor. | Model monitor functions |
| MODEL_MONITOR_STAT_METRIC | Gets count metrics from a model monitor. | Model monitor functions |
| MONTHNAME | Returns the three-letter month name for the specified date or timestamp. | Date & time functions |
| MONTHS_BETWEEN | Returns the number of months between two DATE or TIMESTAMP values. | Date & time functions |
| N | ||
| NETWORK_RULE_REFERENCES | Returns a row for each object with which the specified network rule is associated or returns a row for each network rule associated with the specified container. | Information Schema , Table functions |
| NEXT_DAY | Returns the date of the first specified day of week (DOW) that occurs after the input date. | Date & time functions |
| NORMAL | Generates a normally-distributed pseudo-random floating point number with specified mean and stddev (standard deviation). | Data generation functions |
| NOTIFICATION_HISTORY | This table function can be used to query the history of notifications sent through Snowflake. | Information Schema , Table functions |
| NTH_VALUE | Returns the nth value (up to 1000) within an ordered group of values. | Window function syntax and usage |
| NTILE | Divides an ordered data set equally into the number of buckets specified by constant_value. | Window function syntax and usage |
| NULLIF | Returns NULL if expr1 is equal to expr2, otherwise returns expr1. | Conditional expression functions |
| NULLIFZERO | Returns NULL if the argument evaluates to 0; otherwise, returns the argument. | Conditional expression functions |
| NVL | If expr1 is NULL, returns expr2, otherwise returns expr1. | Conditional expression functions |
| NVL2 | Returns values depending on whether the first input is NULL. | Conditional expression functions |
| O | ||
| OBJECT_AGG | Returns one OBJECT per group. | Aggregate functions , Window functions , Semi-structured and structured data functions |
| OBJECT_CONSTRUCT | Returns an OBJECT constructed from the arguments. | Semi-structured and structured data functions |
| OBJECT_CONSTRUCT_KEEP_NULL | Returns an OBJECT constructed from the arguments that retains key-values pairs with NULL values. | Semi-structured and structured data functions |
| OBJECT_DELETE | Returns an object containing the contents of the input (that is, source) object with one or more keys removed. | Semi-structured and structured data functions |
| OBJECT_INSERT | Returns an OBJECT value consisting of the input OBJECT value with a new key-value pair inserted (or an existing key updated with a new value). | Semi-structured and structured data functions |
| OBJECT_KEYS | Returns an array containing the list of keys in the top-most level of the input object. | Semi-structured and structured data functions |
| OBJECT_PICK | Returns a new OBJECT containing some of the key-value pairs from an existing object. | Semi-structured and structured data functions |
| OCTET_LENGTH | Returns the length of a string or binary value in bytes. | String & binary functions |
| ONLINE_FEATURE_TABLE_REFRESH_HISTORY | This table function returns information about each refresh (completed and running) of online feature tables. | Information Schema , Table functions |
| P | ||
| PARSE_DOCUMENT (SNOWFLAKE.CORTEX) | Returns the extracted content from a document on a Snowflake stage as a JSON-formatted string. | File functions |
| PARSE_IP | 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. | String & binary functions |
| PARSE_JSON | Interprets an input string as a JSON document, producing a VARIANT value. | Semi-structured and structured data functions |
| PARSE_URL | Returns an OBJECT value that consists of all the components (fragment, host, parameters, path, port, query, scheme) in a valid input URL/URI. | String & binary functions |
| PARSE_XML | Interprets an input string as an XML document, producing an OBJECT value. | Semi-structured and structured data functions |
| PERCENT_RANK | Returns the relative rank of a value within a group of values, specified as a percentage ranging from 0.0 to 1.0. | Window functions |
| PERCENTILE_CONT | Return a percentile value based on a continuous distribution of the input column (specified in order_by_expr). | Aggregate functions , Window functions |
| PERCENTILE_DISC | Returns a percentile value based on a discrete distribution of the input column (specified in order_by_expr). | Aggregate functions , Window functions |
| PI | Returns the value of pi as a floating-point value. | Numeric functions |
| PIPE_USAGE_HISTORY | This table function can be used to query the history of data loaded into Snowflake tables using Snowpipe within a specified date range. | Information Schema , Table functions |
| POLICY_CONTEXT | Simulates the results of a query based upon the value of one or more context functions, which lets you determine how policies affect query results. | Context functions |
| POLICY_REFERENCES | Returns a row for each object that has the specified policy assigned to the object or returns a row for each policy assigned to the specified object. | Information Schema , Table functions |
| POSITION | 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. | String & binary functions |
| POW, POWER | Returns a number (x) raised to the specified power (y). | Numeric functions |
| PREVIOUS_DAY | Returns the date of the first specified day of week (DOW) that occurs before the input date. | Date & time functions |
| PROMPT | The PROMPT function constructs a structured OBJECT containing a template string and a list of arguments. | Semi-structured and structured data functions |
| Q | ||
| QUERY_ACCELERATION_HISTORY | The QUERY_ACCELERATION_HISTORY function is used for querying the query acceleration service history within a specified date range. | Information Schema , Table functions |
| QUERY_HISTORY , QUERY_HISTORY_BY_* | You can use the QUERY_HISTORY family of table functions to query Snowflake query history along various dimensions. | Information Schema , Table functions |
| R | ||
| RADIANS | Converts degrees to radians. | Numeric functions |
| RANDOM | Each call returns a pseudo-random 64-bit integer. | Data generation functions |
| RANDSTR | Returns a random string of specified length. | Data generation functions |
| RANK | Returns the rank of a value within an ordered group of values. | Window functions |
| RATIO_TO_REPORT | Returns the ratio of a value within a group to the sum of the values within the group. | Window functions |
| REDUCE | Reduces an array to a single value based on the logic in a lambda expression. | Semi-structured and structured data functions |
| [ NOT ] REGEXP | Performs a comparison to determine whether a string matches or does not match a specified pattern. | String functions (regular expressions) |
| REGEXP_COUNT | Returns the number of times that a pattern occurs in a string. | String functions (regular expressions) |
| REGEXP_INSTR | Returns the position of the specified occurrence of the regular expression pattern in the string subject. | String functions (regular expressions) |
| REGEXP_LIKE | Performs a comparison to determine whether a string matches a specified pattern. | String functions (regular expressions) |
| REGEXP_REPLACE | Returns the subject with the specified pattern — or all occurrences of the pattern — either removed or replaced by a replacement string. | String functions (regular expressions) |
| REGEXP_SUBSTR | Returns the substring that matches a regular expression within a string. | String functions (regular expressions) |
| REGEXP_SUBSTR_ALL | Returns an ARRAY that contains all substrings that match a regular expression within a string. | String functions (regular expressions) |
| REGR_AVGX | Returns the average of the independent variable for non-null pairs in a group, where x is the independent variable and y is the dependent variable. | Aggregate functions , Window functions |
| REGR_AVGY | Returns the average of the dependent variable for non-null pairs in a group, where x is the independent variable and y is the dependent variable. | Aggregate functions , Window functions |
| REGR_COUNT | Returns the number of non-null number pairs in a group. | Aggregate functions , Window function syntax and usage |
| REGR_INTERCEPT | Returns the intercept of the univariate linear regression line for non-null pairs in a group. | Aggregate functions , Window function syntax and usage |
| REGR_R2 | Returns the coefficient of determination for non-null pairs in a group. | Aggregate functions , Window function syntax and usage |
| REGR_SLOPE | Returns the slope of the linear regression line for non-null pairs in a group. | Aggregate functions , Window function syntax and usage |
| REGR_SXX | Returns REGR_COUNT(y, x) * VAR_POP(x) for non-null pairs. | Aggregate functions , Window function syntax and usage |
| REGR_SXY | Returns REGR_COUNT(expr1, expr2) * COVAR_POP(expr1, expr2) for non-null pairs. | Aggregate functions , Window function syntax and usage |
| REGR_SYY | Returns REGR_COUNT(y, x) * VAR_POP(y) for non-null pairs. | Aggregate functions , Window function syntax and usage |
| REGR_VALX | Returns NULL if the first argument is NULL; otherwise, returns the second argument. | Conditional expression functions |
| REGR_VALY | Returns NULL if the second argument is NULL; otherwise, returns the first argument. | Conditional expression functions |
| REPEAT | Builds a string by repeating the input for the specified number of times. | String & binary functions |
| REPLACE | Removes all occurrences of a specified substring, and optionally replaces them with another substring. | String & binary functions |
| REPLICATION_GROUP_DANGLING_REFERENCES | Detects cases where an object that’s referenced in a replication group or failover group isn’t actually replicated to the secondary account. | Information Schema , Table functions |
| REPLICATION_GROUP_REFRESH_HISTORY, REPLICATION_GROUP_REFRESH_HISTORY_ALL | You can use the REPLICATION_GROUP_REFRESH_HISTORY family of table functions to query the replication history for one secondary replication or failover group, or all such groups, within the last 14 days. | Information Schema , Table functions |
| REPLICATION_GROUP_REFRESH_PROGRESS, REPLICATION_GROUP_REFRESH_PROGRESS_BY_JOB, REPLICATION_GROUP_REFRESH_PROGRESS_ALL | You can use the REPLICATION_GROUP_REFRESH_PROGRESS family of table functions to query the status of refresh operations for replication or failover groups. | Information Schema , Table functions |
| REPLICATION_GROUP_USAGE_HISTORY | Returns the replication usage history for secondary replication or failover groups within the last 14 days. | Information Schema , Table functions |
| REPLICATION_USAGE_HISTORY | This table function can be used to query the replication history for a specified database within a specified date range. | Information Schema , Table functions |
| REST_EVENT_HISTORY | Returns a list of SCIM REST API requests made to Snowflake over a specified time interval. | Table functions |
| RESULT_SCAN | Returns the result set of a previous command (within 24 hours of when you ran the query) as if the result was a table. | Table functions |
| REVERSE | Reverses the order of characters in a string, or of bytes in a binary value. | String & binary functions |
| RIGHT | Returns a rightmost substring of its input. | String & binary functions |
| [ NOT ] RLIKE | Performs a comparison to determine whether a string matches or does not match a specified pattern. | String functions (regular expressions) |
| ROUND | Returns rounded values for input_expr. | Numeric functions |
| ROW_NUMBER | Returns a unique row number for each row within a window partition. | Window function syntax and usage |
| RPAD | Right-pads a string with characters from another string, or right-pads a binary value with bytes from another binary value. | String & binary functions |
| RTRIM | Removes trailing characters, including whitespace, from a string. | String & binary functions |
| RTRIMMED_LENGTH | Returns the length of its argument, minus trailing whitespace, but including leading whitespace. | String & binary functions |
| S | ||
| SANITIZE_WEBHOOK_CONTENT | Removes placeholders (for example, the SNOWFLAKE_WEBHOOK_SECRET placeholder, which specifies a secret) from the body of a notification message to be sent. | Notification functions |
| SCHEDULED_TIME | Returns the timestamp representing the scheduled time of the current alert. | Date & time functions |
| SEARCH | Searches character data (text) in specified columns from one or more tables, including fields in VARIANT, OBJECT, and ARRAY columns. | String & binary functions |
| SEARCH_IP | Searches for valid IPv4 and IPv6 addresses in specified character-string columns from one or more tables, including fields in VARIANT, OBJECT, and ARRAY columns. | String & binary functions |
| SEARCH_OPTIMIZATION_HISTORY | This table function is used for querying the search optimization service maintenance history for a specified table within a specified date range. | Information Schema , Table functions |
| SEARCH_PREVIEW (SNOWFLAKE.CORTEX) | Given a Cortex Search service name, and a query, returns a response from the specified service. | String & binary functions |
| SENTIMENT (SNOWFLAKE.CORTEX) | Returns an overall sentiment score for the given English-language input text. | String & binary functions |
| SEQ1 / SEQ2 / SEQ4 / SEQ8 | Returns a sequence of monotonically increasing integers, with wrap-around. | Data generation functions |
| SERVERLESS_ALERT_HISTORY | This table function is used for querying the serverless alert usage history. | Information Schema , Table functions |
| SERVERLESS_TASK_HISTORY | This table function is used for querying the serverless task usage history. | Information Schema , Table functions |
| SET_SYS_CONTEXT | Sets a value for a specified key in a specified namespace. | Context functions |
| SHA1 , SHA1_HEX | Returns a 40-character hex-encoded string containing the 160-bit SHA-1 message digest. | String & binary functions |
| SHA1_BINARY | Returns a 20-byte binary containing the 160-bit SHA-1 message digest. | String & binary functions |
| SHA2 , SHA2_HEX | Returns a hex-encoded string containing the N-bit SHA-2 message digest, where N is the specified output digest size. | String & binary functions |
| SHA2_BINARY | Returns a binary containing the N-bit SHA-2 message digest, where N is the specified output digest size. | String & binary functions |
| SHOW_PYTHON_PACKAGES_DEPENDENCIES | Returns a list of the dependencies and their versions for the Python packages that were specified. | System functions |
| SIGN | Returns the sign of its argument. | Numeric functions |
| SIN | Computes the sine of its argument; the argument should be expressed in radians. | Numeric functions |
| SINH | Computes the hyperbolic sine of its argument. | Numeric functions |
| SKEW | Returns the sample skewness of non-NULL records. | Aggregate functions |
| SOUNDEX | Returns a string that contains a phonetic representation of the input string. | String & binary functions |
| SOUNDEX_P123 | Returns a string that contains a phonetic representation of the input string, and retains the Soundex code number for the second letter when the first and second letters use the same number. | String & binary functions |
| SPACE | Builds a string consisting of the specified number of blank spaces. | String & binary functions |
| <service_name>!SPCS_CANCEL_JOB | Cancels a Snowpark Container Services job; also referred to as job service. | Table functions |
| <service_name>!SPCS_GET_EVENTS | Returns the events that Snowflake collected for the specified service. | Table functions |
| <service_name>!SPCS_GET_LOGS | Returns the logs that Snowflake collected from containers of the specified service. | Table functions |
| <service_name>!SPCS_GET_METRICS | Returns the metrics that Snowflake collected for the specified service. | Table functions |
| <service_name>!SPCS_WAIT_FOR | Waits for the Snowpark Container Services service to reach the specified state, with a timeout. | Snowpark Container Services functions |
| SPLIT | Splits a given string with a given separator and returns the result in an array of strings. | String & binary functions |
| SPLIT_PART | Splits a given string at a specified character and returns the requested part. | String & binary functions |
| SPLIT_TEXT_MARKDOWN_HEADER (SNOWFLAKE.CORTEX) | The SPLIT_TEXT_MARKDOWN_HEADER function splits a Markdown-formatted document into structured text chunks based on header levels. | String & binary functions |
| SPLIT_TEXT_RECURSIVE_CHARACTER (SNOWFLAKE.CORTEX) | The SPLIT_TEXT_RECURSIVE_CHARACTER function splits a string into shorter stings, recursively, for preprocessing text to be used with text embedding or search indexing functions. | String & binary functions |
| SPLIT_TO_TABLE | This table function splits a string (based on a specified delimiter) and flattens the results into rows. | String & binary functions , Table functions |
| SQRT | Returns the square-root of a non-negative numeric expression. | Numeric functions |
| SQUARE | Returns the square of a numeric expression (i.e. a numeric expression multiplied by itself). | Numeric functions |
| ST_AREA | Returns the area of the Polygon(s) in a GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_ASEWKB | Given a value of type GEOGRAPHY or GEOMETRY, return the binary representation of that value in EWKB (extended well-known binary) format. | Geospatial functions |
| ST_ASEWKT | Given a value of type GEOGRAPHY or GEOMETRY, return the text (VARCHAR) representation of that value in EWKT (extended well-known text) format. | Geospatial functions |
| ST_ASGEOJSON | Given a value of type GEOGRAPHY or GEOMETRY, return the GeoJSON representation of that value. | Geospatial functions |
| ST_ASWKB , ST_ASBINARY | Given a value of type GEOGRAPHY or GEOMETRY, return the binary representation of that value in WKB (well-known binary) format. | Geospatial functions |
| ST_ASWKT , ST_ASTEXT | Given a value of type GEOGRAPHY or GEOMETRY, return the text (VARCHAR) representation of that value in WKT (well-known text) format. | Geospatial functions |
| ST_AZIMUTH | Given a Point that represents the origin (the location of the observer) and a specified Point, returns the azimuth in radians. | Geospatial functions |
| ST_BUFFER | Returns a GEOMETRY object that represents a MultiPolygon containing the points within a specified distance of the input GEOMETRY object. | Geospatial functions |
| ST_CENTROID | Returns the Point representing the geometric center of a GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_COLLECT | There are two forms of ST_COLLECT. | Geospatial functions |
| ST_CONTAINS | Returns TRUE if a GEOGRAPHY or GEOMETRY object is completely inside another object of the same type. | Geospatial functions |
| ST_COVEREDBY | Returns TRUE if no point in one geospatial object is outside another geospatial object. | Geospatial functions |
| ST_COVERS | Returns TRUE if no point in one geospatial object is outside of another geospatial object. | Geospatial functions |
| ST_DIFFERENCE | Given two input GEOGRAPHY objects, returns a GEOGRAPHY object that represents the points in the first object that are not in the second object (i.e. the difference between the two objects). | Geospatial functions |
| ST_DIMENSION | Given a value of type GEOGRAPHY or GEOMETRY, return the “dimension” of the value. | Geospatial functions |
| ST_DISJOINT | Returns TRUE if the two GEOGRAPHY objects or the two GEOMETRY objects are disjoint (i.e. do not share any portion of space). | Geospatial functions |
| ST_DISTANCE | Returns the minimum great circle distance between two GEOGRAPHY or the minimum Euclidean distance between two GEOMETRY objects. | Geospatial functions |
| ST_DWITHIN | Returns TRUE if the minimum great circle distance between two points (two GEOGRAPHY objects) is within the specified distance. | Geospatial functions |
| ST_ENDPOINT | Returns the last Point in a LineString. | Geospatial functions |
| ST_ENVELOPE | Returns the minimum bounding box (a rectangular “envelope”) that encloses a specified GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_GEOGFROMGEOHASH | Returns a GEOGRAPHY object for the polygon that represents the boundaries of a geohash. | Geospatial functions , Conversion functions |
| ST_GEOGPOINTFROMGEOHASH | Returns a GEOGRAPHY object for the Point that represents the center of a geohash. | Geospatial functions , Conversion functions |
| ST_GEOGRAPHYFROMWKB | Parses a WKB (well-known binary) or EWKB (extended well-known binary) input and returns a value of type GEOGRAPHY. | Geospatial functions , Conversion functions |
| ST_GEOGRAPHYFROMWKT | Parses a WKT (well-known text) or EWKT (extended well-known text) input and returns a value of type GEOGRAPHY. | Geospatial functions , Conversion functions |
| ST_GEOHASH | Returns the geohash for a GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_GEOMETRYFROMWKB | Parses a WKB (well-known binary) or EWKB (extended well-known binary) input and returns a value of type GEOMETRY. | Geospatial functions , Conversion functions |
| ST_GEOMETRYFROMWKT | Parses a WKT (well-known text) or EWKT (extended well-known text) input and returns a value of type GEOMETRY. | Geospatial functions , Conversion functions |
| ST_GEOMFROMGEOHASH | Returns a GEOMETRY object for the polygon that represents the boundaries of a geohash. | Geospatial functions |
| ST_GEOMPOINTFROMGEOHASH | Returns a GEOMETRY object for the point that represents center of a geohash. | Geospatial functions |
| ST_HAUSDORFFDISTANCE | Returns the discrete Hausdorff distance between two GEOGRAPHY objects. | Geospatial functions |
| ST_INTERPOLATE | Given an input GEOGRAPHY object, returns an interpolated object that is within a specified tolerance. | Geospatial functions |
| ST_INTERSECTION | Given two input GEOGRAPHY objects, returns a GEOGRAPHY object that represents the shape containing the set of points that are common to both input objects (i.e. the intersection of the two objects). | Geospatial functions |
| ST_INTERSECTION_AGG | Given a GEOGRAPHY column, returns a GEOGRAPHY object that represents the shape containing the combined set of points that are common to the shapes represented by the objects in the column (that is, the intersection of the shapes). | Geospatial functions |
| ST_INTERSECTS | Returns TRUE if the two GEOGRAPHY objects or the two GEOMETRY objects intersect (i.e. share any portion of space). | Geospatial functions |
| ST_ISVALID | Returns TRUE if the specified GEOGRAPHY or GEOMETRY object represents a valid shape. | Geospatial functions |
| ST_LENGTH | Returns the great circle length of the LineString(s) in a GEOGRAPHY object or the Euclidean length of the LineString(s) in a GEOMETRY object. | Geospatial functions |
| ST_MAKEGEOMPOINT , ST_GEOMPOINT | Constructs a GEOMETRY object that represents a Point with the specified longitude and latitude. | Geospatial functions |
| ST_MAKELINE | Constructs a GEOGRAPHY or GEOMETRY object that represents a line connecting the points in the input objects. | Geospatial functions |
| ST_MAKEPOINT , ST_POINT | Constructs a GEOGRAPHY object that represents a point with the specified longitude and latitude. | Geospatial functions |
| ST_MAKEPOLYGON , ST_POLYGON | Constructs a GEOGRAPHY or GEOMETRY object that represents a Polygon without holes. | Geospatial functions |
| ST_MAKEPOLYGONORIENTED | Constructs a GEOGRAPHY object that represents a Polygon without holes. | Geospatial functions |
| ST_NPOINTS , ST_NUMPOINTS | Returns the number of points in a GEOGRAPHY or GEOGRAPHY object. | Geospatial functions |
| ST_PERIMETER | Returns the length of the perimeter of the polygon(s) in a GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_POINTN | Returns a Point at a specified index in a LineString. | Geospatial functions |
| ST_SETSRID | Returns a GEOMETRY object that has its SRID (spatial reference system identifier) set to the specified value. | Geospatial functions |
| ST_SIMPLIFY | Given an input GEOGRAPHY or GEOMETRY object that represents a Line or Polygon, returns a simpler approximation of the object. | Geospatial functions |
| ST_SRID | Returns the SRID (spatial reference system identifier) of a GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_STARTPOINT | Returns the first Point in a LineString. | Geospatial functions |
| ST_SYMDIFFERENCE | Given two input GEOGRAPHY objects, returns a GEOGRAPHY object that represents the set of points from both input objects that are not part of the intersection of the objects (i.e. the symmetric difference of the two objects). | Geospatial functions |
| ST_TRANSFORM | Converts a GEOMETRY object from one spatial reference system (SRS) to another. | Geospatial functions |
| ST_UNION | Given two input GEOGRAPHY objects, returns a GEOGRAPHY object that represents the combined set of shapes for both objects (i.e. the union of the two shapes). | Geospatial functions |
| ST_UNION_AGG | Given a GEOGRAPHY column, returns a GEOGRAPHY object that represents the combined set of points that are in at least one of the shapes represented by the objects in the column (that is, the union of the shapes). | Geospatial functions |
| ST_WITHIN | Returns true if the first geospatial object is fully contained by the second geospatial object. | Geospatial functions |
| ST_X | Returns the longitude (X coordinate) of a Point represented by a GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_XMAX | Returns the maximum longitude (X coordinate) of all points contained in the specified GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_XMIN | Returns the minimum longitude (X coordinate) of all points contained in the specified GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_Y | Returns the latitude (Y coordinate) of a Point represented by a GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_YMAX | Returns the maximum latitude (Y coordinate) of all points contained in the specified GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| ST_YMIN | Returns the minimum latitude (Y coordinate) of all points contained in the specified GEOGRAPHY or GEOMETRY object. | Geospatial functions |
| STAGE_DIRECTORY_FILE_REGISTRATION_HISTORY | This table function can be used to query information about the metadata history for a directory table. | Information Schema , Table functions |
| STAGE_STORAGE_USAGE_HISTORY | 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. | Information Schema , Table functions |
| STARTSWITH | Returns true if expr1 starts with expr2. | String & binary functions |
| STDDEV, STDDEV_SAMP | Returns the sample standard deviation (square root of sample variance) of non-NULL values. | Aggregate functions , Window function syntax and usage |
| STDDEV_POP | Returns the population standard deviation (square root of variance) of non-NULL values. | Aggregate functions , Window function syntax and usage |
| STORAGE_LIFECYCLE_POLICY_HISTORY | Returns execution history for storage lifecycle policies in your account within the last 14 days. | Table functions |
| STRIP_NULL_VALUE | Converts a JSON null value to a SQL NULL value. | Semi-structured and structured data functions |
| STRTOK | Tokenizes a given string and returns the requested part. | String & binary functions |
| STRTOK_SPLIT_TO_TABLE | Tokenizes a string with the given set of delimiters and flattens the results into rows. | String & binary functions , Table functions |
| STRTOK_TO_ARRAY | Tokenizes the given string using the given set of delimiters and returns the tokens as an ARRAY value. | String & binary functions , Semi-structured and structured data functions |
| SUBSTR , SUBSTRING | Returns the portion of the string or binary value from base_expr, starting from the character/byte specified by start_expr, with optionally limited length. | String & binary functions |
| SUM | Returns the sum of non-NULL records for expr. | Aggregate functions , Window function syntax and usage |
| SUMMARIZE (SNOWFLAKE.CORTEX) | Summarizes the given English-language input text. | String & binary functions |
| SYS_CONTEXT | Returns information about the context in which the function is called. | Context functions |
| SYS_CONTEXT (SNOWFLAKE$APPLICATION namespace) | Returns information about the context in which a statement is executed within a Snowflake Native App. | Context functions |
| SYS_CONTEXT (SNOWFLAKE$ENVIRONMENT namespace) | Returns information about the environment (the client, current account, and current region) in which the function is called. | Context functions |
| SYS_CONTEXT (SNOWFLAKE$ORGANIZATION namespace) | Returns information about the current organization. | Context functions |
| SYS_CONTEXT (SNOWFLAKE$ORGANIZATION_SESSION namespace) | Returns information about the session in which the function is called and the current organization user. | Context functions |
| SYS_CONTEXT (SNOWFLAKE$SESSION namespace) | Returns information about the session in which the function is called. | Context functions |
| SYS_CONTEXT (SNOWFLAKE$SESSION_ATTRIBUTES namespace) | Returns a custom session attribute set using SET_SYS_CONTEXT. | Context functions |
| SYSDATE | Returns the current timestamp for the system in the UTC time zone. | Context functions |
| SYSTEM$ABORT_SESSION | Aborts the specified session. | System functions |
| SYSTEM$ABORT_TRANSACTION | Aborts the specified transaction, if it is running. | System functions |
| SYSTEM$ACTIVATE_CMK_INFO | Activates Tri-Secret Secure in your account, optionally with private connectivity, by using the customer-managed key (CMK) information that you registered for your account. | System functions |
| SYSTEM$ACTIVATE_CMK_INFO_POSTGRES | Activates Snowflake Postgres Tri-Secret Secure in your account by using the CMK (customer-managed key) information that you registered for your account. | System functions |
| SYSTEM$ADD_EVENT (for Snowflake Scripting) | Add an event for trace. | System functions |
| SYSTEM$ADD_REFERENCE | Called by a Snowflake Native App to associate a consumer reference string to a reference definition. | System functions |
| SYSTEM$ALLOWLIST | Returns host names and port numbers to add to your firewall’s allowed list so that you can access Snowflake from behind your firewall. | System functions |
| SYSTEM$ALLOWLIST_PRIVATELINK | Returns host names and port numbers for AWS PrivateLink, Azure Private Link, and Google Cloud Private Service Connect deployments to add to your firewall’s allowed list so that you can access Snowflake from behind your firewall. | System functions |
| SYSTEM$APP_COMPATIBILITY_CHECK | Returns the Snowflake edition of the consumer account where an app is installed. | System functions |
| SYSTEM$APPLICATION_GET_LOG_LEVEL | Returns the log level for the specified object. | System functions |
| SYSTEM$APPLICATION_GET_METRIC_LEVEL | Returns the metric level for the specified object. | System functions |
| SYSTEM$APPLICATION_GET_TRACE_LEVEL | Returns the trace level for the specified object. | System functions |
| SYSTEM$AUTHORIZE_PRIVATELINK | Enables private connectivity to the Snowflake service for the current account. | System functions |
| SYSTEM$AUTHORIZE_STAGE_PRIVATELINK_ACCESS | Authorizes Snowflake to access the private endpoint for Azure private endpoints for internal stages and Google Private Service Connect endpoints for internal stages for the current account. | System functions |
| SYSTEM$AUTO_REFRESH_STATUS | Returns the automated refresh status for an externally managed Iceberg table. | System functions |
| SYSTEM$BEGIN_DEBUG_APPLICATION | Enables session debug mode for a Snowflake Native App. | System functions |
| SYSTEM$BEHAVIOR_CHANGE_BUNDLE_STATUS | Returns the status of the specified behavior change release bundle for the current account. | System functions |
| SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS | Prevents all public traffic from accessing the internal stage of the current Snowflake account on Microsoft Azure. | System functions |
| SYSTEM$BLOCK_INTERNAL_STAGES_PUBLIC_ACCESS_WITH_EXCEPTION | Prevents public traffic from accessing the internal stage of the current Snowflake account on Microsoft Azure, while allowing access from specified IP addresses or CIDR blocks. | System functions |
| SYSTEM$CANCEL_ALL_QUERIES | Cancels all active/running queries in the specified session. | System functions |
| SYSTEM$CANCEL_QUERY | Cancels the specified query (or statement) if it is currently active/running. | System functions |
| SYSTEM$CATALOG_LINK_STATUS | Returns the link status for a specified catalog-linked database. | System functions |
| SYSTEM$CKE_HASH_FUNCTION | Analyzes Cortex Knowledge Extensions (CKE) usage by mapping hashedDocumentIds back to your original document primary keys in the Cortex Search Service. | System functions |
| SYSTEM$CLEANUP_DATABASE_ROLE_GRANTS | Revokes privileges on dropped objects from the share and grants the database role to the share. | System functions |
| SYSTEM$CLIENT_VERSION_INFO | Returns version information for Snowflake clients and drivers. | System functions |
| SYSTEM$CLIENT_VULNERABILITY_INFO | Returns details about common vulnerabilities and exposures (CVE) fixes and related vulnerabilities for Snowflake clients and drivers. | System functions |
| SYSTEM$CLUSTERING_DEPTH | Computes the average depth of the table according to the specified columns (or the clustering key defined for the table). | System functions |
| SYSTEM$CLUSTERING_INFORMATION | Returns clustering information, including average clustering depth, for a table based on one or more columns in the table. | System functions |
| SYSTEM$CLUSTERING_RATIO — Deprecated | Calculates the clustering ratio for a table, based on one or more columns in the table. | System functions |
| SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT | Finalizes the process of moving an organization account from one region to another. | System functions |
| SYSTEM$CONVERT_PIPES_SQS_TO_SNS | Convert pipes using Amazon SQS (Simple Queue Service) notifications to the Amazon Simple Notification Service (SNS) service for an S3 bucket. | System functions |
| SYSTEM$CREATE_BILLING_EVENT | Creates a billable event that tracks consumer usage of an installed monetized application. | System functions |
| SYSTEM$CREATE_BILLING_EVENTS | Creates multiple billable events that track consumer usage of installed monetized applications. | System functions |
| SYSTEM$CURRENT_USER_TASK_NAME | Returns the name of the task currently executing when invoked from the statement or stored procedure defined by the task. | System functions |
| SYSTEM$DATA_METRIC_SCAN | Returns the rows identified by a data quality metric as containing data that fails a data quality check. | System functions , Table functions |
| SYSTEM$DATABASE_REFRESH_HISTORY — Deprecated | Returns a JSON object showing the refresh history for a secondary database. | System functions |
| SYSTEM$DATABASE_REFRESH_PROGRESS , SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB — Deprecated | The SYSTEM$DATABASE_REFRESH_PROGRESS family of functions can be used to query the status of a database refresh along various dimensions. | System functions |
| SYSTEM$DEACTIVATE_CMK_INFO | De-activates Tri-Secret Secure in your account. | System functions |
| SYSTEM$DECODE_PAT | Returns information about a programmatic access token, given the secret for the token. | System functions |
| SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT | Deprovisions a private connectivity endpoint in the Snowflake VPC or VNet to prevent Snowflake from connecting to an external service by using private connectivity. | System functions |
| SYSTEM$DEPROVISION_PRIVATELINK_ENDPOINT_TSS | Deprovisions a private connectivity endpoint in the Snowflake VPC or VNet to prevent Snowflake from connecting to an external key management service (KMS) resource using private connectivity. | System functions |
| SYSTEM$DEREGISTER_CMK_INFO | Cancels registration of your currently-registered customer-managed key (CMK) for use with Tri-Secret Secure. | System functions |
| SYSTEM$DEREGISTER_CMK_INFO_POSTGRES | Cancels registration of your currently-registered customer-managed key (CMK) for use with Snowflake Postgres Tri-Secret Secure. | System functions |
| SYSTEM$DESC_ICEBERG_ACCESS_IDENTITY | Returns information about the Snowflake service principal for a specified external cloud provider in an account. | System functions |
| SYSTEM$DISABLE_BEHAVIOR_CHANGE_BUNDLE | Disables the behavior changes included in the specified behavior change release bundle for the current account. | System functions |
| SYSTEM$DISABLE_DATABASE_REPLICATION | Disable replication for a primary database and any secondary databases linked to it. | System functions |
| SYSTEM$DISABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT | Disables Cross-Cloud Auto-Fulfillment on an account. | System functions |
| SYSTEM$DISABLE_PREVIEW_ACCESS | Disables access to open preview and private preview features. | System functions |
| SYSTEM$DISABLE_PRIVATELINK_ACCESS_ONLY | Unblocks connections for inbound network traffic that are routed over the public internet. | System functions |
| SYSTEM$ENABLE_BEHAVIOR_CHANGE_BUNDLE | Enables behavior changes included in the specified behavior change release bundle for the current account. | System functions |
| SYSTEM$ENABLE_GLOBAL_DATA_SHARING_FOR_ACCOUNT | Enables Cross-Cloud Auto-Fulfillment on an account. | System functions |
| SYSTEM$ENABLE_PREVIEW_ACCESS | Enables access to open preview features. | System functions |
| SYSTEM$ENCODE_CKE_PRIMARY_KEY | Takes one or more primary key columns from a Cortex Knowledge Extensions (CKE) document and converts them into an encoded representation. | System functions |
| SYSTEM$END_DEBUG_APPLICATION | Disables session debug mode for a Snowflake Native App. | System functions |
| SYSTEM$ENFORCE_PRIVATELINK_ACCESS_ONLY | Enforces the behavior that successful connections to your Snowflake account use only your private endpoints. | System functions |
| SYSTEM$ESTIMATE_AUTOMATIC_CLUSTERING_COSTS | Returns estimated costs associated with enabling Automatic Clustering for a table. | System functions |
| SYSTEM$ESTIMATE_QUERY_ACCELERATION | For a previously executed query, this function returns a JSON object that specifies if the query is eligible to benefit from the query acceleration service. | System functions |
| SYSTEM$ESTIMATE_SEARCH_OPTIMIZATION_COSTS | Returns the estimated costs of adding search optimization to a given table and configuring specific columns for search optimization. | System functions |
| SYSTEM$EVALUATE_DATA_QUALITY_EXPECTATIONS | Returns the expectations for associations between data metric functions (DMFs) and a table, including whether an expectation is currently violated. | System functions , Table functions |
| SYSTEM$EXPLAIN_JSON_TO_TEXT | This function converts EXPLAIN output from JSON to formatted text. | System functions |
| SYSTEM$EXPLAIN_PLAN_JSON | Given the text of a SQL statement, this function generates the EXPLAIN plan in JSON. | System functions |
| SYSTEM$EXPORT_TDS_FROM_SEMANTIC_VIEW | Returns a semantic view in Tableau Data Source (TDS) format. | System functions |
| SYSTEM$EXTERNAL_TABLE_PIPE_STATUS | Retrieves a JSON representation of the current refresh status for the internal (hidden) pipe object associated with an external table. | System functions |
| SYSTEM$FINISH_OAUTH_FLOW | Sets the OAUTH_REFRESH_TOKEN parameter value of the secret passed as an argument in the SYSTEM$START_OAUTH_FLOW call that began the OAuth flow. | System functions |
| SYSTEM$GENERATE_SAML_CSR | Generates a certificate signing request (CSR) with the subject set to the subject of the certificate stored in the SAML2 integration and can specify the DN to be used in the CSR. | System functions |
| SYSTEM$GENERATE_SCIM_ACCESS_TOKEN | Returns a new SCIM access token that is valid for six months. | System functions |
| SYSTEM$GET_ALL_DEFAULT_COLUMNS_OVERRIDES | Returns the list of columns that were set by previous calls to SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND and SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT. | System functions |
| SYSTEM$GET_ALL_REFERENCES | Iterates through all associations for a reference and returns information about the associations. | System functions |
| SYSTEM$GET_AWS_SNS_IAM_POLICY | 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. | System functions |
| SYSTEM$GET_CATALOG_LINKED_DATABASE_CONFIG | Returns the configuration parameters set on the specified catalog-linked database. | System functions |
| SYSTEM$GET_CLASSIFICATION_RESULT | Returns the classification result of the specified object. | System functions |
| SYSTEM$GET_CMK_AKV_CONSENT_URL | Returns a consent URL to the Azure Key Vault account related to customer-managed keys. | System functions |
| SYSTEM$GET_CMK_CONFIG | Returns configuration information for use with customer-managed keys (CMKs) and Tri-Secret Secure. | System functions |
| SYSTEM$GET_CMK_CONFIG_POSTGRES | Returns configuration information for use with customer-managed keys (CMKs) and Snowflake Postgres Tri-Secret Secure. | System functions |
| SYSTEM$GET_CMK_INFO | Returns the status of your customer-managed key (CMK) for use with Tri-Secret Secure. | System functions |
| SYSTEM$GET_CMK_INFO_POSTGRES | Returns the status of your customer-managed key (CMK) for use with Snowflake Postgres Tri-Secret Secure. | System functions |
| SYSTEM$GET_CMK_KMS_KEY_POLICY | Returns an ARRAY containing a snippet of the AWS Key Management Service policy information related to customer-managed keys. | System functions |
| SYSTEM$GET_COMPUTE_POOL_PENDING_MAINTENANCE | Retrieves information about pending Snowflake maintenance actions for compute pools in the current account. | System functions |
| SYSTEM$GET_DBT_LOG | Returns logs for the specified run for a dbt Projects on Snowflake. | System functions |
| SYSTEM$GET_DEBUG_STATUS | Returns the session debug mode status of the current session. | System functions |
| SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND | Returns the list of columns that were set by a previous call to SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND. | System functions |
| SYSTEM$GET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT | Returns the list of columns that were set by a previous call to SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT for the specified Snowflake view (for example, for a specific ACCOUNT_USAGE view or INFORMATION_SCHEMA view). | System functions |
| SYSTEM$GET_DIRECTORY_TABLE_STATUS | Returns a list of records that contain the directory table consistency status for stages in your account. | System functions |
| SYSTEM$GET_GCP_KMS_CMK_GRANT_ACCESS_CMD | Returns a Google Cloud gcloud command to obtain policy information for the Google Cloud Key Management Service for use with customer-managed keys. | System functions |
| SYSTEM$GET_HASH_FOR_APPLICATION | Returns the hash value for a Snowflake Native App or query ID. | System functions |
| SYSTEM$GET_ICEBERG_TABLE_INFORMATION | Returns the location of the root metadata file and status of the latest snapshot for an Apache Iceberg™ table. | System functions |
| SYSTEM$GET_INSTANCE_FAMILY_PLACEMENT_GROUPS | Returns the list of placement groups supported for the specified instance family for Snowpark Container Services compute pool nodes. | System functions |
| SYSTEM$GET_LOGIN_FAILURE_DETAILS | Returns a JSON object that represents an unsuccessful login attempt associated with External OAuth, SAML, or key pair authentication. | System functions |
| SYSTEM$GET_PREDECESSOR_RETURN_VALUE | Retrieves the return value for the predecessor task in a task graph. | System functions |
| SYSTEM$GET_PREVIEW_ACCESS_STATUS | Determine if access to all preview features is enabled or disabled. | System functions |
| SYSTEM$GET_PRIVATELINK | Verifies whether your current account is authorized for private connectivity to the Snowflake service. | System functions |
| SYSTEM$GET_PRIVATELINK_AUTHORIZED_ENDPOINTS | Returns a list of the authorized endpoints for your current account to use with private connectivity to the Snowflake service. | System functions |
| SYSTEM$GET_PRIVATELINK_CONFIG | Returns a JSON representation of the Snowflake account information necessary to facilitate the self-service configuration of private connectivity to the Snowflake service or Snowflake internal stages. | System functions |
| SYSTEM$GET_PRIVATELINK_ENDPOINT_REGISTRATIONS | Returns the registered private endpoints that can route your connection to the Snowflake service. | System functions |
| SYSTEM$GET_PRIVATELINK_ENDPOINTS_INFO | Returns the status of all private connectivity endpoints that you provision. | System functions |
| SYSTEM$GET_PURCHASE_ATTRIBUTES | Identifies the behavior of a listing at runtime. | System functions |
| SYSTEM$GET_REFERENCED_OBJECT_ID_HASH | Returns the hash of the entity ID of the consumer object. | System functions |
| SYSTEM$GET_RESULTSET_STATUS | Returns the status of a RESULTSET in a Snowflake Scripting stored procedure. | System functions |
| SYSTEM$GET_SERVICE_DNS_DOMAIN | Given a schema name, returns that schema’s DNS namespace hash as a string. | System functions |
| SYSTEM$GET_SERVICE_LOGS | Retrieves local logs from a Snowpark Container Services service container. | System functions |
| SYSTEM$GET_SERVICE_STATUS — Deprecated | Retrieves the status of a Snowpark Container Services service. | System functions |
| SYSTEM$GET_SNOWFLAKE_EGRESS_IP_RANGES | Returns a list of egress IP address ranges (as Classless Inter-Domain Routing (CIDR) IP addresses) that you can use to represent Snowflake in a server’s IP allowlist. | System functions |
| SYSTEM$GET_SNOWFLAKE_PLATFORM_INFO | Returns platform information for the cloud provider that hosts your Snowflake account. | System functions |
| SYSTEM$GET_STAGE_PRIVATELINK_AUTHORIZED_ENDPOINTS | Returns the list of private connectivity sources (Azure private endpoints or Google Cloud VPC networks) that have been authorized to access the internal stage of the current account. | System functions |
| SYSTEM$GET_TAG | Returns the tag value associated with the specified Snowflake object or column. | System functions |
| SYSTEM$GET_TAG_ALLOWED_VALUES | Returns a comma-separated list of string values that can be set on a supported object, or NULL to indicate the tag key does not have any specified string values and accepts all possible string values. | System functions |
| SYSTEM$GET_TAG_ON_CURRENT_COLUMN | Returns the tag string value assigned to the column based upon the specified tag or NULL if a tag is not assigned to the specified column. | System functions |
| SYSTEM$GET_TAG_ON_CURRENT_TABLE | Returns the tag string value assigned to the table based upon the specified tag or NULL if a tag is not assigned to the specified table. | System functions |
| SYSTEM$GET_TASK_GRAPH_CONFIG | Returns information from a task graph configuration. | System functions |
| SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER | Enables replication and failover features for a specified account in an organization. | System functions |
| SYSTEM$HOLD_PRIVILEGE_ON_ACCOUNT | Indicates if a privilege has been granted to a Snowflake Native App. | System functions |
| SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT | Starts the process of moving an organization account to a new region. | System functions |
| SYSTEM$INTERNAL_STAGES_PUBLIC_ACCESS_STATUS | Checks to see whether public IP addresses are allowed to access the internal stage of the current Snowflake account on Microsoft Azure. | System functions |
| SYSTEM$IS_APPLICATION_ALL_MANDATORY_TELEMETRY_EVENT_DEFINITIONS_ENABLED | Indicates that the AUTHORIZE_TELEMETRY_EVENT_SHARING property has been set on the app. | System functions |
| SYSTEM$IS_APPLICATION_AUTHORIZED_FOR_TELEMETRY_EVENT_SHARING | Indicates that the AUTHORIZE_TELEMETRY_EVENT_SHARING has been set on the app. | System functions |
| SYSTEM$IS_APPLICATION_INSTALLED_FROM_SAME_ACCOUNT | Shows if an app is installed on the same account as the application package it is based on. | System functions |
| SYSTEM$IS_APPLICATION_SHARING_EVENTS_WITH_PROVIDER | Shows if event sharing is enabled. | System functions |
| SYSTEM$IS_GLOBAL_DATA_SHARING_ENABLED_FOR_ACCOUNT | Specifies whether Cross-Cloud Auto-Fulfillment is enabled or disabled on an account. | System functions |
| SYSTEM$IS_LISTING_PURCHASED | Returns TRUE if the consumer account querying data has purchased the listing, otherwise returns FALSE. | System functions |
| SYSTEM$IS_LISTING_TRIAL | Limits the functionality of a Snowflake Native App based on whether a consumer is trialing the application as part of a Limited trial listings or has access to the full data product. | System functions |
| SYSTEM$LAST_CHANGE_COMMIT_TIME | Returns a token that can be used to detect whether a database table or view changed between two calls to the function. | System functions |
| SYSTEM$LINK_ACCOUNT_OBJECTS_BY_NAME | Adds a global identifier to account objects in the target (current) account that were created using scripts and that match objects with the same names in the source account. | System functions |
| SYSTEM$LINK_ORGANIZATION_USER | Links an organization user with a user that already exists in the regular account. | System functions |
| SYSTEM$LINK_ORGANIZATION_USER_GROUP | Links an organization user group with an access control role that already exists in the regular account. | System functions |
| SYSTEM$LIST_APPLICATION_RESTRICTED_FEATURES | Returns a JSON object containing a list of restricted features that the consumer has allowed a Snowflake Native App to use. | System functions |
| SYSTEM$LIST_ICEBERG_TABLES_FROM_CATALOG | Lists tables in a remote Apache Iceberg™ REST catalog (including Snowflake Open Catalog). | System functions |
| SYSTEM$LIST_NAMESPACES_FROM_CATALOG | Lists the namespaces in a remote Apache Iceberg™ REST catalog (including Snowflake Open Catalog). | System functions |
| SYSTEM$LOCATE_DBT_ARCHIVE | Returns the URL from which you can retrieve zipped dbt run artifacts for a specified dbt project. | System functions |
| SYSTEM$LOCATE_DBT_ARTIFACTS | Returns the location of artifacts from a specified dbt Project run (for example, manifest.json). | System functions |
| SYSTEM$LOG, SYSTEM$LOG_<level> (for Snowflake Scripting) | Logs a message at the specified severity level. | System functions |
| SYSTEM$MIGRATE_SAML_IDP_REGISTRATION | Migrates an existing SAML identity provider (i.e. IdP) configuration as defined by the account parameter SAML_IDENTITY_PROVIDER to a security integration. | System functions |
| SYSTEM$OPT_IN_INTERNAL_STAGE_NETWORK_LOGS | Starts record collection of network access attempts to internal stage locations for this account. | System functions |
| SYSTEM$OPT_OUT_INTERNAL_STAGE_NETWORK_LOGS | Stops record collection of network access attempts to internal stage locations for this account. | System functions |
| SYSTEM$OPT_OUT_MALICIOUS_IP_PROTECTION_BY_CATEGORY | Disables Malicious IP Protection for one or more curated IP categories in the current account. | System functions |
| SYSTEM$PIPE_FORCE_RESUME | Forces a pipe paused using ALTER PIPE to resume. | System functions |
| SYSTEM$PIPE_REBINDING_WITH_NOTIFICATION_CHANNEL | Retries the notification channel binding process when a replicated pipe has not been successfully bound to a notification channel during replication time. | System functions |
| SYSTEM$PIPE_STATUS | Retrieves a JSON representation of the current status of a pipe. | System functions |
| SYSTEM$PROVISION_PRIVATELINK_ENDPOINT | Provisions a private connectivity endpoint in the Snowflake VPC or VNet to enable Snowflake to connect to an external service by using private connectivity. | System functions |
| SYSTEM$PROVISION_PRIVATELINK_ENDPOINT_TSS | Provisions a private connectivity endpoint in the Snowflake VPC or VNet to enable Snowflake to connect to a key management service (KMS) by using private connectivity. | System functions |
| SYSTEM$QUERY_REFERENCE | Returns a query reference that you can pass to a stored procedure. | System functions |
| SYSTEM$READ_YAML_FROM_SEMANTIC_VIEW | Returns the specification of a semantic model (in YAML format) for a semantic view. | System functions |
| SYSTEM$REFERENCE | Returns a reference to an object (a table, view, or function). | System functions |
| SYSTEM$REGISTER_CMK_INFO | Registers your customer-managed key (CMK) for use with Tri-Secret Secure. | System functions |
| SYSTEM$REGISTER_CMK_INFO_POSTGRES | Registers your customer-managed key (CMK) for use with Snowflake Postgres Tri-Secret Secure. | System functions |
| SYSTEM$REGISTER_PRIVATELINK_ENDPOINT | Registers a private connectivity endpoint to route your connection to the Snowflake service. | System functions |
| SYSTEM$REGISTRY_LIST_IMAGES — Deprecated | Lists images in an image repository. | System functions |
| SYSTEM$REMOVE_ALL_REFERENCES | Deletes all associations to the reference. | System functions |
| SYSTEM$REMOVE_REFERENCE | Remove an association from the reference to an object in the consumer account and returns a unique system-generated alias for the reference. | System functions |
| SYSTEM$REPORT_HEALTH_STATUS | Sends application health information from a consumer app to the provider account. | System functions |
| SYSTEM$RESOLVE_PYTHON_PACKAGES | Returns a list of the resolved dependencies and their versions for the Python packages that were specified. | System functions |
| SYSTEM$RESTORE_PRIVATELINK_ENDPOINT | Restores a private connectivity endpoint in the Snowflake VPC or VNet to enable Snowflake to connect to an external service using private connectivity. | System functions |
| SYSTEM$RESTORE_PRIVATELINK_ENDPOINT_TSS | Restores a private connectivity endpoint in the Snowflake VPC or VNet to enable Snowflake to connect to an external key management service (KMS) resource by using private connectivity. | System functions |
| SYSTEM$REVOKE_PRIVATELINK | Disables private connectivity to the Snowflake service for the current account. | System functions |
| SYSTEM$REVOKE_STAGE_PRIVATELINK_ACCESS | Revokes the authorization for Snowflake to access the private endpoint for Azure private endpoints for internal stages and Google Private Service Connect endpoints for internal stages for the current account. | System functions |
| SYSTEM$SAP_BDC_LIST_SHARES | Lists Data Products shared by SAP® Business Data Cloud with the enrolled catalog integration. | System functions |
| SYSTEM$SCHEDULE_ASYNC_REPLICATION_GROUP_REFRESH | Starts a refresh operation for a replication group or a failover group, in the background. | System functions |
| SYSTEM$SEND_NOTIFICATIONS_TO_CATALOG | Sends a notification to Snowflake Open Catalog to update Snowflake-managed Apache Iceberg™ tables in Open Catalog with the latest table changes, and returns whether the notification was sent successfully along with an error code and error message for the failure, if applicable. | System functions |
| SYSTEM$SET_APPLICATION_RESTRICTED_FEATURE_ACCESS | Enables a restricted feature for a Snowflake Native App. | System functions |
| SYSTEM$SET_CATALOG_INTEGRATION | Replaces the catalog integration associated with an externally managed Apache Iceberg™ table. | System functions |
| SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND | Controls the columns that should be returned when the specified SHOW <objects> command is executed. | System functions |
| SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT | Controls the columns that should be returned when you select all columns (SELECT *) from the specified Snowflake view (for example, from a specific ACCOUNT_USAGE view or INFORMATION_SCHEMA view). | System functions |
| SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION | Sets the event account for a region. | System functions |
| SYSTEM$SET_PRIVATELINK_ENDPOINT_HOSTNAME | Modifies only the host name of an existing private connectivity endpoint. | System functions |
| SYSTEM$SET_REFERENCE | Called by a Snowflake Native App to associate a consumer reference string to a reference definition. | System functions |
| SYSTEM$SET_RETURN_VALUE | Explicitly sets the return value for a task. | System functions |
| SYSTEM$SET_ROW_TIMESTAMP_ON_ALL_SUPPORTED_TABLES | Use this system function to bulk enable row timestamps on existing tables. | System functions |
| SYSTEM$SET_SPAN_ATTRIBUTES (for Snowflake Scripting) | Sets attribute name and value associated with a span containing trace events. | System functions |
| SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES | Returns an array of the currently available behavior change release bundles, the default state of each bundle, and the actual state of the bundle for the current account. | System functions |
| SYSTEM$SHOW_BUDGETS_FOR_RESOURCE | Returns a string containing a list of the budgets that track a specified resource (for example, a table or a schema). | System functions |
| SYSTEM$SHOW_BUDGETS_IN_ACCOUNT | Returns the budgets in the account for which you have access privileges. | System functions |
| SYSTEM$SHOW_EVENT_SHARING_ACCOUNTS | Shows event accounts in a provider organization. | System functions |
| SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS | Returns the status of an attempt to move an organization account. | System functions |
| SYSTEM$SHOW_OAUTH_CLIENT_SECRETS | Returns the client secrets in a string. | System functions |
| SYSTEM$SHOW_SENSITIVE_DATA_MONITORED_ENTITIES | Returns a JSON array of databases or schemas that are associated with a classification profile, which indicates that objects in these entities are monitored by sensitive data classification. | System functions |
| SYSTEM$SNOWPIPE_STREAMING_UPDATE_CHANNEL_OFFSET_TOKEN | Updates the offset token for a particular channel used by Snowpipe Streaming with a new offset token. | System functions |
| SYSTEM$START_OAUTH_FLOW | Initiates the OAUTH client flow, returning a URL you use in a browser to complete the OAuth consent process. | System functions |
| SYSTEM$START_USER_EMAIL_VERIFICATION | Starts the email verification process for a user. | System functions |
| SYSTEM$STREAM_BACKLOG | Returns the set of table versions between the current offset for a specified stream and the current timestamp. | Table functions , System functions |
| SYSTEM$STREAM_GET_TABLE_TIMESTAMP | Returns the timestamp in nanoseconds of the latest table version at or before the current offset for the specified stream. | System functions |
| SYSTEM$STREAM_HAS_DATA | Indicates whether a specified stream contains change data capture (CDC) records. | System functions |
| SYSTEM$SUPPORTED_DBT_VERSIONS | Returns a JSON array containing the versions that Snowflake supports for dbt Projects. | System functions |
| SYSTEM$TASK_DEPENDENTS_ENABLE | Recursively resumes a specified task and all its dependent tasks. | System functions |
| SYSTEM$TASK_RUNTIME_INFO | Returns information about the current task run. | System functions |
| SYSTEM$TRIGGER_LISTING_REFRESH | Triggers a one-time, on-demand data refresh for a provider’s databases or listings, accessible to all consumers. | System functions |
| SYSTEM$TYPEOF | Returns a string representing the SQL data type associated with an expression. | System functions |
| SYSTEM$UNBLOCK_INTERNAL_STAGES_PUBLIC_ACCESS | Allows traffic from public IP addresses to access the internal stage of the current Snowflake account on Microsoft Azure. | System functions |
| SYSTEM$UNLINK_ORGANIZATION_USER | Unlinks a user object from an organization user so it can be managed as a local user going forward. | System functions |
| SYSTEM$UNLINK_ORGANIZATION_USER_GROUP | Unlinks an access control role from an organization user group so it can be managed as a local role going forward. | System functions |
| SYSTEM$UNREGISTER_PRIVATELINK_ENDPOINT | Unregisters a private connectivity endpoint to route your connection to the Snowflake service. | System functions |
| SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND | Clears the list of columns specified by a previous call to SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SHOW_COMMAND for a type of object. | System functions |
| SYSTEM$UNSET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT | Clears the list of columns specified by a previous call to SYSTEM$SET_DEFAULT_COLUMNS_OVERRIDE_FOR_SYSTEM_OBJECT for the specified Snowflake view (for example, for a specific ACCOUNT_USAGE view or INFORMATION_SCHEMA view). | System functions |
| SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION | Unsets the events account for a region. | System functions |
| SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS | Cancels a run of the specified task that the system has already started to process (that is, a run with an EXECUTING state in the TASK_HISTORY output). | System functions |
| SYSTEM$VALIDATE_STORAGE_INTEGRATION | Validates the configuration for a specified storage integration. | System functions |
| SYSTEM$VERIFY_CATALOG_INTEGRATION | Verifies the configuration for a specified catalog integration for Apache Iceberg™ REST. | System functions |
| SYSTEM$VERIFY_CMK_INFO | Verifies your customer-managed key (CMK) configuration and returns a message about the registered CMK. | System functions |
| SYSTEM$VERIFY_CMK_INFO_POSTGRES | Verifies your customer-managed key (CMK) configuration for Snowflake Postgres Tri-Secret Secure and returns a message about the registered CMK. | System functions |
| SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN | Determines whether your External OAuth access token is valid or has expired and needs to be regenerated. | System functions |
| SYSTEM$VERIFY_EXTERNAL_VOLUME | Verifies the configuration for a specified external volume. | System functions |
| SYSTEM$WAIT | Waits for the specified amount of time before proceeding. | System functions |
| SYSTEM$WAIT_FOR_SERVICES | Waits for one or more Snowpark Container Services services to reach the READY state (or becomes upgraded) before returning. | System functions |
| SYSTEM$WHITELIST — Deprecated | Returns hostnames and port numbers to add to your firewall’s allowed list so that you can access Snowflake from behind your firewall. | System functions |
| SYSTEM$WHITELIST_PRIVATELINK — Deprecated | Returns hostnames and port numbers for AWS PrivateLink, Azure Private Link, and Google Cloud Private Service Connect deployments to add to your firewall’s allowed list so that you can access Snowflake from behind your firewall. | System functions |
| SYSTIMESTAMP | Returns the current timestamp for the system. | Context functions |
| T | ||
| TAG_REFERENCES | Returns a table in which each row displays an association between a tag and value. | Information Schema , Table functions |
| TAG_REFERENCES_ALL_COLUMNS | Returns a table in which each row displays the tag name and tag value assigned to a specific column. | Information Schema , Table functions |
| TAG_REFERENCES_WITH_LINEAGE | Returns a table in which each row displays an association between the specified tag and the Snowflake object to which the tag is associated. | Account Usage table functions , Table functions |
| TAN | Computes the tangent of its argument; the argument should be expressed in radians. | Numeric functions |
| TANH | Computes the hyperbolic tangent of its argument. | Numeric functions |
| TASK_DEPENDENTS | This table function returns the list of child tasks for a given root task in a task graph. | Information Schema , Table functions |
| TASK_HISTORY | You can use this table function to query the history of task usage within a specified date range. | Information Schema , Table functions |
| TEXT_HTML | Returns a JSON object that specifies the HTML message to use for a notification. | Notification functions |
| TEXT_PLAIN | Returns a JSON object that specifies the plain text message to use for a notification. | Notification functions |
| TIME_FROM_PARTS | Creates a time from individual numeric components. | Date & time functions |
| TIME_SLICE | 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.). | Date & time functions |
| TIMEADD | Adds the specified value for the specified date or time part to a date, time, or timestamp. | Date & time functions |
| TIMEDIFF | Calculates the difference between two date, time, or timestamp expressions based on the specified date or time part. | Date & time functions |
| TIMESTAMP_FROM_PARTS | Creates a timestamp from individual numeric components. | Date & time functions |
| TIMESTAMPADD | Adds the specified value for the specified date or time part to a date, time, or timestamp. | Date & time functions |
| TIMESTAMPDIFF | Calculates the difference between two date, time, or timestamp expressions based on the specified date or time part. | Date & time functions |
| TO_ARRAY | Converts the input expression to an ARRAY value. | Conversion functions , Semi-structured and structured data functions |
| TO_BINARY | Converts the input expression to a binary value. | Conversion functions |
| TO_BOOLEAN | Converts the input text or numeric expression to a BOOLEAN value. | Conversion functions |
| TO_CHAR , TO_VARCHAR | Converts the input expression to a string. | Conversion functions |
| TO_DATE , DATE | Converts an input expression to a date. | Conversion functions , Date & time functions |
| TO_DECFLOAT | Converts an expression to a decimal floating-point number (DECFLOAT). | Conversion functions |
| TO_DECIMAL , TO_NUMBER , TO_NUMERIC | Converts an input expression to a fixed-point number. | Conversion functions |
| TO_DOUBLE | Converts an expression to a double-precision floating-point number. | Conversion functions |
| TO_FILE | Constructs a value of type FILE from a file location or from metadata. | File functions |
| TO_GEOGRAPHY | Parses an input and returns a value of type GEOGRAPHY. | Geospatial functions , Conversion functions |
| TO_GEOMETRY | Parses an input and returns a value of type GEOMETRY. | Geospatial functions , Conversion functions |
| TO_JSON | Converts a VARIANT value to a string containing the JSON representation of the value. | Conversion functions , Semi-structured and structured data functions |
| TO_OBJECT | Converts the input value to an OBJECT. | Conversion functions , Semi-structured and structured data functions |
| TO_QUERY | Returns a result set based on SQL text and an optional set of arguments that are passed to the SQL text if it is parameterized. | Table functions |
| TO_TIME , TIME | Converts an input expression into a time. | Conversion functions , Date & time functions |
| TO_TIMESTAMP / TO_TIMESTAMP_* | Converts an input expression into the corresponding timestamp. | Conversion functions , Date & time functions |
| TO_UUID | Converts the input expression to a UUID value. | Conversion functions |
| TO_VARIANT | Converts any value to a VARIANT value or NULL (if input is NULL). | Conversion functions |
| TO_XML | Converts a VARIANT to a VARCHAR that contains an XML representation of the value. | Conversion functions , Semi-structured and structured data functions |
| TRANSFORM | Transforms an array based on the logic in a lambda expression. | Semi-structured and structured data functions |
| TRANSLATE (SNOWFLAKE.CORTEX) | Translates the given input text from one supported language to another. | String & binary functions |
| TRANSLATE | Replaces characters in a string. | String & binary functions |
| TRIM | Removes leading and trailing characters from a string. | String & binary functions |
| TRUNCATE , TRUNC | Rounds the input expression down to the nearest (or equal) value closer to zero. | Numeric functions |
| TRUNCATE, TRUNC | Truncates a DATE, TIME, or TIMESTAMP value to the specified precision. | Date & time functions |
| TRY_BASE64_DECODE_BINARY | A special version of BASE64_DECODE_BINARY that returns a NULL value if an error occurs during decoding. | String & binary functions |
| TRY_BASE64_DECODE_STRING | A special version of BASE64_DECODE_STRING that returns a NULL value if an error occurs during decoding. | String & binary functions |
| TRY_CAST | A special version of CAST , :: that is available for a subset of data type conversions. | Conversion functions |
| TRY_COMPLETE (SNOWFLAKE.CORTEX) | Performs the same operation as the COMPLETE function but returns NULL instead of raising an error when the operation cannot be performed. | String & binary functions |
| TRY_DECRYPT | A special version of DECRYPT that returns a NULL value if an error occurs during decryption. | Encryption functions |
| TRY_DECRYPT_RAW | A special version of DECRYPT_RAW that returns a NULL value if an error occurs during decryption. | Encryption functions |
| TRY_HEX_DECODE_BINARY | A special version of HEX_DECODE_BINARY that returns a NULL value if an error occurs during decoding. | String & binary functions |
| TRY_HEX_DECODE_STRING | A special version of HEX_DECODE_STRING that returns a NULL value if an error occurs during decoding. | String & binary functions |
| TRY_PARSE_JSON | A special version of PARSE_JSON that returns a NULL value if an error occurs during parsing. | Semi-structured and structured data functions |
| TRY_TO_BINARY | 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). | Conversion functions |
| TRY_TO_BOOLEAN | A special version of TO_BOOLEAN that performs the same operation (that is, converts an input expression to a Boolean value), but with error-handling support. | Conversion functions |
| TRY_TO_DATE | A special version of the TO_DATE function 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). | Conversion functions , Date & time functions |
| TRY_TO_DECFLOAT | A special version of TO_DECFLOAT that performs the same operation — that is, converts an input expression to a DECFLOAT — but with error-handling support. | Conversion functions |
| TRY_TO_DECIMAL, TRY_TO_NUMBER, TRY_TO_NUMERIC | A special version of TO_DECIMAL , TO_NUMBER , TO_NUMERIC that performs the same operation of converting an input expression to a fixed-point number, but has error-handling support so that the function returns NULL if the conversion can’t be performed. | Conversion functions |
| TRY_TO_DOUBLE | A special version of TO_DOUBLE that performs the same operation (that is, converts an input expression to a double-precision floating-point number), but with error-handling support (that is, if the conversion can’t be performed, it returns a NULL value instead of raising an error). | Conversion functions |
| TRY_TO_FILE | A version of TO_FILE that returns NULL instead of raising an error. | File functions |
| TRY_TO_GEOGRAPHY | Parses an input and returns a value of type GEOGRAPHY. | Geospatial functions , Conversion functions |
| TRY_TO_GEOMETRY | Parses an input and returns a value of type GEOMETRY. | Geospatial functions , Conversion functions |
| TRY_TO_TIME | 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). | Conversion functions |
| TRY_TO_TIMESTAMP / TRY_TO_TIMESTAMP_* | 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). | Conversion functions |
| TRY_TO_UUID | A special version of TO_UUID that performs the same operation — that is, converts an input expression to a UUID value — but with error handling support. | Conversion functions |
| TYPEOF | Returns the type of a value stored in a VARIANT column. | Semi-structured and structured data functions |
| U | ||
| UNICODE | Returns the Unicode code point for the first Unicode character in a string. | String & binary functions |
| UNIFORM | Generates a uniformly-distributed pseudo-random number in the inclusive range [min, max]. | Data generation functions |
| UPPER | Returns the input string with all characters converted to uppercase. | String & binary functions |
| UUID_STRING | Generates either a version 4 (random) or version 5 (named) RFC 4122-compliant universally unique identifier (UUID) as a formatted string. | String & binary functions , Data generation functions |
| V | ||
| VALIDATE | 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. | Table functions |
| VALIDATE_PIPE_LOAD | This table function can be used to validate data files processed by Snowpipe within a specified time range. | Information Schema , Table functions |
| VAR_POP | Returns the population variance of non-NULL records in a group. | Aggregate functions , Window function syntax and usage |
| VAR_SAMP | Returns the sample variance of non-NULL records in a group. | Aggregate functions , Window function syntax and usage |
| VARIANCE , VARIANCE_SAMP | Returns the sample variance of non-NULL records in a group. | Aggregate functions , Window function syntax and usage |
| VARIANCE_POP | Returns the population variance of non-NULL records in a group. | Aggregate functions , Window function syntax and usage |
| VECTOR_AVG | Computes the element-wise average of vectors in an aggregate. | Vector functions , Aggregate functions |
| VECTOR_COSINE_SIMILARITY | Computes the cosine similarity between two vectors. | Vector functions |
| VECTOR_INNER_PRODUCT | Computes the inner product of two vectors. | Vector functions |
| VECTOR_L1_DISTANCE | Computes the L1 distance between two vectors. | Vector functions |
| VECTOR_L2_DISTANCE | Computes the L2 distance between two vectors. | Vector functions |
| VECTOR_MAX | Computes the element-wise maximum of vectors in an aggregate. | Vector functions , Aggregate functions |
| VECTOR_MIN | Computes the element-wise minimum of vectors in an aggregate. | Vector functions , Aggregate functions |
| VECTOR_NORMALIZE | Normalizes a VECTOR in the L2 vector space, giving its elements values in the range of [0,1] and giving it a magnitude of 1. | Vector functions |
| VECTOR_SUM | Computes the element-wise sum of vectors in an aggregate. | Vector functions , Aggregate functions |
| VECTOR_TRUNCATE | Truncates a VECTOR to a smaller dimension. | Vector functions |
| W | ||
| WAREHOUSE_LOAD_HISTORY | 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. | Information Schema , Table functions |
| WAREHOUSE_METERING_HISTORY | 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. | Information Schema , Table functions |
| WIDTH_BUCKET | 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. | Numeric functions |
| X | ||
| XMLGET | Extracts an XML element object (often referred to as simply a tag) from the content of the outer XML element based on the name and instance number of the specified tag. | Semi-structured and structured data functions |
| Y | ||
| YEAR* / DAY* / WEEK* / MONTH / QUARTER | Extracts the corresponding date part from a date or timestamp. | Date & time functions |
| Z | ||
| ZEROIFNULL | Returns 0 if its argument is null; otherwise, returns its argument. | Conditional expression functions |
| ZIPF | Returns a Zipf-distributed integer, for N elements and characteristic exponent s. | Data generation functions |