{"repo":"snowplow/dbt-snowplow-utils","free":true,"listed":false,"github":"https://github.com/snowplow/dbt-snowplow-utils","clone":"git clone https://github.com/snowplow/dbt-snowplow-utils.git","description":"Snowplow utility functions to be used in conjunction with the snowplow-web dbt package.","language":"Shell","stars":15,"topics":["dbt","data-model","snowplow-analytics"],"license":null,"category":"data-pipelines","readme_excerpt":"[![early-release]][tracker-classificiation] [![License][license-image]][license] [![Discourse posts][discourse-image]][discourse] snowplow-utils This package contains a mix of functionality to be used with the other Snowplow dbt packages, or to be used within your own packages/projects. Includes: - Overwritten incremental materialization. - Utils to assist with modeling Snowplow data. - Pre and post hooks to handle incremental processing of events. - Various helper macros used throughout data modeling. Contents Macros - snowplow-utils - Contents - Macros - get\\ columns\\ in\\ relation\\ by\\ column\\ prefix (source) - combine\\ column\\ versions (source) - is\\ run\\ with\\ new\\ events (source) - snowplow\\ web\\ delete\\ from\\ manifest (source) - snowplow\\ mobile\\ delete\\ from\\ manifest (source) - get\\ value\\ by\\ target (source) - set\\ query\\ tag (source) - get\\ sde\\ or\\ context (source) - get\\ field (source) - Array functions - get\\ array\\ to\\ string (source) - get\\ split\\ to\\ array (source) - get\\ string\\ agg (source) - get\\ array\\size (source) - unnest (source) - Date & time functions - timestamp\\ diff (source) - timestamp\\ add (source) - cast\\ to\\ tstamp (source) - to\\ unixtstamp (source) - current\\ timestamp\\ in\\ utc (source) - n\\ timedeltas\\ ago (source) - Materializations - Optimized incremental - BigQuery - Snowflake - Notes - Base Macro - Create Snowplow Quarantined Sessions (source) - Create Snowplow Incremental Manifest (source) - Create Snowplow Sessions Lifecycle Manifest (s","default_branch":null,"files":null,"tree":[],"storefront":"/r/snowplow","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/snowplow/dbt-snowplow-utils/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."}