Select Language:
If you want to find out when tables were last updated in Redshift Serverless, you can easily do this with the SHOW TABLES command. This command not only lists all the tables in a specific schema but also provides important details about each one, including when they were last modified or altered.
After running the SHOW TABLES command, you’ll see a list that includes the database name, schema name, table name, table type, and timestamps showing the last time each table was changed. For more detailed information, you can also look into the SVV_ALL_TABLES system view, which offers deeper insights into table attributes.
Keep in mind that there might be a slight delay—around 20 minutes—between when a change happens and when it’s reflected in these timestamps. So, if you make an update and immediately check, the recorded time might not yet show the most recent modification.
Sources for further reference include the official Amazon Redshift documentation on the SHOW TABLES command.
ChatGPT
Perplexity
Gemini AI
Grok AI
