0

I need to create a separate table/view from a partition table with daily data.

I used this query:

SELECT * FROM `awantec-gws-bigquery2.gmail_log_dataset_copy.daily_*` 

but I get this error:

Views cannot be queried through prefix. First view awantec-gws-bigquery2:gmail_log_dataset_copy.daily_gmail_log.

Mazlum Tosun
  • 5,761
  • 1
  • 9
  • 23

0 Answers0