I created a view in my Postgres database:
create or replace view nj_workers as
select first_name, last_name, phone
from employee
where state = 'NJ'
I did my database sync, all is well.
Now I want to change the name of the “phone” field to “phone_number”
create or replace view nj_workers as
select first_name, last_name, phone as phone_number
from employee
where state = 'NJ'
I did this, I can see the change if I run a query via PGAdmin. I sync’ed the database, but when I try to create a new question referencing the view, I get:
ERROR: column nj_employees.phone does not exist
How can I “kick” metabase to tell it to reload the view definition?