Run the below command to enabled detailed monitoring on a running EC2 Instance aws ec2 monitor-instances –instance-ids INSTANCEID Disable detailed
Continue reading
How to enable enhanced networking on an EC2 Instance from AWS CLI
Step1: Stop the EC2 Instance: aws ec2 stop-instances –instance-ids INSTANCEID Step2: Set sriov-net-support to ‘simple’. aws ec2 modify-instance-attribute –instance-id INSTANCEID
Continue readingHow to modify “Delete on Termination” attribute of an EC2 Instance from AWS CLI
By default the ‘DeleteOnTermination’ attribute of an EBS backed EC2 Instance is ‘True’. Root volume can be preserved on termination
Continue reading
How to cancel a spot instance request from AWS CLI
Use the below command to cancel a spot instance request where REQUESTID is the request id of the spot instance.
Continue reading
How to list all running EC2 spot instances
You can use one of the below commands to list all running spot instances. aws ec2 describe-instances –filters “Name=instance-lifecycle,Values=spot” aws
Continue reading
How to vacuum a table in Redshift database
Run the below command to perform full vacuum of a table to 95%.
Continue reading
How to create and refresh a Materialized view in Redshift
Syntax to create materialized view: create materialized view mv_name as (select statement); Syntax to refresh materialized view: REFRESH MATERIALIZED VIEW
Continue reading
How to create a view in Redshift database
Syntax to create a view: create view viewname as (select statement );
Continue readingHow to drop a group in Redshift database
Below is the syntax to drop a group from the Redshift databases where groupname is the name of the group
Continue readingHow to rename a group in Redshift database
Below is the syntax to rename a group in Redshift database: ALTER GROUP groupname RENAME TO new_groupname;
Continue reading