Yandex Cloud
Search
Contact UsGet started
  • Blog
  • Pricing
  • Documentation
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • Containers
    • Developer tools
    • Serverless
    • Security
    • Monitoring & Resources
    • ML & AI
    • Business tools
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Customer Stories
    • Gateway to Russia
    • Cloud for Startups
    • Education and Science
  • Blog
  • Pricing
  • Documentation
Yandex project
© 2025 Yandex.Cloud LLC
Yandex DataLens
    • Overview
    • Formula syntax
      • All Functions
      • Function Availability
    • Parameters
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. Function Availability

Function Availability

Written by
Yandex Cloud
Improved by
amatol
Updated at March 5, 2025

Function availability for various data source types.

Function ClickHouse
21.8
ClickHouse
22.10
Files Google Sheets Yandex Metrica Microsoft
SQL Server 2017
(14.0)
MySQL
5.7
MySQL
8.0.12
Oracle
Database 12c
(12.1)
PostgreSQL
9.3
PostgreSQL
9.4
Yandex Documents YDB
(YQL)
Addition and concatenation (+) X X X X X X X X X X X X X
Comparison X X X X X X X X X X X X X
Division (/) X X X X X X X X X X X X X
Modulo (%) X X X X X X X X X X X X
Multiplication (*) X X X X X X X X X X X X X
Negation (-) X X X X X X X X X X X X
Power (^) X X X X X X X X X X X X
Subtraction (-) X X X X X X X X X X X X X
ABS X X X X X X X X X X X X
ACOS X X X X X X X X X X X X
AGO X X X X X X X X X X X X X
ALL_CONCAT X X X X X X X X
AND X X X X X X X X X X X X X
ANY X X X X X X X X
ARG_MAX X X X X X X
ARG_MIN X X X X X X
ARRAY X X X X X X X
ARR_AVG X X X X X
ARR_INTERSECT X X X X X X X
ARR_MAX X X X X X
ARR_MIN X X X X X
ARR_PRODUCT X X X X X
ARR_REMOVE X X X X X X X
ARR_STR X X X X X X X
ARR_SUM X X X X X
ASCII X X X X X X X X X X X X
ASIN X X X X X X X X X X X X
ATAN X X X X X X X X X X X X
ATAN2 X X X X X X X X X X X X
AT_DATE X X X X X X X X X X X X X
AVG X X X X X X X X X X X X
AVG (window) X X X X X X X X X X X
AVG_IF X X X X X X X X X X X X
AVG_IF (window) X X X X X X X X X X X
BETWEEN X X X X X X X X X X X X X
BOLD X X X X X X X X X X X X
BOOL X X X X X X X X X X X X
BR X X X X X X X X X X X X
CASE X X X X X X X X X X X X
CAST_ARR_FLOAT X X X X X X X
CAST_ARR_INT X X X X X X X
CAST_ARR_STR X X X X X X X
CEILING X X X X X X X X X X X X
CHAR X X X X X X X X X X X X
COLOR X X X X X X X X X X X X
COMPARE X X X X X
CONCAT X X X X X X X X X X X X
CONTAINS (array) X X X X X X X
CONTAINS (string) X X X X X X X X X X X X X
CONTAINS_ALL X X X X X X X
CONTAINS_ANY X X X X X X X
CONTAINS_SUBSEQUENCE X X X X X
COS X X X X X X X X X X X X
COT X X X X X X X X X X X X
COUNT X X X X X X X X X X X X
COUNT (window) X X X X X X X X X X X
COUNTD X X X X X X X X X X X X
COUNTD_APPROX X X X X X X X
COUNTD_IF X X X X X X X X X X X X
COUNT_IF X X X X X X X X X X X X
COUNT_IF (window) X X X X X X X X X X X
COUNT_ITEM X X X X X X X
DATE X X X X X X X X X X X X
DATEADD X X X X X X X X X X X X X
DATEPART X X X X X X X X X X X X
DATETIME X X X X X X X X X X X X X
DATETIME_PARSE X X X X X
DATETRUNC X X X X X X X X X X X X
DATE_PARSE X X X X X
DAY X X X X X X X X X X X X
DAYOFWEEK X X X X X X X X X X X X
DB_CAST X X X X X X X
DEGREES X X X X X X X X X X X X
DIV X X X X X X X X X X X X
DIV_SAFE X X X X X X X X X X X X
ENDSWITH X X X X X X X X X X X X X
EXP X X X X X X X X X X X X
FDIV_SAFE X X X X X X X X X X X X
FIND X X X X X X X X X X X X
FIRST (window) X X X X X X X X X X X
FLOAT X X X X X X X X X X X X
FLOOR X X X X X X X X X X X X
GEOPOINT X X X X X X X X X X X X
GEOPOLYGON X X X X X X X X X X X X
GET_ITEM X X X X X X X
GREATEST X X X X X X X X X X X X
HOUR X X X X X X X X X X X X
ICONTAINS X X X X X X X X X X X X
IENDSWITH X X X X X X X X X X X X
IF X X X X X X X X X X X X
IFNULL X X X X X X X X X X X X
IMAGE X X X X X X X X X X X X
IN X X X X X X X X X X X X X
INT X X X X X X X X X X X X
IS FALSE X X X X X X X X X X X X
IS TRUE X X X X X X X X X X X X
ISNULL X X X X X X X X X X X X
ISTARTSWITH X X X X X X X X X X X X
ITALIC X X X X X X X X X X X X
LAG (window) X X X X X X X X X X X
LAST (window) X X X X X X X X X X X
LEAST X X X X X X X X X X X X
LEFT X X X X X X X X X X X X
LEN (array) X X X X X X X
LEN X X X X X X X X X X X X
LIKE X X X X X X X X X X X X
LN X X X X X X X X X X X X
LOG X X X X X X X X X X X X
LOG10 X X X X X X X X X X X X
LOWER X X X X X X X X X X X X
LTRIM X X X X X X X X X X X
MARKUP X X X X X X X X X X X X
MAVG (window) X X X X X X X X X X X
MAX X X X X X X X X X X X X
MAX (window) X X X X X X X X X X X
MCOUNT (window) X X X X X X X X X X X
MEDIAN X X X X X X X X
MIN X X X X X X X X X X X X
MIN (window) X X X X X X X X X X X
MINUTE X X X X X X X X X X X X
MMAX (window) X X X X X X X X X X X
MMIN (window) X X X X X X X X X X X
MONTH X X X X X X X X X X X X
MSUM (window) X X X X X X X X X X X
NOT X X X X X X X X X X X X X
NOW X X X X X X X X X X X X
OR X X X X X X X X X X X X X
PI X X X X X X X X X X X X
POWER X X X X X X X X X X X X
QUANTILE X X X X X X X X
QUANTILE_APPROX X X X X X
QUARTER X X X X X X X X X X X X
RADIANS X X X X X X X X X X X X
RANK (window) X X X X X X X X X X X
RANK_DENSE (window) X X X X X X X X X X X
RANK_PERCENTILE (window) X X X X X X X X X X X
RANK_UNIQUE (window) X X X X X X X X X X X
RAVG (window) X X X X X X X X X X X
RCOUNT (window) X X X X X X X X X X X
REGEXP_EXTRACT X X X X X X X X X
REGEXP_EXTRACT_ALL X X X X X X X
REGEXP_EXTRACT_NTH X X X X X X X X X
REGEXP_MATCH X X X X X X X X X X
REGEXP_REPLACE X X X X X X X X X
REPLACE (array) X X X X X X X
REPLACE (string) X X X X X X X X X X X X
RIGHT X X X X X X X X X X X X
RMAX (window) X X X X X X X X X X X
RMIN (window) X X X X X X X X X X X
ROUND X X X X X X X X X X X X
RSUM (window) X X X X X X X X X X X
RTRIM X X X X X X X X X X X
SECOND X X X X X X X X X X X X
SIGN X X X X X X X X X X X X
SIN X X X X X X X X X X X X
SIZE X X X X X X X X X X X X
SLICE X X X X X X X
SPACE X X X X X X X X X X X X
SPLIT X X X X X X X X X X
SQRT X X X X X X X X X X X X
SQUARE X X X X X X X X X X X X
STARTSWITH (array) X X X X X X X
STARTSWITH (string) X X X X X X X X X X X X X
STDEV X X X X X X X X X X X X
STDEVP X X X X X X X X X X X X
STR X X X X X X X X X X X X
SUBSTR X X X X X X X X X X X X
SUM X X X X X X X X X X X X
SUM (window) X X X X X X X X X X X
SUM_IF X X X X X X X X X X X X
SUM_IF (window) X X X X X X X X X X X
TAN X X X X X X X X X X X X
TODAY X X X X X X X X X X X X
TOOLTIP X X X X X X X X X X X X
TOP_CONCAT X X X X X X
TREE X X X X X X X
TRIM X X X X X X X X X X X
UNNEST X X X X X X X
UPPER X X X X X X X X X X X X
URL X X X X X X X X X X X X
USER_INFO
UTF8 X X X X X
VAR X X X X X X X X X X X X
VARP X X X X X X X X X X X X
WEEK X X X X X X X X X X X X
YEAR X X X X X X X X X X X X
ZN X X X X X X X X X X X X

Was the article helpful?

Previous
SUM_IF
Next
Aggregation functions
Yandex project
© 2025 Yandex.Cloud LLC