Hello! Perhaps someone can help me spot what I am ...
# community-support
j
Hello! Perhaps someone can help me spot what I am missing. I am running the elementary github action package as shown here. I keep running into:
Copy code
Failed to get Elementary dbt package version: {'returncode': 2, 'cmd': ['dbt', '--log-format', 'json', 'run-operation', 'get_elementary_dbt_pkg_version', '--project-dir', '/edr_stager_dbt_project'], 'output': b'{"data": {"log_version": 3, "version": "=1.7.10"}, "info": {"category": "", "code": "A001", "extra": {}, "invocation_id": "e41771a8-8a70-4d2a-81b9-27bd51ab3ae1", "level": "info", "msg": "Running with dbt=1.7.10", "name": "MainReportVersion", "pid": 53, "thread": "MainThread", "ts": "2024-03-14T22:35:47.443650Z"}}\n{"data": {"exc": "Runtime Error\\n  Could not find profile named \'elementary\'"}, "info": {"category": "", "code": "Z002", "extra": {}, "invocation_id": "e41771a8-8a70-4d2a-81b9-27bd51ab3ae1", "level": "error", "msg": "Encountered an error:\\nRuntime Error\\n  Could not find profile named \'elementary\'", "name": "MainEncounteredError", "pid": 53, "thread": "MainThread", "ts": "2024-03-14T22:35:47.450651Z"}}\n', 'stderr': b''}
And, I have the dbt profile set up like in the picture below. What am I missing?
s
I also started getting this error today. Didnt change anything in profile.yml. Tried bumping from 1.11 -> 1.12 with no luck
j
Good to know I’m not alone! I’ll keep trying and let you know if I crack it. Let me know if you figure it out
After much research it appears that it is looking for some variable to iterate over, and when it does not find this mystery variable in the profile(?) it craps out. There is no indication of what its looking for It runs fine in my local machine but does not work in github actions.
resolved: The schema variable works slightly differently for dbt project and elementary. While dbt will create the schemas based on the variable provided with the <schema> variable as a prefix, elementary needs the full schema name as it exists in the project. Once I updated that, I was able to get it to work.