Vacation Rentals

Run Full Refresh Process:

Move Data from Google Sheets -> tradingplaces_temp table

• Empty tradingplaces_temp table
• Move Google Sheets Data (lambda) -> tradingplaces_temp table

Archive and populate new listings

• Move data from listings table to listings_archive
  Empty listings table
  Move (and transform) data from trandingplaces_temp to listings

Cleanup & Wrap up:

• Clear google sheet (leaving just the header row)
• Send Notification Email