title: Is there a way to select table_id in a Bigquery Table Wildcard Query
body: <p>I have a set of day-sharded data where individual entries do not contain the day.  I would like to use table wildcards to select all available data and get back data that is grouped by both the column I am interested in and the day that it was captured.  Something, in other words, like this:</p>
  
  <pre><code>SELECT table_id, identifier, Sum(AppAnalytic) as AppAnalyticCount 
      FROM  (TABLE_QUERY(database_main,'table_id CONTAINS "Title_" AND length(table_id) &gt;= 4')) 
      GROUP BY identifier, table_id order by AppAnalyticCount DESC LIMIT 10 
  </code></pre>
  
  <p>Of course, this does not actually work because table_id is not visible in the table aggregation resulting from the TABLE_QUERY function.  Is there any way to accomplish this?  Some sort of join on table metadata perhaps?</p>