I am trying to clean up my small database and trying to see when the last time some of the tables were actually queried but cannot seem to find any documentation on how to do this. I can get the listing of all of the tables in my schema and the sizes, but cannot identify what might be stale before polling my users.
Does anyone know of a way to get the last date that a table was used/queried in redshift?
select
schema,
"table",
size as GB
from svv_table_info
where schema = 'measure' or schema = 'mphd' or schema = 'offer'
order by schema asc;