Adele Member

Comments

  • We just used regex in the query statement to find yesterdays table via the suffix and pull in all the data from it. REGEXP_CONTAINS(_TABLE_SUFFIX, r'^\d{8}$') AND PARSE_DATE("%E4Y%m%d", _TABLE_SUFFIX) BETWEEN DATE_SUB(CURRENT_DATE(), INTERVAL 1 DAY) AND CURRENT_DATE()
    in Google BigQuery Daily Imports Help Comment by Adele March 2018
Default Avatar