title: Change FROM Table Name Dynamically based on date in Bigquery Scheduled Query
body: <p><a href="https://i.stack.imgur.com/lMcKo.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/lMcKo.jpg" alt="enter image description here" /></a></p>
  <p>Please refer the screenshot attached.. i need to set up a bigquery scheduled task to pull info into a permanent table. the from table name will dynamically change each day so i can pull that day info only and append it to the existing table. any help will be highly appreciated<a href="https://i.stack.imgur.com/o5OZU.jpg" rel="noreferrer"><img src="https://i.stack.imgur.com/o5OZU.jpg" alt="enter image description here" /></a></p>
  <p>please see the second image...i tried to achieve using this.. but i am unable to convert yester into String.. and add it ..</p>
  <p>actually this was the query i am looking to implement this..</p>
  <p>SELECT event_date, event_timestamp, event_name,
  (select value.double_value from unnest(event_params) where key = 'percentage') as percentage,
  (select value.double_value from unnest(event_params) where key = 'seconds') as seconds
  FROM xscore-prod.analytics_229726387.events_*
  WHERE event_name = &quot;spent_time_in_activity&quot;</p>
  <p>how can i implement the script into this</p>