Redshift snippets

snippets.sql

----# LOAD / UNLOAD DATA #----

-- UNLOAD using IAM session
UNLOAD ('SELECT * FROM your_table where tstamp between ''2017-02-01 12:00'' and ''2017-02-02 13:00'' ') 
TO 's3://your_bucket/dump/' 
CREDENTIALS 'aws_access_key_id=XXXXXXX;aws_secret_access_key=XXXXXX;token=XXXXXXX'
MANIFEST 
ESCAPE;

----# MAINTENANCE #----

-- Check internal execution state of query
SELECT * FROM STV_EXEC_STATE WHERE query = 123456 ORDER BY slice,segment,step;

-- Check locks #1
SELECT table_id, last_update, lock_owner, lock_owner_pid, lock_status FROM stv_locks;

-- Check locks #2
SELECT * from pg_locks;

-- Check for lock conflicts
select * from STL_TR_CONFLICT where table_id=123;