{"repo":"jaysobel/dbt-snowflake-queries","free":true,"listed":false,"github":"https://github.com/jaysobel/dbt-snowflake-queries","clone":"git clone https://github.com/jaysobel/dbt-snowflake-queries.git","description":"Snowflake-specific dbt package for account-wide query workload and table- and column-level usage analytics","language":null,"stars":21,"topics":["analytics-engineering","dbt","dbt-packages","snowflake","data-usage","query-history","access-history","snowflake-account-usage","workload-analytics"],"license":"MIT","category":"data-pipelines","readme_excerpt":"dbt Snowflake Queries A Snowflake-specific dbt package for modeling account-wide query activity, recurring workload patterns, and table- and column-level usage. This is a usage mart, not a lineage parser. It answers questions such as: - Which queries and parameterized query patterns run most often? - Which users, roles, warehouses, databases, and schemas generate the workload? - Which tables, views, and columns are directly or indirectly used? - Where do execution time, queueing, spilling, retries, failures, and row changes concentrate? - Which catalog objects appear active, stale, large, or unused? Models The package exposes five public mart models: Model Grain Purpose --- --- --- fct snowflake queries Query execution Curated query context, hashes, timing, status, and workload measures. fct snowflake query tables Query + table/view Object usage with separate direct- and base-access flags. fct snowflake query table columns Query + table/view column Column usage with separate direct- and base-access flags. dim snowflake tables Current table/view Catalog identity, ownership, type, size, and lifecycle context. dim snowflake table columns Current table/view column Type, nullability, identity, virtual-expression, and documentation context. table sk is the lowercased fully qualified database.schema.table name. table column sk appends the lowercased column name. These readable identifiers make the facts and dimensions straightforward to join and inspect. The public marts use those r","default_branch":null,"files":null,"tree":[],"storefront":"/r/jaysobel","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/jaysobel/dbt-snowflake-queries/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}