TAGS view (ACCOUNT_USAGE): New columns (Preview)

Attention

This behavior change is in the 2025_02 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the ACCOUNT_USAGE TAGS view includes the following new columns:

Column name

Data type

Description

propagate

VARCHAR

Indicates whether the tag is configured for automatic propagation. Possible values are the following:

  • NULL — Tag is not propagated.

  • ON_DEPENDENCY — Tag is propagated when there is an object dependency (for example, creating a view from a tagged table).

  • ON_DATA_MOVEMENT — Tag is propagated when there is data movement (for example, using a CTAS statement to create a table from a tagged table).

  • ON_DEPENDENCY_AND_DATA_MOVEMENT — Tag is propagated for both object dependencies and data movement.

on_conflict

VARCHAR

If the tag is configured for automatic propagation, indicates what happens when the value of the tag being propagated conflicts with the value that was specified when the tag was manually applied to the same object.

These columns are being added as the last columns of the view.

Ref: 1937