title: Using Table Decorators on Big Query Web Interface
body: <p>I saw the news about <a href="https://developers.google.com/bigquery/querying-data#tabledecorators" rel="nofollow">Table Decorators</a> being available to limit the amount of data that is queried by specifying a time interval or limit.  I did not see any examples on how to use the Table Decorators in the Big Query UI.  Below is an example query that I'd like to run and only look at data that came in over the last 4hours.  Any tips on how I can modify this query to utilize Table Decorators?  </p>
  
  <p><code>SELECT 
      foo,
      count(*)
  FROM [bigtable.201309010000]
  GROUP BY 1</code></p>
  
  <p><strong>EDIT after trying example below</strong></p>
  
  <p>The first query above scans 180GB of data for the month of September (up through Sept 19th).  I'd expect the query below to only scan data that came in during the time period specified.  In this case 4hrs, so I'd expect the billing to be about 1.6GB not 180GB.  Is there a way to set up ETL/query so we do not get billed for scanning the whole table?  </p>
  
  <p><code>SELECT 
      foo,
      count(*)
  FROM [bigtable.201309010000@-14400000]
  GROUP BY 1</code></p>