Is it possible to change the Name of a saved query?

[perceptron01]

You can open a saved query by selecting Edit query from the choices in the Actions column in the Saved queries page.
However, you cannot edit the Name of that saved query and can only create a new query with the same content as that query.

If there is no way to do this, this is inconvenient.
There will often be cases where you want to modify the name of an existing saved query.

Is it possible to change the Name of a saved query?

[perceptron01]

@dosu Any ideas?

[dosubot[bot]]

Could you provide more details about the steps you're taking in the Web UI to try and edit the name of the saved query? Additionally, are there any error messages or indications that appear when you attempt to make the change? This information might help in identifying the issue.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[perceptron01]

@dosu

1. Open Saved queries page: https://superset-hostname/savedqueryview/list/
2. Select Edit query in the items of Actions column.
3. Then SQL Lab opens, where I can find a Save button. But it shows options Cancel and SAVE. It does not show Update option.

are there any error messages or indications that appear when you attempt to make the change? This information might help in identifying the issue.

No. No error messages or indications appear.

[dosubot[bot]]

The 'Save' button in the SQL Lab should show an 'Update' option if the query already exists, which is determined by the presence of a remoteId in the unsavedQueryEditor state ^[1]. If you're not seeing the 'Update' option, it might be due to the remoteId not being set correctly when transitioning from the 'Saved queries' page to the SQL Lab.

Ensure that the query editor state is correctly maintaining the remoteId when you open a saved query for editing. If the remoteId is missing, the system will not recognize the query as an existing one, and thus, the 'Update' option will not appear. You might need to check the frontend code or the state management logic to ensure that the remoteId is being set properly when you navigate to the SQL Lab from the 'Saved queries' page.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}

[perceptron01]

@dosu Version of Superset I am using is 4.1.1 with it set up with docker image. Is there any problem in this version around remoteId?

[dosubot[bot]]

I couldn't find any specific known issues or bugs related to remoteId handling in Superset version 4.1.1. However, the remoteId is crucial for determining whether the 'Update' option should appear in the SQL Lab. It is set and maintained in the state management logic when navigating from the 'Saved queries' page to the SQL Lab by assigning it the value of activeTab.saved_query?.id or null if it doesn't exist ^[1][2]. If you're experiencing issues, it might be worth checking if the remoteId is being correctly set in your setup.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Bug Report | Other}