Browse and Search Catalogs
The Catalog Tool aims to allow you to find data quickly and easily, whether or not the data is currently resident in the connected Autonomous Database.
Using the Catalog tool, you can discover data in connected systems, preview it, and choose whether or not to load, link or feed the data into the local database.
You can view the search bar on the Catalog's home page. To enter a search term, click on the search field located at the top. You can filter the search entry by selecting a quick filter displayed below the search field.
You must first select the type of assets you want to search from the filter buttons at the top of the screen, then search for objects by name.
- Tables and Views
This filter searches only for the database tables (both internal and external tables) and views (this includes both standard database views and analytic views)
- Data Objects
This filter searches for data objects in the database and on connected cloud storage. This is a superset of the Tables and Views and Files scopes.
- Files
This filter searches only for files in connected cloud storage.
- OCI
This filter searches for other Oracle Cloud Infrastructure objects, such as other Autonomous Databases, buckets on OCI cloud storage, or a registered OCI Data Catalog. This field is available if you have an OCI credential. You can create an OCI credential from the Data Studio Settings icon.
- Connections
This filter searches for connections that are registered in Data Studio, such as connections to external Data Catalogs or databases.
- All
This filter searches for all objects in the catalog. Since there are many thousands of such objects, this scope may be slower to use.
For example, to find all tables, views or files that may contain data related to reviews, click Data Objects and search for reviews:
This displays all data objects that contain review data.
Parent topic: The Catalog Tool