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
... View more