Good afternoon <#C02CTC89LAX|>. I am having a prob...
# community-support
g
Good afternoon #C02CTC89LAX. I am having a problem with elementary (on dbt-databricks) on one of my environments. I bumped dbt-databricks to latest and elementary from 12.1 to 13.2 and ran the elementary models but ran into issues (with the information_schema tables). I assumed elementary is not yet compatible with the latest dbt-databricks version. But now that I rolled back dbt-databricks to the previous version the elementary report fails to generate completely due to a 'number of columns mismatch' in a union ran by elementary. (screenshot) What I think might have happened due to how I have setup my pipelines is that it first ran 'dbt run -s elementary' with 13.2, then with 12.1 and finally with 13.2 again and now it seems I broke stuff. Can I fix this somehow without losing the logs already generated by elementary?
n
Hey @Gijs Jansen To solve it you should do one of these two options: • Delete the view manually as described here: https://elementary-community.slack.com/archives/C02CTC89LAX/p1705236816779769?thread_ts=1705096925.743739&amp;cid=C02CTC89LAX • Run
dbt run -s elementary --full-refresh
- see docs on full-refresh here
✅ 1
g
Thank you Noy!