Add custom sql variable - Githubissues

snowplow / dbt-snowplow-unified

A fully incremental model, that transforms raw web & mobile event data generated by the Snowplow JavaScript & mobile trackers into a series of derived tables of varying levels of aggregation.

Other

12 stars 5 forks source link

Add custom sql variable #31

Closed rlh1994 closed 9 months ago

rlh1994 commented 9 months ago

Description

Adds support for the custom_sql argument to the base events this run table to allow users to add SQL to these models without needing to fully overwrite the macros.

What type of PR is this? (check all applicable)

[x] 🍕 Feature
[ ] 🐛 Bug Fix
[ ] 📝 Documentation Update
[ ] 🎨 Style
[ ] 🧑‍💻 Code Refactor
[ ] 🔥 Performance Improvements
[ ] ✅ Test
[ ] 🤖 Build
[ ] 🔁 CI
[ ] 📦 Chore (Release)
[ ] ⏩ Revert

Related Tickets & Documents

https://snplow.atlassian.net/browse/PE-6049

Checklist

[x] 🎉 I have verified that these changes work locally
[ ] 💣 Is your change a breaking change?
[x] 📖 I have updated the CHANGELOG.md

Added tests?

[ ] 👍 yes
[x] 🙅 no, because they aren't needed
[ ] 🙋 no, because I need help

Added to documentation?

[ ] 📓 internal package docs (ymls, macros, readme, if applicable)
[ ] 📕 I have raised a Snowplow documentation PR if applicable (Link here if required)
[x] 🙅 no documentation needed

[optional] Are there any post-deployment tasks we need to perform?

[optional] What gif best describes this PR or how it makes you feel?