Skip to content

edr monitor fails for dbt-duckdb adapter #2006

@Tomiwa-dev

Description

@Tomiwa-dev

Describe the bug
edr monitor fails for dbt-duckdb adapter returns
Runtime Error in model alerts_v2 (models/alerts/alerts_v2.sql)
Catalog Error: Scalar Function with name dateadd does not exist!
Did you mean "date_add"?

LINE 54: dateadd(day, cast(-1 as integer), cast(

I will attach the complete error log

output.txt

To Reproduce
Steps to reproduce the behavior:

  1. run edr monitor --slack-token <slack_token> --slack-channel-name <slack-channel-name> in the terminal

Expected behavior
Send failure alerts to specified slack channel

Environment (please complete the following information):
Elementary CLI (edr) version: 0.19.5
Elementary dbt package version: 0.19.4
dbt-duckdb: 1.9.6
database: ducklake on motherduck

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions