AWS bytes

How to change the connection limit of a Redshift database

Connection limit is the maximum number of concurrent connections that a user is allowed to have against a particular redshift

Use the below command to rename a schema in Redshift where current_schema_name is the current name of the schema and

Check the current quota and disk usage of the schema by running the below query where schemaname is the name

You can view the current owner of a schema by running the below query where schema_name is the name of

You have to be a super user to be able change the owner of a procedure. Below is the syntax

Below is the sql command to rename a stored procedure where proc_name is the name of the procedure and datatype1,

Login to the AWS Management Console and navigate to ‘Relational Database Service’ dashboard. Identify the RDS cluster that you would

Login to the AWS Management Console and navigate to ‘Relational Database Service’ dashboard. Identify the RDS instance that you would

You can determine if a particular EBS volume is encrypted or not from either AWS Management console or AWS CLI.

Step1: Create snapshot of unencrypted volume Step2: Create encrypted copy of the snapshot Step3: Create volume from the encrypted snapshot