I have a ticket_audit table that logs for each ticket_id logs the status of the ticket, and the duration of each status.
Each ticket_id could have up to three statuses, (waiting, respond, and validation).

I’m adding a new column to my Athena table, and I want to perform my new query on the new column only when it exists, otherwise use the currently implemented query on existing columns, in order to retain the logic in case the code were updated first and my other Athena tables were not updated with the new column.

I have table A
with 9 records

I have table A
with 9 records

I have table A
with 9 records

I have table A
with 9 records

I have table A
with 9 records

I have table A
with 9 records

I want to create an external table on AWS Athena.
My query is: