why the script i save disappear in my account

0

i am in query editor, and found my 6 query files were gone, how to recover the query i saved in my account ?

Jason
preguntada hace 2 meses407 visualizaciones
1 Respuesta
1

I understand that you are not able to see the query saved in your Athena Query Editor.

Normally, to save a query from the Athena console:

  • Click on the vertical three dot menu on the "Query" tab.
  • Click on save as.
  • Choose a name for your query.
  • Choose a query description ( Optional ).

You can view the saved Queries in 'Saved queries' tab as well. [+] https://docs.aws.amazon.com/athena/latest/ug/saved-queries.html

When you meant saved queries have disappeared, please check if you have selected the right region.

Please note that the queries you ran previously can be found under the 'Recent queries' tab on the UI, kindly check and see if you find your queries there. [+] https://docs.aws.amazon.com/athena/latest/ug/querying.html. Also, Please refer 'Keeping query history longer than 45 days'

Note: In case if you want to retrieve the past queryid, navigate to cloudTrail -> Event History -> Key: Event Name and Value: StartQueryExecution, to find the previous queryExecutionId. Athena console stored the query editor tabs in the browser local storage. Only the queries under Saved queries menu are stored by Athena service. Due to these, we cannot provide the queries you previously used in your browser’s query editor tabs.

I hope this answers your query.

AWS
INGENIERO DE SOPORTE
respondido hace 2 meses
profile picture
EXPERTO
revisado hace 2 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas