https://linen.dev logo
Join Slack
Powered by
hey folks, I am trying to run this ```edr monitor ...
# community-support
j
hey folks, I am trying to run this
Copy code
edr monitor --slack-webhook <the slack channel webhook>
but I got this weird error 🧵
Copy code
2023-11-21 16:52:33 — ERROR — Unable to get the latest invocation: Failed to run dbt command.
2023-11-21 16:52:38 — INFO — Elementary's database and schema: '"development_jimmy.ELEMENTARY"'
2023-11-21 16:52:38 — INFO — Running internal dbt run to aggregate alerts
2023-11-21 16:52:38 — INFO — Running dbt run -m elementary_cli.alerts --project-dir /Users/jimmy.pang/anaconda3/envs/dbt/lib/python3.9/site-packages/elementary/monitor/dbt_project
15:52:39  Running with dbt=1.3.4
15:52:40  Found 40 models, 6 tests, 0 snapshots, 0 analyses, 1137 macros, 2 operations, 0 seed files, 6 sources, 0 exposures, 0 metrics
15:52:40  
15:52:41  
15:52:41  Running 1 on-run-start hook
15:52:41  1 of 1 START hook: elementary.on-run-start.0 ................................... [RUN]
15:52:41  1 of 1 OK hook: elementary.on-run-start.0 ...................................... [OK in 0.00s]
15:52:41  
15:52:41  Concurrency: 4 threads (target='personal_dev')
15:52:41  
15:52:41  1 of 3 START sql incremental model ELEMENTARY.alerts ........................... [RUN]
15:52:41  2 of 3 START sql incremental model ELEMENTARY.alerts_models .................... [RUN]
15:52:41  3 of 3 START sql incremental model ELEMENTARY.alerts_source_freshness .......... [RUN]
15:52:42  2 of 3 ERROR creating sql incremental model ELEMENTARY.alerts_models ........... [ERROR in 0.92s]
15:52:42  3 of 3 ERROR creating sql incremental model ELEMENTARY.alerts_source_freshness . [ERROR in 1.05s]
15:52:43  1 of 3 ERROR creating sql incremental model ELEMENTARY.alerts .................. [ERROR in 2.22s]
15:52:43  
15:52:43  Running 1 on-run-end hook
15:52:43  1 of 1 START hook: elementary.on-run-end.0 ..................................... [RUN]
15:52:43  1 of 1 OK hook: elementary.on-run-end.0 ........................................ [OK in 0.00s]
15:52:43  
15:52:43  
15:52:43  Finished running 3 incremental models, 2 hooks in 0 hours 0 minutes and 3.69 seconds (3.69s).
15:52:43  
15:52:43  Completed with 3 errors and 0 warnings:
15:52:43  
15:52:43  Database Error in model alerts_models (models/alerts/alerts_models.sql)
15:52:43    000606 (57P03): No active warehouse selected in the current session.  Select an active warehouse with the 'use warehouse' command.
15:52:43    
15:52:43  
15:52:43  Database Error in model alerts_source_freshness (models/alerts/alerts_source_freshness.sql)
15:52:43    000606 (57P03): No active warehouse selected in the current session.  Select an active warehouse with the 'use warehouse' command.
15:52:43    
15:52:43    compiled Code at target/run/elementary_cli/models/alerts/alerts_source_freshness.sql
15:52:43  
15:52:43  Database Error in model alerts (models/alerts/alerts.sql)
15:52:43    000606 (57P03): No active warehouse selected in the current session.  Select an active warehouse with the 'use warehouse' command.
15:52:43    
15:52:43    compiled Code at target/run/elementary_cli/models/alerts/alerts.sql
15:52:43  
15:52:43  Done. PASS=0 WARN=0 ERROR=3 SKIP=0 TOTAL=3
I feel it could be an inhouse thing but wanna check with u folks first
d
Hey @Jimmy PANG, 
dbt debug
works for you ?
j
dbt debug
works with no problem for me
d
What about 
edr report
?
j
I guess the issue here is the 
profile-dir
edr report
doesn't work
d
fails with the same error ?
j
yes
d
I guess you're using Snowflake. Did you set the 
warehouse
param in your connection profile ?
j
yes
d
and 
dbt run/test
works for you also ?
j
yes
d
Interesting. I would check Snowflake's query history and look for the failed queries, and try to understand in what context they were running
j
I think it is from my vitural enviorment (anaconda)
Copy code
023-11-21 16:52:38 — INFO — Running dbt run -m elementary_cli.alerts --project-dir /Users/jimmy.pang/anaconda3/envs/dbt/lib/python3.9/site-packages/elementary/monitor/dbt_project
I think the trick is here: 
--project-dir /Users/jimmy.pang/anaconda3/envs/dbt/lib/python3.9/site-packages/elementary/monitor/dbt_project
d
what do you mean ?
j
basically, my 
profile.yml
is stored in the directory 
/users/jimmy.pang/.dbt
but this generated path is directing to the path of 
/Users/jimmy.pang/anaconda3/envs/dbt/lib/python3.9/site-packages/elementary/monitor/dbt_project
instead
and there is no 
profile.yml
file
I tried to duplicate the 
profile.yml
file and do 
dbt debug --project-dir /Users/jimmy.pang/anaconda3/envs/dbt/lib/python3.9/site-packages/elementary/monitor/dbt_project
, it works
but the same 
edr report
still doesn't work
d
mm dbt should still take the profiles.yml from your home directory.
j
nope don't think it is the case atm
not running in a Vitural environment, that is
d
try to run maybe 
edr report --profiles-dir path_to_profiles_dir
j
Copy code
NotADirectoryError: [Errno 20] Not a directory: '/Users/jimmy.pang/.dbt/profiles.yml/dbt_packages'
nope lol
d
edr report --profiles-dir /Users/jimmy.pang/.dbt/
j
okay now it works
✅ 1
35 Views
Open in Slack
PreviousNext
Powered by