catalog_search
Search SAS Information Catalog for tables, columns, reports, and other assets across your Viya environment using free text, facets, and ranges. Get resource URIs and metadata to act on live assets.
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 | |||