Categories:

System functions (System Information)

SYSTEM$ADD_EVENT（适用于 Snowflake Scripting）¶

添加一个用于跟踪的事件。

使用来自以 Snowflake Scripting 编写的处理程序的跟踪事件时，使用 SYSTEM$ADD_EVENT 添加事件。

For more information, refer to Emitting trace events in Snowflake Scripting.

语法

SYSTEM$ADD_EVENT('<name>', '<object>');

实参

'name'

要添加的事件的名称。

'object'

包含表示要添加的属性之名称-值对的对象。

示例

Code in the following example uses the SYSTEM$ADD_EVENT function to add an event named name_a and an event named name_b. With name_b, it associates two attributes, score and pass. The code also sets two attributes for the span, key1 and key2.

CREATE OR REPLACE PROCEDURE pi_proc()
  RETURNS DOUBLE
  LANGUAGE SQL
  AS $$
  BEGIN
    -- Add an event without attributes
    SYSTEM$ADD_EVENT('name_a');

    -- Add an event with attributes
    LET attr := {'score': 89, 'pass': TRUE};
    SYSTEM$ADD_EVENT('name_b', attr);

    -- Set attributes for the span
    SYSTEM$SET_SPAN_ATTRIBUTES({'key1': 'value1', 'key2': TRUE});

    RETURN 3.14;
  END;
  $$;