Category: Redshift

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

To determine the size of a database in Redshift cluster, use the below query. SELECT database, SUM(size) as “size in

Use the below query to determine the size of all schemas in Redshift database. SELECT schema, SUM(size) as “size in

SVV_TABLE_INFO view shows information of all user-defined tables.Use the below query to determine the size of a table in Redshift

Run the below query to identify the query that needs to be cancelled and copy the ‘pid’. select pid, user_name,

Use the below command to drop a materialized view where mv_name is the name of the materialized view. DROP MATERIALIZED

Copy using iam role: copy schemaname.tablename from ‘s3://bucketname/filename’ iam_role ‘arn of iam role’ DELIMITER ‘|’ ESCAPE; Copy using credentials: copy

Below is the syntax to insert a row into redshift table using sql statement. The list of values should be

Run the below command to perform full vacuum of a table to 95%.