Function Emulations¶

To make SnowShu replicas behave as much like their source counterparts as possible, functions are applied to emulate them. Each source-to-target relationship has a unique set of emulations, cataloged here.

Snowflake DSL Emulation¶

Snowflake DSL Emulation¶
Snowflake Function	Postgresql Function	Replica Emulation	Notes
:	not supported	not supported
::	not supported	not supported
ABS	ABS	not supported
ACOS	ACOS	not supported
ACOSH	ACOSH	not supported
ADD_MONTHS	not supported	not supported
ALTER PIPE	not supported	not supported
ANY_VALUE	not supported	ANY_VALUE	Emulates as GREATEST (ie MAX value)
APPROXIMATE_JACCARD_INDEX	not supported	not supported
APPROXIMATE_SIMILARITY	not supported	not supported
APPROX_COUNT_DISTINCT	not supported	not supported
APPROX_PERCENTILE	not supported	not supported
APPROX_PERCENTILE_ACCUMULATE	not supported	not supported
APPROX_PERCENTILE_COMBINE	not supported	not supported
APPROX_PERCENTILE_ESTIMATE	not supported	not supported
APPROX_TOP_K	not supported	not supported
APPROX_TOP_K_ACCUMULATE	not supported	not supported
APPROX_TOP_K_COMBINE	not supported	not supported
APPROX_TOP_K_ESTIMATE	not supported	not supported
ARRAYS_OVERLAP	not supported	not supported
ARRAY_AGG	ARRAY_AGG	not supported
ARRAY_APPEND	ARRAY_APPEND	not supported
ARRAY_CAT	ARRAY_CAT	not supported
ARRAY_COMPACT	not supported	not supported
ARRAY_CONSTRUCT	not supported	not supported
ARRAY_CONSTRUCT_COMPACT	not supported	not supported
ARRAY_CONTAINS	not supported	not supported
ARRAY_INSERT	not supported	not supported
ARRAY_INTERSECTION	not supported	not supported
ARRAY_POSITION	ARRAY_POSITION	not supported
ARRAY_PREPEND	ARRAY_PREPEND	not supported
ARRAY_SIZE	not supported	not supported
ARRAY_SLICE	not supported	not supported
ARRAY_TO_STRING	ARRAY_TO_STRING	not supported
ASCII	ASCII	not supported
ASIN	ASIN	not supported
ASINH	ASINH	not supported
AS_<OBJECT_TYPE>	not supported	not supported
AS_ARRAY	not supported	not supported
AS_BINARY	not supported	not supported
AS_BOOLEAN	not supported	not supported
AS_CHAR	not supported	not supported
AS_DATE	not supported	not supported
AS_DECIMAL	not supported	not supported
AS_DOUBLE	not supported	not supported
AS_INTEGER	not supported	not supported
AS_NUMBER	not supported	not supported
AS_OBJECT	not supported	not supported
AS_REAL	not supported	not supported
AS_TIME	not supported	not supported
AS_TIMESTAMP_*	not supported	not supported
AS_VARCHAR	not supported	not supported
ATAN	ATAN	not supported
ATAN2	ATAN2	not supported
ATANH	ATANH	not supported
AUTOMATIC CLUSTERING	not supported	not supported
AUTOMATIC_CLUSTERING_HISTORY	not supported	not supported
AVG	AVG	not supported
BASE64_DECODE_BINARY	not supported	not supported
BASE64_DECODE_STRING	not supported	not supported
BASE64_ENCODE	not supported	not supported
BETWEEN	BETWEEN	not supported
BITAND	not supported	not supported
BITAND_AGG	not supported	not supported
BITNOT	not supported	not supported
BITOR	not supported	not supported
BITOR_AGG	not supported	not supported
BITSHIFTLEFT	not supported	not supported
BITSHIFTRIGHT	not supported	not supported
BITXOR	not supported	not supported
BITXOR_AGG	not supported	not supported
BIT_LENGTH	BIT_LENGTH	not supported
BOOLAND	not supported	not supported
BOOLAND_AGG	not supported	not supported
BOOLNOT	not supported	not supported
BOOLOR	not supported	not supported
BOOLOR_AGG	not supported	not supported
BOOLXOR	not supported	not supported
BOOLXOR_AGG	not supported	not supported
CASE	not supported	not supported
CAST	not supported	not supported
CBRT	CBRT	not supported
CEIL	CEIL	not supported
CHAR	not supported	not supported
CHARINDEX	not supported	not supported
CHECK_JSON	not supported	not supported
CHECK_XML	not supported	not supported
CHR	CHR	not supported
COALESCE	not supported	not supported
COLLATE	not supported	not supported
COLLATION	not supported	not supported
COMPRESS	not supported	not supported
CONCAT	CONCAT	not supported
CONDITIONAL_CHANGE_EVENT	not supported	not supported
CONDITIONAL_TRUE_EVENT	not supported	not supported
CONTAINS	not supported	not supported
CONVERT_TIMEZONE	not supported	not supported
COPY INTO <TABLE>	not supported	not supported
COPY_HISTORY	not supported	not supported
CORR	CORR	not supported
COS	COS	not supported
COSH	COSH	not supported
COT	COT	not supported
COUNT	COUNT	not supported
COVAR_POP	COVAR_POP	not supported
COVAR_SAMP	COVAR_SAMP	not supported
CUME_DIST	CUME_DIST	not supported
CURRENT_ACCOUNT	not supported	not supported
CURRENT_CLIENT	not supported	not supported
CURRENT_DATABASE	CURRENT_DATABASE	not supported
CURRENT_DATE	CURRENT_DATE	not supported
CURRENT_REGION	not supported	not supported
CURRENT_ROLE	CURRENT_ROLE	not supported
CURRENT_SCHEMA	CURRENT_SCHEMA	not supported
CURRENT_SCHEMAS	CURRENT_SCHEMAS	not supported
CURRENT_SESSION	not supported	not supported
CURRENT_STATEMENT	not supported	not supported
CURRENT_TIME	CURRENT_TIME	not supported
CURRENT_TIMESTAMP	CURRENT_TIMESTAMP	not supported
CURRENT_TRANSACTION	not supported	not supported
CURRENT_USER	CURRENT_USER	not supported
CURRENT_VERSION	not supported	not supported
CURRENT_WAREHOUSE	not supported	not supported
DATABASE_REFRESH_HISTORY	not supported	not supported
DATABASE_REFRESH_PROGRESS	not supported	not supported
DATABASE_REFRESH_PROGRESS_BY_JOB	not supported	not supported
DATABASE_STORAGE_USAGE_HISTORY	not supported	not supported
DATA_TRANSFER_HISTORY	not supported	not supported
DATEADD	not supported	not supported
DATEDIFF	not supported	not supported
DATE_FROM_PARTS	not supported	not supported
DATE_PART	DATE_PART	not supported
DATE_TRUNC	DATE_TRUNC	not supported
DAYNAME	not supported	not supported
DECODE	DECODE	not supported
DECOMPRESS_BINARY	not supported	not supported
DECOMPRESS_STRING	not supported	not supported
DEGREES	DEGREES	not supported
DENSE_RANK	DENSE_RANK	not supported
EDITDISTANCE	not supported	not supported
ENDSWITH	not supported	not supported
EQUAL_NULL	not supported	not supported
EXP	EXP	not supported
EXPLAIN_JSON	not supported	not supported
EXTERNAL TABLE	not supported	not supported
EXTERNAL_TABLE_FILES	not supported	not supported
EXTERNAL_TABLE_FILE_REGISTRATION_HISTORY	not supported	not supported
EXTRACT	EXTRACT	not supported
FACTORIAL	not supported	not supported
FIRST_VALUE	FIRST_VALUE	not supported
FLATTEN	not supported	not supported
FLOOR	FLOOR	not supported
GENERATOR	not supported	not supported
GET	not supported	not supported
GET_DDL	not supported	not supported
GET_IGNORE_CASE	not supported	not supported
GET_OBJECT_REFERENCES	not supported	not supported
GET_PATH	not supported	not supported
GREATEST	not supported	not supported
GROUP BY	not supported	not supported
GROUPING	GROUPING	not supported
GROUPING_ID	not supported	not supported
HASH	not supported	not supported
HASH_AGG	not supported	not supported
HAVERSINE	not supported	not supported
HEX_DECODE_BINARY	not supported	not supported
HEX_DECODE_STRING	not supported	not supported
HEX_ENCODE	not supported	not supported
HLL	not supported	not supported
HLL_ACCUMULATE	not supported	not supported
HLL_COMBINE	not supported	not supported
HLL_ESTIMATE	not supported	not supported
HLL_EXPORT	not supported	not supported
HLL_IMPORT	not supported	not supported
HOUR / MINUTE / SECOND	not supported	not supported
IFF	not supported	not supported
IFNULL	not supported	not supported
ILIKE	not supported	not supported
ILIKE ANY	not supported	not supported
IN	not supported	not supported
INITCAP	INITCAP	not supported
INSERT	INSERT	not supported
IS DISTINCT FROM	not supported	not supported
IS NULL	not supported	not supported
IS_<OBJECT_TYPE>	not supported	not supported
IS_ARRAY	not supported	not supported
IS_BINARY	not supported	not supported
IS_BOOLEAN	not supported	not supported
IS_CHAR	not supported	not supported
IS_DATE	not supported	not supported
IS_DATE_VALUE	not supported	not supported
IS_DECIMAL	not supported	not supported
IS_DOUBLE	not supported	not supported
IS_INTEGER	not supported	not supported
IS_NULL_VALUE	not supported	not supported
IS_OBJECT	not supported	not supported
IS_REAL	not supported	not supported
IS_TIME	not supported	not supported
IS_TIMESTAMP_*	not supported	not supported
IS_VARCHAR	not supported	not supported
KURTOSIS	not supported	not supported
LAG	LAG	not supported
LAST_DAY	not supported	not supported
LAST_QUERY_ID	not supported	not supported
LAST_TRANSACTION	not supported	not supported
LAST_VALUE	LAST_VALUE	not supported
LEAD	LEAD	not supported
LEAST	not supported	not supported
LEFT	LEFT	not supported
LENGTH	LENGTH	not supported
LIKE	not supported	not supported
LIKE ALL	not supported	not supported
LIKE ANY	not supported	not supported
LISTAGG	not supported	not supported
LN	LN	not supported
LOCALTIME	LOCALTIME	not supported
LOCALTIMESTAMP	LOCALTIMESTAMP	not supported
LOG	LOG	not supported
LOGIN_HISTORY	not supported	not supported
LOGIN_HISTORY_BY_USER	not supported	not supported
LOWER	LOWER	not supported
LPAD	LPAD	not supported
LTRIM	LTRIM	not supported
MATERIALIZED VIEWS	not supported	not supported
MATERIALIZED_VIEW_REFRESH_HISTORY	not supported	not supported
MD5	MD5	not supported
MD5_BINARY	not supported	not supported
MD5_HEX	not supported	not supported
MD5_NUMBER Â DEPRECATED	not supported	not supported
MEDIAN	not supported	not supported
MIN / MAX	not supported	not supported
MINHASH	not supported	not supported
MINHASH_COMBINE	not supported	not supported
MOD	MOD	not supported
MODE	MODE	not supported
MONTHNAME	not supported	not supported
NEXT_DAY	not supported	not supported
NORMAL	not supported	not supported
NTH_VALUE	NTH_VALUE	not supported
NTILE	NTILE	not supported
NULLIF	not supported	not supported
NVL	not supported	not supported
NVL2	not supported	not supported
OBJECT_AGG	not supported	not supported
OBJECT_CONSTRUCT	not supported	not supported
OBJECT_DELETE	not supported	not supported
OBJECT_INSERT	not supported	not supported
OCTET_LENGTH	OCTET_LENGTH	not supported
PARSE_IP	not supported	not supported
PARSE_JSON	not supported	not supported
PARSE_URL	not supported	not supported
PARSE_XML	not supported	not supported
PERCENTILE_CONT	PERCENTILE_CONT	not supported
PERCENTILE_DISC	PERCENTILE_DISC	not supported
PERCENT_RANK	PERCENT_RANK	not supported
PI	PI	not supported
PIPE_USAGE_HISTORY	not supported	not supported
POSITION	POSITION	not supported
POW	not supported	not supported
POWER	POWER	not supported
PREVIOUS_DAY	not supported	not supported
QUERY_HISTORY	not supported	not supported
QUERY_HISTORY_BY_*	not supported	not supported
RADIANS	RADIANS	not supported
RANDOM	RANDOM	not supported
RANDSTR	not supported	not supported
RANK	RANK	not supported
RATIO_TO_REPORT	not supported	not supported
REGEXP	not supported	not supported
REGEXP_COUNT	not supported	not supported
REGEXP_INSTR	not supported	not supported
REGEXP_LIKE	not supported	not supported
REGEXP_REPLACE	REGEXP_REPLACE	not supported
REGEXP_SUBSTR	not supported	not supported
REGR_AVGX	REGR_AVGX	not supported
REGR_AVGY	REGR_AVGY	not supported
REGR_COUNT	REGR_COUNT	not supported
REGR_INTERCEPT	REGR_INTERCEPT	not supported
REGR_R2	REGR_R2	not supported
REGR_SLOPE	REGR_SLOPE	not supported
REGR_SXX	REGR_SXX	not supported
REGR_SXY	REGR_SXY	not supported
REGR_SYY	REGR_SYY	not supported
REGR_VALX	not supported	not supported
REGR_VALY	not supported	not supported
REPEAT	REPEAT	not supported
REPLACE	REPLACE	not supported
REPLICATION_USAGE_HISTORY	not supported	not supported
RESULT_SCAN	not supported	not supported
REVERSE	REVERSE	not supported
RIGHT	RIGHT	not supported
RLIKE	not supported	RLIKE	supports only 1st syntax ie RLIKE(subject,pattern,args). Only supports the ‘i’ (case insensitive) flag at this time.
ROUND	ROUND	not supported
ROW_NUMBER	ROW_NUMBER	not supported
RPAD	RPAD	not supported
RTRIM	RTRIM	not supported
RTRIMMED_LENGTH	not supported	not supported
SEQ1 / SEQ2 / SEQ4 / SEQ8	not supported	not supported
SHA1	not supported	not supported
SHA1_BINARY	not supported	not supported
SHA1_HEX	not supported	not supported
SHA2	not supported	not supported
SHA2_BINARY	not supported	not supported
SHA2_HEX	not supported	not supported
SIGN	SIGN	not supported
SIN	SIN	not supported
SINH	SINH	not supported
SKEW	not supported	not supported
SNOWPIPE	not supported	not supported
SOUNDEX	not supported	not supported
SPACE	not supported	not supported
SPLIT	not supported	not supported
SPLIT_PART	SPLIT_PART	not supported
SPLIT_TO_TABLE	not supported	not supported
SQRT	SQRT	not supported
SQUARE	not supported	not supported
STAGE_STORAGE_USAGE_HISTORY	not supported	not supported
STARTSWITH	not supported	not supported
STDDEV	STDDEV	not supported
STDDEV_POP	STDDEV_POP	not supported
STDDEV_SAMP	STDDEV_SAMP	not supported
STRIP_NULL_VALUE	not supported	not supported
STRTOK	not supported	not supported
STRTOK_SPLIT_TO_TABLE	not supported	not supported
STRTOK_TO_ARRAY	not supported	not supported
SUBSTR	SUBSTR	not supported
SUBSTRING	SUBSTRING	not supported
SUM	SUM	not supported
SYSTEM$ABORT_SESSION	not supported	not supported
SYSTEM$ABORT_TRANSACTION	not supported	not supported
SYSTEM$CANCEL_ALL_QUERIES	not supported	not supported
SYSTEM$CANCEL_QUERY	not supported	not supported
SYSTEM$CLUSTERING_DEPTH	not supported	not supported
SYSTEM$CLUSTERING_INFORMATION	not supported	not supported
SYSTEM$CLUSTERING_RATIO Â DEPRECATED	not supported	not supported
SYSTEM$CURRENT_USER_TASK_NAME	not supported	not supported
SYSTEM$DATABASE_REFRESH_HISTORY	not supported	not supported
SYSTEM$DATABASE_REFRESH_PROGRESS	not supported	not supported
SYSTEM$DATABASE_REFRESH_PROGRESS_BY_JOB	not supported	not supported
SYSTEM$EXPLAIN_JSON_TO_TEXT	not supported	not supported
SYSTEM$EXPLAIN_PLAN_JSON	not supported	not supported
SYSTEM$GET_AWS_SNS_IAM_POLICY	not supported	not supported
SYSTEM$GET_PREDECESSOR_RETURN_VALUE	not supported	not supported
SYSTEM$LAST_CHANGE_COMMIT_TIME	not supported	not supported
SYSTEM$PIPE_FORCE_RESUME	not supported	not supported
SYSTEM$PIPE_STATUS	not supported	not supported
SYSTEM$SET_RETURN_VALUE	not supported	not supported
SYSTEM$SHOW_OAUTH_CLIENT_SECRETS	not supported	not supported
SYSTEM$STREAM_GET_TABLE_TIMESTAMP	not supported	not supported
SYSTEM$STREAM_HAS_DATA	not supported	not supported
SYSTEM$TASK_DEPENDENTS_ENABLE	not supported	not supported
SYSTEM$TYPEOF	not supported	not supported
SYSTEM$USER_TASK_CANCEL_ONGOING_EXECUTIONS	not supported	not supported
SYSTEM$VERIFY_EXTERNAL_OAUTH_TOKEN	not supported	not supported
SYSTEM$WAIT	not supported	not supported
SYSTEM$WHITELIST	not supported	not supported
SYSTEM$WHITELIST_PRIVATELINK	not supported	not supported
TAN	TAN	not supported
TANH	TANH	not supported
TASK	not supported	not supported
TASKS	not supported	not supported
TASK_DEPENDENTS	not supported	not supported
TASK_HISTORY	not supported	not supported
TIMEADD	not supported	not supported
TIMEDIFF	not supported	not supported
TIMESTAMPADD	not supported	not supported
TIMESTAMPDIFF	not supported	not supported
TIMESTAMP_FROM_PARTS	not supported	not supported
TIME_FROM_PARTS	not supported	not supported
TIME_SLICE	not supported	not supported
TO_ARRAY	not supported	not supported
TO_BINARY	not supported	not supported
TO_BOOLEAN	not supported	not supported
TO_CHAR	TO_CHAR	not supported
TO_DATE	TO_DATE	not supported
TO_DECIMAL	not supported	not supported
TO_DOUBLE	not supported	not supported
TO_JSON	TO_JSON	not supported
TO_NUMBER	TO_NUMBER	not supported
TO_NUMERIC	not supported	not supported
TO_OBJECT	not supported	not supported
TO_TIME	not supported	not supported
TO_TIMESTAMP / TO_TIMESTAMP_*	not supported	not supported
TO_VARCHAR	not supported	not supported
TO_VARIANT	not supported	not supported
TO_XML	not supported	not supported
TRANSLATE	TRANSLATE	not supported
TRIM	TRIM	not supported
TRUNC	TRUNC	not supported
TRUNCATE	TRUNCATE	not supported
TRY_BASE64_DECODE_BINARY	not supported	not supported
TRY_BASE64_DECODE_STRING	not supported	not supported
TRY_CAST	not supported	not supported
TRY_HEX_DECODE_BINARY	not supported	not supported
TRY_HEX_DECODE_STRING	not supported	not supported
TRY_PARSE_JSON	not supported	not supported
TRY_TO_BINARY	not supported	not supported
TRY_TO_BOOLEAN	not supported	not supported
TRY_TO_DATE	not supported	not supported
TRY_TO_DECIMAL	not supported	not supported
TRY_TO_DOUBLE	not supported	not supported
TRY_TO_NUMBER	not supported	not supported
TRY_TO_NUMERIC	not supported	not supported
TRY_TO_TIME	not supported	not supported
TRY_TO_TIMESTAMP / TRY_TO_TIMESTAMP_*	not supported	not supported
TYPEOF	not supported	not supported
UNICODE	not supported	not supported
UNIFORM	not supported	not supported
UPPER	UPPER	not supported
UUID_STRING	not supported	not supported
VALIDATE	not supported	not supported
VALIDATE_PIPE_LOAD	not supported	not supported
VARIANCE	VARIANCE	not supported
VARIANCE_POP	not supported	not supported
VARIANCE_SAMP	not supported	not supported
VAR_POP	VAR_POP	not supported
VAR_SAMP	VAR_SAMP	not supported
WAREHOUSE_LOAD_HISTORY	not supported	not supported
WAREHOUSE_METERING_HISTORY	not supported	not supported
WIDTH_BUCKET	WIDTH_BUCKET	not supported
XMLGET	not supported	not supported
YEAR* / DAY* / WEEK* / MONTH / QUARTER	not supported	not supported
ZEROIFNULL	not supported	not supported
ZIPF	not supported	not supported
\|\|	\|\|	not supported