eyadsibai/_.sql

Created July 28, 2020 13:17

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/eyadsibai/408da72a41b8c1a002e4b57c65ac02c7.js"></script>
Save eyadsibai/408da72a41b8c1a002e4b57c65ac02c7 to your computer and use it in GitHub Desktop.

Download ZIP

schedule BigQuery on a daily basis

Raw

_.sql

WHERE _PARTITIONTIME >= TIMESTAMP(DATE_SUB(@run_date, INTERVAL 1 DAY)) AND _PARTITIONTIME < TIMESTAMP(DATE_SUB(@run_date, INTERVAL 0 DAY))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment