I frequently get BigQuery log entries for these types of errors during Dataform executions.
Even though this error is thrown the table execution completes successfully and is not visible in the Dataform Execution Logs. These errors are thrown seemingly random and occur on multiple tables.
The SQLX config block and SQL is nothing fancy and this error can be thrown on some relatively simple transformations.
I cannot find any documentation on this error.
<table_name> did not meet condition IF_MATCH"
Example config block of the most recent error.
Hi @DataEngineer,
Welcome to Google Cloud Community!
The IF_MATCH issue is most likely a false alert and can be disregarded. It's a condition that doesn't actually affect the outcome of your operation, which is why your table execution completes successfully.
I hope the above information is helpful.
Thanks for the reply.
I wasn't much concerned with the execution as I've seen no evidence of it causing workflow issues. I was more interested in learning why it's happening and how to prevent it, if possible.