title: How to create table with incremental load in BIG QUERY
body: <p>I have a table EMP, which will be WRITE_TRUNCATE every day. the truncated data is maintained in a historical table called emp_hx along with the record incoming date. like as follows</p>
  
  <p><img src="https://i.stack.imgur.com/NkIwX.jpg" alt="Actual and Historical data"></p>
  
  <p>But due to the space issues we want to maintain only the changed records or new records in the "hx" table, which is like a incremental load kind of table. how to Implement such kind of table or how to select such kind of incremental data in BIG QUERY, </p>
  
  <p>Please guide us.</p>
  
  <p>Expected output like as follows</p>
  
  <p><img src="https://i.stack.imgur.com/aYxso.jpg" alt="EXPECTED HX TABLE"></p>