TableQuery Meta

[neuecc]

http://stackoverflow.com/questions/22734777/how-do-i-use-the-table-query-function-in-bigquery

• table_id: name of the table.
• creation_time: time, in milliseconds since 1/1/1970 UTC, that the table was created. This is the same as the creation_time field on the table.
• last_modified_time: time, in milliseconds since 1/1/1970 UTC, that the table was updated (either metadata or table contents). Note that if you use the tabledata.insertAll() to stream records to your table, this might be a few minutes out of date.
• type: whether it is a view (2) or regular table (1).
• row_count: number of rows in the table.
• size_bytes: total size in bytes of the table.

SELECT * FROM publicdata:samples.__TABLES__