Categories:: Table functions

CUMULATIVE_PRIVACY_LOSSES¶

Returns the privacy budgets associated with a specific privacy policy.

For more information about viewing privacy budgets, see View a privacy budget.

Syntax¶

SNOWFLAKE.DATA_PRIVACY.CUMULATIVE_PRIVACY_LOSSES( '<privacy_policy>' )

Copy

Arguments¶

'privacy_policy': Specifies the fully-qualified name of the privacy policy. A privacy policy is a schema-level object.

Output¶

Column	Data type	Description
`policy_database`	VARCHAR	Database that contains the privacy policy.
`policy_schema`	VARCHAR	Schema that contains the privacy policy.
`policy_name`	VARCHAR	Name of the privacy policy.
`budget_name`	VARCHAR	Name of the privacy budget in the privacy policy.
`consumer_account`	VARCHAR	Organization and account where users executed queries that incurred privacy loss.
`budget_spent`	DECIMAL	Cumulative privacy loss since the last time the privacy budget was refreshed.

Usage notes¶

A privacy budget only appears if analysts associated with the privacy budget have incurred privacy loss or if an administrator has reset the privacy budget.

Examples¶

View the privacy budgets that are associated with the my_policy_privacy policy:

SELECT *
  FROM TABLE(SNOWFLAKE.DATA_PRIVACY.CUMULATIVE_PRIVACY_LOSSES(
    'my_policy_db.my_policy_schema.my_policy_privacy'));

Copy