This SAS Explore presentation delved into SAS Information Catalog REST APIs. It showcased how utilizing these REST APIs, accessible from SAS, Python or shell scripts, can unlock the potential of programmatically discovering data. Participants discovered how SAS Information Catalog REST APIs enable searching and identification of files, tables and other assets based on specific criteria. The session provided hands-on demonstrations illustrating how programmers and data engineers can leverage these APIs to incorporate files and tables into data management tasks, as well as trigger actions or automate workflows. These REST APIs can gather insightful metadata and provide a comprehensive view of your data landscape. Users can navigate and explore their data ecosystem effectively, providing a high-level overview of assets and enabling informed decision making. Attendees gained insight into the SAS Information Catalog REST APIs and witnessed several demonstrations. Attendees learned about this powerful method to unlock the true potential of the SAS Information Catalog.
Presentation slides are attached to this post. See the attachment at the very top, under the title.
Watch the recorded presentation, including four short demonstrations:
No matter how comprehensive the interfaces in an information catalog might be, there will always be a need for custom reporting or custom workflows based on extremely specific asset characteristics.
A SAS Information Catalog allows you to discover, to search and to manage your SAS Viya assets.
Let's look at a few use cases and at the corresponding catalog API endpoints:
Imagine you have the following requirements:
How would you go about and fulfill those requirements? Well, you can write a program invoking the catalog search REST API.
Play the video above, around 05'50'', to see an example where we call the Catalog Search REST API from SAS Studio, using SAS code.
Imagine now that you have a different set of requirements you have to use for your reporting. In your marketing reporting, you are using a certain set of tables. But there are some conditions:
You can fulfill those requirements by writing a program which is invoking the Catalog Instances REST API.
Play the video above, around 10'22'', to see an example where we call the Catalog Instances API from Visual Studio Code. The example uses Python code.
Let's say that we have a caslib or a SAS library that we would like to discover. You can use the /catalog/bots endpoint to:
Play the video above, around 13'11'', where we call the Catalog Bots API from Postman.
The Catalog REST APIs will be public during the fall of 2023, and I can only hope that this session will encourage you to try the Catalog REST API, to explore your assets using SAS Information Catalog and to talk about the product in your organization.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.