Way to insert multiple rows into a redshift table using sql insert command: See: https://docs.aws.amazon.com/redshift/latest/dg/c_best-practices-multi-row-inserts.html
Category: sql
redshift date functions
select getdate(); getdate 2020-05-27 06:44:07 — select getdate() as today, date(dateadd(‘year’,-1,(last_day(dateadd(‘month’,-1,getdate()))))):: DATE as date1, date(last_day(dateadd(‘month’,-1,getdate())))::DATE as date2; today date 1 … More
DataUntangle 