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
Tag: aws
Downloading multiple files from aws s3
As this time, the option to download multiple files from aws s3 console is not available. The way to do … More
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 