How to get Batch_Run_ID with google sheets?
Hallo, I am looking for a solution to a problem where I need to compare data from today with yesterday's. But the date column is not provided in the data. Also, google sheets does not get batch run id and date. So I have no reference point to compare data. I tried recursive data modelling, but could not solve the problem. Could somebody please give me some idea to reach the solution for this problem? I just need to get some reference point on ETL level to compare data for two consecutive days. Thanks.