Query Failed Error: Views Cannot Be Queried Through Prefix. Partial List Of The Matched Views Are

I am trying to query a dataset with multiple tables and equivalent views. I am trying to query just the tables using _table_suffix, but it returns an error 'Query Failed Error: Vie

Solution 1:

Your options are:

• Recreate the views under different names, so that the viewed_ prefix doesn't match them.
• Use a longer prefix than viewed_ (if possible) when matching the table names, so that the view names aren't included.
• Migrate your tables to a single partitioned table so that you don't need to use a wildcard.

I would suggest the third option if at all possible; using a partitioned table is much better than trying to maintain multiple tables with a common schema.