Hello, I upgraded the elementary version used in m...
# community-support
q
Hello, I upgraded the elementary version used in my project from 0.8.1 to 0.13.1 and I am now encountering the following error in my
on-run-end
hook in dbt:
Copy code
Database error while running on-run-end
cannot insert into a view
I am using a redshift datawarehouse hosted in AWS. Anyone has clues on how to fix this issue?
s
may need to run
dbt run -s elementary
though I'm not sure if this will preserve your historic data
my best guess is elementary changed how it organizes the elementary schema in redshift between versions and no longer uses views somewhere
either way you can query the redshift system tables to see which objects in your elementary schema are views and figure out what to do from there
q
Thanks! This command
dbt run -s elementary
solved my issue 🙂
garfieldthumbsup 1