I have 2 java cron jobs which runs on different intervals to perform some operations and also delete and update a common big-query table. There are some cases when both the jobs run at same time, try to delete/update the common table, resulting in failure of any one of the jobs.
Is there a concept like locking or some other way in big-query, so that once a job starts updating a table, the other job just wait for the operation to get completed.