A historical revenue report changed after late corrections. Delta table history still retains version 42, which was used by the original report. Which query best isolates the change while keeping the report logic constant?

Published
  1. Run the original query against the table VERSION AS OF 42, then compare it with the current version
  2. Use DESCRIBE HISTORY as the revenue report
  3. Rerun the current query after clearing its result cache
  4. Add ORDER BY revenue to the current query

Comments — 0