Redshift

Useful

• super
• like
• copy
• json_parse
  • listagg()
  • || - interpolation
• SVV_DISKUSAGE
  • This table tells you which tables are using what storage

List all tables in a schema whose name contains a string

E.g., for schema public, get all the tables with daily in their name:

select t.table_name  
from information_schema.tables t  
where t.table_schema = 'public'  
  and t.table_type = 'BASE TABLE'  
  and t.table_name like '%daily%'  
order by t.table_name;