Monitor storage lifecycle policies¶

备注

确定哪些表附加了存储生命周期策略，并使用 Snowflake 的内置函数监控存储生命周期策略运行。

备注

有关监控存储生命周期策略成本的信息，请参阅存储生命周期策略计费。

Monitor policy assignments¶

要查看存储生命周期策略元数据，请使用以下视图：

请参阅生命周期策略附件¶

To see which tables a particular lifecycle policy is attached to, call the POLICY_REFERENCES table function in the Snowflake Information Schema. The function displays only the tables that you have the OWNERSHIP privilege on.

该函数为数据库中附加了指定策略的每个表返回一行。

示例：列出与策略关联的所有表¶

The following query retrieves a list of tables with a specified storage lifecycle policy attached:

SELECT *
  FROM TABLE(
    my_db.INFORMATION_SCHEMA.POLICY_REFERENCES(
    POLICY_NAME => 'my_storage_lifecycle_policy'
  )
);

Copy

示例：查找分配给表的策略¶

检索分配给指定表的策略：

SELECT *
  FROM TABLE(
    my_db.INFORMATION_SCHEMA.POLICY_REFERENCES(
      REF_ENTITY_NAME => 'my_db.my_schema.my_table',
      REF_ENTITY_DOMAIN => 'table'))
  WHERE POLICY_KIND = 'STORAGE_LIFECYCLE_POLICY';

Copy

监控存储生命周期策略运行¶

To monitor storage lifecycle policy executions over the last 14 days, use the STORAGE_LIFECYCLE_POLICY_HISTORY table function. For information about the function output, see the STORAGE_LIFECYCLE_POLICY_HISTORY page.

以下示例检索了附加到指定表的策略在最后一天内计划的 100 次最新执行：

SELECT * FROM
  TABLE(
    INFORMATION_SCHEMA.STORAGE_LIFECYCLE_POLICY_HISTORY(
      REF_ENTITY_NAME => 'my_db.my_schema.my_source_table',
      REF_ENTITY_DOMAIN => 'table',
      TIME_RANGE_START => DATEADD('DAY', -1, CURRENT_TIMESTAMP()),
      RESULT_LIMIT => 100
    )
  );

Copy

Alternatively, to retrieve historical data for storage lifecycle policy runs, use the following views: