google bigquery - write Legacy views in Standard SQL format

Question

I wish to update my big query table :

FROM [myProject.Mydataset.ga_sessions_20171129]

I can update it to a standard SQL format:

 FROM `myProject.Mydataset.ga_sessions_20171129`

ga_sessions_20171129 is my table id and the last part of its name shows the last date that the table is updated, so the next table for the next day will be 20171130

How do I write something like that?

from `ga_sessions_*` where _TABLE_SUFFIX=TODAY

That updates the date every day to today's date

Answer 1

Waitting for answers