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.