There are a few ways to track when your shared data has been accessed on Snowflake.
Use the Snowflake audit log: The Snowflake audit log tracks all access to data in Snowflake, including data sharing. You can use the audit log to see who has accessed your shared data, when they accessed it, and what they did with it.
The Snowflake audit log is a table that stores records of all data access events. These events include data sharing, data loading, data querying, and data updates.
The audit log can be filtered by a number of criteria, such as user, object, and action. The audit log can also be exported to a file for further analysis.
Use the Snowflake Data Access Governance (DAG) tool: The DAG tool provides a more granular view of data access than the audit log. The DAG tool allows you to see who has access to specific data objects, and what permissions they have to those objects.
The DAG tool can be used to create data access policies that define who can access specific data objects and what permissions they have to those objects. The DAG tool can also be used to audit data access and to generate reports on data access.
Use a third-party auditing tool: There are a number of third-party auditing tools that you can use to audit data sharing on Snowflake. These tools can provide additional features, such as data lineage and data masking.
Data lineage is the tracking of the movement of data through your Snowflake environment. This can help you to identify the sources of your data and the downstream systems that use it.
Data masking is a technique that can be used to obscure sensitive data before it is shared with partners. This can help to protect your data from unauthorized access and misuse.
By using one of these methods, you can help to ensure that your shared data is being accessed only by authorized users.
Here are the steps on how to track when your shared data has been accessed using the Snowflake audit log:
- Log in to your Snowflake account.
- Click on the Administration tab.
- Click on the Audit Log tile.
- In the Filter section, select the Data Sharing event type.
- In the Time Range section, select the period of time that you want to track.
- Click on the Run button.
- The audit log will display a list of all data sharing events that have occurred within the selected time range.
- You can use the User, Object, Action, and Timestamp columns to identify when your shared data has been accessed.