Modify any query using the Edit Query button:
-
On the Datasphere Queries page, use the Connection drop-down menu to select the connection you want to query from.
-
Select a query from the table and click the Edit button.
-
The Edit Query page opens. If the selected query was built using the Query Builder, your query preview displays in the Query Builder tab. If the query was built manually, your query preview displays in the Manual Query tab.
-
Make updates to your query as needed. When editing, keep in mind the following:
-
Queries created using the Query Builder can be updated using the Manual Query tab, but will then be saved as a manual query.
-
Queries created manually cannot be edited with the Query Builder. A new query will need to be created.
-
If a query was created using the Query Builder, then edited manually, the edits will not transfer to the Query Builder tab when toggling back.
-
-
When done, click the Save button to save your changes.
