liveBook · Manning

Event table

As explained in Snowflake Data Engineering

An event table is a Snowflake table with predefined columns for storing event and log records generated by account features.

An event table is a Snowflake table with predefined columns for storing log messages emitted by stored procedures and other account features. Snowflake associates one active event table with each account, making it a shared destination for built-in logging. section 4.4 section 4.6

Set up and use an event table through these operational steps:

  • Create the table in a suitable database and schema, such as BAKERY_DB.TRANSFORM.BAKERY_EVENTS. section 4.4
  • Associate the table with the account; only one event table can be active for the account. section 4.6

Logging a pipeline procedure

A LOAD_CUSTOMER_ORDERS procedure emits a DEBUG message before merging data. After CALL LOAD_CUSTOMER_ORDERS(), querying BAKERY_EVENTS ordered by timestamp exposes the recorded activity.

How Snowflake Data Engineering covers it

How deep it goes
Defines predefined columns, account association, setup steps, log-level configuration, and querying without enumerating the column schema.
Examples
Uses BAKERY_EVENTS, LOAD_CUSTOMER_ORDERS, SYSTEM$LOG_DEBUG, CALL, and timestamp-ordered SQL queries.
What it assumes
Assumes Snowflake account roles and a stored procedure, while introducing account association and logging-level permissions.
What you can do after
Operate/configure Snowflake built-in logging by creating, associating, querying, and controlling an event table.
How it connects
Connects stored procedures, built-in logging, account-level objects, exception handling, and data pipelines.
Cover of Snowflake Data Engineering
liveBookmanning.com
Read Snowflake Data Engineering on liveBook Get the book at manning.com

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Snowflake Data Engineering. The section links point to the parts of the book it draws on.