The batch_id generated from the system is a text generated value, I would not recommend using this to look for a batch which has been ingested. I would recommend using the rank function and partition by fields to look at data which has been ingested over times within the datalake. rank() OVER(PARTI...