Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
The Schema Browser functions as a navigational aid for database administration and query editing. It also assists in organizing SSH Servers (see the SSH Browser for more information on expanding and collapsing SSH Servers in the tree). Server Groups, servers, and connections can be renamed and dragged and dropped to organize them. Context sensitive menus are accessible inside the Schema Browser through right-clicking on schema objects or keyboard shortcut (ALT + DOWN ARROW) once an object is selected. The Schema Browser can be docked or undocked as an individual panel as part of the Workspace and Docking Framework of Aqua Data Studio. A tree is used to display database server objects, allowing for rapid location of schema objects. When an object is selected in the Schema Browser, the Detail View displays contents or status. Icons for database servers change to indicate whether server connections are connected (green triangle), disconnected (orange vertical bars) or failed (red block) in the Schema Browser. The icons for server type also vary based on if they are Production (gold gear), Development (gray nodes) or Test (blue bug) servers.
To quickly find an object in the Schema Browser, bring the Schema Browser into focus, then begin typing. The folder or file with the associated name will select as you type. To search for wildcards, begin by typing *. For a more advanced search, use the Object Search feature. The Explore right-click context menu item, when used on a server group or scripts container in the Schema Browser, launches the operating system's navigation directly to the selected item.
Below is an explanation of the various elements of the Schema Browser in the screenshot.
When a scripts directory has been set within a server registration, its contents indicate association with a Source Control or Version Control repository with file status icon overlays: up to date (green circle with a checkmark), out of date (red exclamation point), conflicted (gold triangle with exclamation point), or unversioned (no overlay).
For more on how Aqua Data Studio saves connections settings and how to share them, see Configuration & Connection Files.
External Databases: An external database is stored in the Amazon Redshift Spectrum and is created when creating an external schema.
External Schemas: An Amazon Redshift external schema references an external database in an external data catalog.
External Tables: Amazon Redshift Spectrum uses external tables to query data stored in Amazon S3.
An external schema is created using the current database connection owner. External schemas and tables will not display in the schema tree if the database connection changes. The schema tree displays only what was created with the current connection. You can hover over External Schemas and/or External Tables so see which database you are connected to.
Both External Schemas and External Tables have the Create, Drop, Properties and Script Objects options when you right-click on them.
Additionally, External Tables have the option to Alter them, where you can visually edit the tables.