Snowflake built-in logging captures messages emitted during stored-procedure execution and stores them in a queryable event table. It supports operational review without adding a custom logging table and INSERT statements. section 4.4
Snowflake built-in logging
Snowflake built-in logging is a Snowflake capability that captures log messages emitted while stored procedures execute.
How Snowflake Data Engineering covers it
- How deep it goes
- Explains event-table setup, account association, privileges, log levels, emitted messages, and SQL queries, while deferring deeper logging and tracing details.
- Examples
- Uses LOAD_CUSTOMER_ORDERS, SYSTEM$LOG_DEBUG, BAKERY_EVENTS, and a descending timestamp query.
- What it assumes
- Assumes stored-procedure and Snowflake role knowledge while specifying required event-table and account-privilege setup.
- What you can do after
- Operate and review stored-procedure logging by configuring an event table, setting levels, emitting messages, and querying results.
- How it connects
- Connects stored procedures, event tables, SQL queries, log levels, roles, privileges, and access controls.
Related concepts
- logalternative to · A log is a record of events, activity, or diagnostic information produced during the operation of a system or process, often ordered by time.
- event tableproduces · An event table is a Snowflake table with predefined columns for storing event and log records generated by account features.
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.