Hey Team, I am getting following error while tryin...
# community-support
m
Hey Team, I am getting following error while trying to setup elementary. Do we have any idea about it? elementary version - 0.12.1 We are using Snowflake.
Copy code
09:04:05 Running 1 on-run-end hook
09:05:49 Database error while running on-run-end
09:05:50 Encountered an error:
Database Error
001998 (42710): SQL compilation error:
Object 'DBT_COLUMNS' already exists as VIEW
✅ 1
d
Hey @Mandar, can you share the structure of your db schema you're using elementary for ?
m
We have dbt_prod_elementary schema in the database. It is working with downgraded version. But we are not able to read config & send report on slack.
d
Ok, I understood the issue.
DBT_COLUMNS
is a model that is managed by elementary package, and it used to be a db view, and changed lately to be a table. You can drop this view from your
dbt_prod_elementary
, and run
dbt run
again. It will re-create the model correctly.
m
Thank you, We will check..
✅ 1