Extracting SAS Library Usage Information

[elena_ziemke_capblurcross_com]

Hellow everyone! We have a question about predefined SAS Library usage data. 

Here is some background.  We are starting to use new data source – Snowflake.  I set up two predefined libraries in EG that use Snowflake. 

We need to be able to track SAS users and number of jobs that utilize these libraries.  Or at least just usage of these libraries.  But ideally as much information as possible around library usage.  User name who access it, type of queries, tables that are being used, etc.  Whatever information is available.   I already contacted SAS technical support on this but they couldn't provide any helpful information.

If anyone has any suggestions on how to get this usage information, please let me know.  Thank you!

[Nigel_Pain]

Hi Elena

You haven't said what version you are using. If it is SAS 9.4 and you have the Service Architecture enabled in Environment Manager to collect ARM data then you should have the information that you require in the library "SASEV - ARTIFACT" (libref "ARTIFACT"). And the Environment Manager Report Centre has predefined reports which use this and could give you most of what you want. There's documentation here:

https://documentation.sas.com/doc/en/evcdc/2.5_M1/evug/p0md48tpfq4yy7n1xxqn0re5v30l.htm 

[AhmedAl_Attar]

Hi Elena,

If you couldn't get the required utilization information from your SAS system/deployment, you can find most of these information in SnowFlake 🙂

SnowFlake provide Access_History view that you query to get the information you are looking for.

https://docs.snowflake.com/en/user-guide/access-history#querying-the-access-history-view

Here is an article that will help you with drawing a Column & Table Lineage diagram out of your queries

https://medium.com/snowflake/how-to-visualize-the-data-lineage-graph-in-snowflake-f0a356046380

Depending on the version of SnowFlake your organization is using, SnowFlake in their most recent/scheduled release, will include Cost Optimization

- https://www.youtube.com/watch?v=ETrd6VFY3JY

- https://www.youtube.com/watch?v=up3bTjrBvTA&list=PLavJpcg8cl1Epd5ziAjdpvkO9NyzVgsy-

You may want to look at how to optimize your Snowflake queries too in order to reduce your Total Cost of Operation

- https://www.youtube.com/watch?v=eRQf4RvjPWM

Hope this helps,

Ahmed