Triggering alerts from Data Warehouse managed by dbt 🚀
Who is this for?
For the dbt-ers who want:
- To leverage the notification feature of the Data Warehouse (e.g. Snowflake Notification Integration)
- To manage the alerting jobs via SQL script (which is similar to dbt singular test)
- Add to
packages.yml
file:
packages:
- package: infinitelambda/dbt_alert
version: [">=1.0.0", "<1.1.0"]
Or use the latest version from git:
packages:
- git: "https://github.com/infinitelambda/dbt-alert"
revision: <release version or tag>
And run dbt deps
to install the package!
Jump into Getting Started page for more details on how to start using this package with Snowflake.
📹 Here is a quick live demo:
!!! tip "See dbt_project.yml
file"
Go to vars
section here 🏃
We managed to provide the inline comments only for now, soon to have the dedicated page for more detail explanation.
Here are the full list of built-in variables:
dbt_alert__mailing_list
: Mandatorydbt_alert__jobs
: Mandatory if usingexecute_jobs
macrodbt_alert__dbt_cloud_access_url
dbt_alert_notification_integration_id
dbt_alert_notification_integration_usage_role
dbt-alert
is an open-source dbt package. Whether you are a seasoned open-source contributor or a first-time committer, we welcome and encourage you to contribute code, documentation, ideas, or problem statements to this project.
👉 See CONTRIBUTING guideline for more details or check out CONTRIBUTING.md
🌟 And then, kudos to our beloved Contributors:
Infinite Lambda is a cloud and data consultancy. We build strategies, help organizations implement them, and pass on the expertise to look after the infrastructure.
We are an Elite Snowflake Partner, a Platinum dbt Partner, and a two-time Fivetran Innovation Partner of the Year for EMEA.
Naturally, we love exploring innovative solutions and sharing knowledge, so go ahead and:
🔧 Take a look around our Git
✏️ Browse our tech blog
We are also chatty, so:
👀 Follow us on LinkedIn
👋🏼 Or just get in touch