Skip to content

Instantly share code, notes, and snippets.

@eyadsibai

eyadsibai/_.sql

Created July 28, 2020 13:17
Show Gist options
  • Save eyadsibai/408da72a41b8c1a002e4b57c65ac02c7 to your computer and use it in GitHub Desktop.
Save eyadsibai/408da72a41b8c1a002e4b57c65ac02c7 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. eyadsibai created this gist Jul 28, 2020.
    1 change: 1 addition & 0 deletions _.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1 @@
    WHERE _PARTITIONTIME >= TIMESTAMP(DATE_SUB(@run_date, INTERVAL 1 DAY)) AND _PARTITIONTIME < TIMESTAMP(DATE_SUB(@run_date, INTERVAL 0 DAY))