Error: Serialization Isolation Violation on Table

Issue

While scheduling a transformation, the following error appears:

There may be errors that need to be addressed before the transformation can successfully run: java.sql.SQL.Exception: \[Amazon\](500310) Invalid operation: 1023 Details: Serializable isolation violation on table.

Environment

Transformation on Redshift

Resolution

This error appears when you schedule the transformation during a time that interferes with Fivetran sync queries on that table.

To solve this issue, schedule the transformation queries after the Fivetran sync or when Fivetran is not due to sync this table.

Cause

We receive this error from Redshift when we try to access and run a query against a table while another query runs on the same table. Concurrent transactions are invisible to each other. They cannot detect each other's changes. As a result, Redshift doesn't allow such transactions.