Here are a few ways to track what actions have been performed on your shared data 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 and that any actions performed on the data are being tracked.
Here are the steps on how to track what actions have been performed on your shared data 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 Action section, select the action 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 and that involve the selected action.
- You can use the User, Object, Action, Timestamp, and Details columns to identify what actions have been performed on your shared data.