I am trying to append data into table which already exists with some data in it.
I need to create view by joining multiple tables which later will be used to append data in final table .
I am able to alter table schema and then run query to insert data from view without error
Whenever I create temp view in one cell I am able to see data in that temp view in another cell but when I run merge query on final table it didn't reflect data in that final table
And also to mention that I have checked the merge query with other created dummy empty tables and then using same merge query on that dummy table which is working fine for me
What could be the possible reasons of this issue and What should I do to identify issue in this case?