I am creating a view in a bigQuery table. The view works fine until I truncate this table and put new data into it. I get the following error:
"Query Failed Error: A view from this query references an old version of
a table that might be incompatible. Please delete and re-create
repcore-dev:views.listings."
If I run a query that defines a view, it works. If I re-create the view with the same request, it will work. But my question is why this is necessary. For us, the real value in the view is that it provides an abstraction of table data (even when this data is re-populated).
source
share