Skip to content

Operation Support Matrix

Backends are shown in descending order of the number of supported operations.

The Snowflake backend coverage is an overestimate

The Snowflake backend translation functions are reused from the PostgreSQL backend and some operations that claim coverage may not work.

The Snowflake backend is a good place to start contributing!

Backends postgres mysql bigquery dask pandas duckdb clickhouse snowflake polars pyspark sqlite impala mssql datafusion
API Coverage 222 (82%) 204 (76%) 196 (73%) 193 (71%) 193 (71%) 183 (68%) 180 (67%) 180 (67%) 170 (63%) 161 (60%) 154 (57%) 151 (56%) 136 (50%) 58 (21%)
Abs
Acos
Add
Alias
AnalyticVectorizedUDF
And
Any
Arbitrary
ArgMax
ArgMin
ArrayCollect
ArrayColumn
ArrayConcat
ArrayIndex
ArrayLength
ArrayRepeat
ArraySlice
Asin
Atan2
Atan
BaseConvert
BetweenTime
BitAnd
BitOr
BitXor
BitwiseAnd
BitwiseLeftShift
BitwiseNot
BitwiseOr
BitwiseRightShift
BitwiseXor
Bucket
CMSMedian
Capitalize
Cast
CategoryLabel
Ceil
Clip
Coalesce
Correlation
Cos
Cot
CountDistinct
CountStar
Count
Covariance
CumeDist
CumulativeAll
CumulativeAny
CumulativeMax
CumulativeMean
CumulativeMin
CumulativeSum
DateAdd
DateDiff
DateFromYMD
DateSub
DateTruncate
Date
DayOfWeekIndex
DayOfWeekName
DecimalPrecision
DecimalScale
Degrees
DenseRank
E
ElementWiseVectorizedUDF
EndsWith
Equals
ExistsSubquery
Exp
ExtractDayOfYear
ExtractDay
ExtractEpochSeconds
ExtractHour
ExtractMillisecond
ExtractMinute
ExtractMonth
ExtractQuarter
ExtractSecond
ExtractWeekOfYear
ExtractYear
FindInSet
FirstValue
FloorDivide
Floor
GeoArea
GeoAsBinary
GeoAsEWKB
GeoAsEWKT
GeoAsText
GeoAzimuth
GeoBuffer
GeoCentroid
GeoContainsProperly
GeoContains
GeoCoveredBy
GeoCovers
GeoCrosses
GeoDFullyWithin
GeoDWithin
GeoDifference
GeoDisjoint
GeoDistance
GeoEndPoint
GeoEnvelope
GeoEquals
GeoGeometryN
GeoGeometryType
GeoIntersection
GeoIntersects
GeoIsValid
GeoLength
GeoLineLocatePoint
GeoLineMerge
GeoLineSubstring
GeoMaxDistance
GeoNPoints
GeoNRings
GeoOrderingEquals
GeoOverlaps
GeoPerimeter
GeoPointN
GeoPoint
GeoSRID
GeoSetSRID
GeoSimplify
GeoStartPoint
GeoTouches
GeoTransform
GeoUnaryUnion
GeoUnion
GeoWithin
GeoXMax
GeoXMin
GeoX
GeoYMax
GeoYMin
GeoY
GreaterEqual
Greater
Greatest
GroupConcat
HLLCardinality
HashBytes
Hash
IdenticalTo
IfNull
IntervalAdd
IntervalFloorDivide
IntervalFromInteger
IntervalMultiply
IntervalSubtract
IsInf
IsNan
IsNull
JSONGetItem
LPad
LStrip
Lag
LastValue
Lead
Least
LessEqual
Less
Ln
Log10
Log2
Log
Lowercase
MapContains
MapGet
MapKeys
MapLength
MapMerge
MapValues
Map
Max
Mean
MinRank
Min
Mode
Modulus
MultiQuantile
Multiply
NTile
Negate
NotAll
NotAny
NotContains
NotEquals
NotExistsSubquery
NotNull
Not
NthValue
NullIfZero
NullIf
NullLiteral
Or
ParseURL