AWS Athena Query Error


Hello, I am receiving an error when trying to run a report. It says:

"SYNTAX_ERROR: line 28:6: View 'awsdatacatalog.wfs_accs_yeti_prod_02.recent_connect_ctr' is stale; it must be re-created"

Does anyone know what this means?

Thank you!

asked a year ago478 views
1 Answer

Athena by default reports a stale view under one of or more of the following conditions:

  1. The table or database that's specified in the view query doesn't exist.
  2. You tried to modify the table definition after you create the view.
  3. You tried to update the schema or metadata in a referenced table while recreating or updating the table.

For example, your query fails with this error if you create a view and then run an ALTER TABLE ADD COLUMNS statement on the same table.

To prevent "stale view" errors, recreate the view whenever you modify the underlying table or databases. You can also replace the view by adding the OR REPLACE clause in the CREATE VIEW statement. This clause lets you update the existing view by replacing it.

Felix G
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions