Hi everyone!
We have a data transfer pipeline (google ads → google bigquery) set.
Everything was working fine until a couple of days ago when the employee who used to take care of it parted ways with us and his credentials stopped working.
We didn’t realize about it until today and, when we did, we restored the connection with another set of credentials.
Everything seems to be working fine now except for a couple of days where there are no data for.
Despite running scheduled backfills for those dates and retrying failed jobs (results for both things were successful), data for those 2 days when credentials were failing don’t seem to be being populated (there is nothing with _DATA_DATE BETWEEN <yesterday> AND <the_day_before> -obviously using placeholder here- ).
We rely on those data to build a couple of reports we use, so data for those dates are missing in our reports and causing us some pain.
I am quite new to GBQ and GCP so I may be getting things wrong, but I supposed _DATA_DATE populated with the date coming from the source data (meaning it would populate with yesterday’s date if I schedule a backfill for yesterday’s data). Is that so?
Any help here would be much appreciated!