Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
827
|
Once one or more Data Sources are connected you can view their properties, rename them or close them.
Data Source Properties
In the Data Pane you can right click on it and select [Properties] to view its details.
Data Source Properties will display the following:
If you've executed a cross database query within the Query Analyzer, and used that Query Result to launch Visual Analytics, the Data Source properties will only display the Database of the Query Analyzer's Database dropdown from within the Query Analyzer toolbar. You can view the [Data Source Property's] Query to determine what databases were used in the query itself.
Renaming a Data Source
Once a Data Source has been added to the Data Pane you can rename it by:
Renaming a Data Source only changes its name in the Data Pane, it does not alter the underlying connection. It's easy to verify this by viewing [Data Source properties] and looking at the Connection value.
Editing a Data Source's Query
The process of Refreshing a Data Source does not update the query used to refresh data. To edit the query used in a Data Source, right click on the data source and select [Edit Query...]
A dialog appears that allows you to edit the query.
Click [Preview Results] to see the data this query will generate.
Once you see the data you need, click [Save] so that this query is used any time your view is Refreshed.
A Max Results of -1 (or leaving this field blank), means there will be no limit to the number of rows returned by the query. Be aware that not placing a limit on Max Results for extremely large tables of several hundred thousand rows may slow down the speed with which Visual Analytics refreshes or displays your view.
Closing a Data Source
To remove a Data Source and clear all of its fields from all decks, right click and select [Close].
You will receive a dialog explaining that all open worksheets using the Data Source will be cleared. Click [Yes] to continue.
If you [Close] a Data Source using an Extract, only the Data Source is removed while the Extract itself is not deleted.
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017