How to change table name a view references
I created a view in Yellowfin in my public redshift schema off a temporary table (let's call it public.tmp_view_1) so that I could get internal feedback on the reports created using the view. Now the format of the reports is finalized I'm going to create an automated job to write the data to production (call it prod.view_1).
What I'm concerned about is breaking all my reports if I just delete public.tmp_view_1 and drag in prod.view_1 in the Entity Relationships tab of the View Builder. I also have a lot of calculated fields that I think may get deleted.
Is there any way to switch the tables the view refers to over without breaking everything? In hindsight I should've just used a virtual table with select * from public.tmp_view_1 and the change would've been simple as the two tables are identical.