catalog_search
Search the SAS Information Catalog to find assets across the Viya environment. Retrieve metadata such as library, row count, and column count for tables, columns, and reports.
Instructions
Search the SAS Information Catalog for assets (tables, columns, reports, ...).
The catalog is a metadata index across the whole Viya environment, so this
finds assets without needing to know their server/library first. Each hit
includes the asset's resource_uri — the URI you can hand to the matching
tool (e.g. get_report, get_castable_data) to act on the live asset — and an
attributes map with whatever metadata the catalog holds for it (commonly
library, rowCount, columnCount, completenessPercent,
reviewStatus, informationPrivacy, and analysisTimeStamp).
The query uses the SAS catalog search grammar:
Free text matches names, with wildcards
*(0+ chars) and?(1 char):cust*.Facets constrain fields, e.g.
AssetType:Report,Name:sales,Library.name:PUBLIC,Column.informationPrivacy:Sensitive.Ranges
DateModified:[2024-01-01 TO 2024-12-31]and+to require a term. Combine freely:AssetType:"CAS Table" +Name:cust*. Usecatalog_search_helperto discover valid facet names and values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum hits to return (default 20). | |
| query | Yes | The catalog search query (see grammar above). Use ``*`` to match all names. | |
| start | No | Offset of the first hit (default 0). | |
| indices | No | Comma-separated index name(s) to search (default 'catalog'). | catalog |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||