Snowflake Stored Procedures

the kensu collector for snowflake stored procedure is a powerful tool designed to enhance data observability in snowflake environment by collecting metadata from stored procedures and snowflake tables, it provides valuable insights into data lineage, schema changes, and metrics how it works step 1 extraction of snowflake metadata query and access history analysis the system taps into snowflake's account usage query history and account usage access history tables to gather metadata related to the execution of stored procedures this includes identifying which tables are used within these procedures, as well as capturing the input/output relationships among these tables, to construct a detailed lineage map stored procedure identification it identifies stored procedures being executed and extracts relevant execution details, including parameters, execution times, and outcomes step 2 extraction from tables data source schema extraction for each table identified in the lineage of a stored procedure, the collector retrieves schema details, such as column names and data types this helps in understanding the structure of data being manipulated quality metrics collection alongside schema information, the system collects a range of quality metrics for the data sources involved these metrics may include column level statistics like null counts, unique value counts, and distribution summaries, providing a comprehensive view of data quality step 3 post extraction after collection, all observations—including lineage information, schema details, and quality metrics—are transmitted to kensu core, which will process and analyze the metadata to offer actionable insights, such as anomaly detection, data quality issues, and performance bottlenecks