I have Questions and Dashboards based on MySql view table.
Each question has variables parameters mapping to field filter to specific table columns like date to a date column in a table, and so on.
But when I altered the view using below illustration code, all the mapping is gone. And I must repeat all the mappings again for each question?
ALTER VIEW my_existing_view_name AS
SELECT existing_columns
FROM existing_tables
WHERE existing_parameters in ('existing_values','new_value')
Is there solution or rollback to this scenario?
I just change very minor (add new value in parameters like above)
Hi @eric.halim
I don't think I follow. If you rename a table (or view) or column, then Metabase has no knowledge of that rename, so when Metabase does a sync, then it will deactivate the old table/column and create the new table/column.
Exactly, I didn't change the view name. I just change value in one of the parameters in the view table. So I didn't expect I will loose all the field mappings.