sql syntax differences between Redshift and Snowflake

rs_to_sf.md

Redshift	Snowflake
select GETDATE()	select CURRENT_TIMESTAMP()
select TRUNC(CURRENT_TIMESTAMP())	select DATE_TRUNC(DAY,CURRENT_TIMESTAMP())
select SYSDATE	select TO_TIMESTAMP_NTZ(CONVERT_TIMEZONE('UTC',CURRENT_TIMESTAMP()))
select DATE(CURRENT_TIMESTAMP())	select TO_DATE(CURRENT_TIMESTAMP())
date_time_utc > GETDATE() - 7	date_time_utc > dateadd('DAY', -7, TO_TIMESTAMP_NTZ(LOCALTIMESTAMP))
select coalesce('a')	select coalesce('a', 'b') --you will get error message if you specify only one argument "SQL compilation error: error line 1 at position 7 not enough arguments for function [COALESCE('a')], expected 2, got 1"
DISTSTYLE	not used
DISTKEY	not used
SORTKEY	not used
SORTKEY(col)	not used
ENCODE	not used
interleaved	not used
bpchar	char
character varying	varchar
'now'::character varying	current_timestamp
identity(start, 0, ([0-9],[0-9])::text)	identity(start, 1)