google bigquery - Use of TABLE_DATE_RANGE function in Views

Question

I am excited about the new featured released earlier this week.

I went to create a view that Unions my "last 90 days" tables. such view can be very useful and simplifies any coding significantly. I used the new TABLE_DATE_RANGE function.

I wrote:

SELECT 
 *
FROM 
(TABLE_DATE_RANGE(mydataset.mytableprefix, 
                    DATE_ADD(CURRENT_TIMESTAMP(), -90, 'DAY'),
                    CURRENT_TIMESTAMP()))

When running the query it runs fine, when I clicked "Save View" I got a red error message saying:

Failed to create view. Not Found: Table myproject:mydataset.mytableprefix

this happens also if use use specific fields instead of Select *.

Are there limits of usage of the TABLE_DATE_RANGE in views?

Answer 1

Waitting for answers