Step 1 – Connect to your ec2 instance ( follow below article ) https://learnsqlteam.com/2018/11/30/how-to-connect-aws-ec2-instance-through-terminal/ step 2 – go to /etc – ( cd /etc ) step 3 – edit crontab ( nano crontab ) step 4 – define schedule and command e.g. in this example I am sysning file b/w ec2 instance and s3 bucket… Read More How to enable cron schedule in AWS EC2 instance
Step 1 – Ensure your EC2 instance is running Step 2 – Get EC2 instance name or public ip . Step 3 – Locate your Key Pair ( you must need keypair to connect to AWS services programmatically ) Step 4 – grant sufficient access chmod 400 myKeypair.pem Step 4 – ssh to your ec2… Read More How to connect AWS EC2 instance through terminal
input [a,b,c,d] [b,c] [f,g,h] output a b c d b c f g h with NS AS ( select 1 as n union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9… Read More Redshift – How to flatten JSON data in redshift
Learn Sql Team 