Below is the syntax to insert a row into redshift table using sql statement. The list of values should be
Continue reading
Category: How-To Guides
Delete an EBS Volume from AWS CLI
Use the below command to delete an EBS volume that is ‘available’ (i.e) not attached to any EC2 Instance. delete-volume
Continue reading
How to enable detailed monitoring on an EC2 Instance from AWS CLI
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 reading