Collection of useful Redshift queries.
- Redshift Spectrum queries - Provides information about Redshift Spectrum queries by users and cost of each query
- User permmissions for tables in a schema - User access for each table in schema.
- Get load errors - Returns error occurured as a result of
COPYcommand. - Tables' sizes - Returns sizes of tables in descending order.
- Long running queries - Returns longest queries for last day also with usernames.