SP_6721
Honored Contributor II

Hi @Dimitry ,

The issue you're seeing is due to delta.enableRowTracking = true. This feature adds hidden _metadata columns, which serverless compute doesn't support, that's why the MERGE fails there.

Try this out:

  • You can disable row tracking with:
    ALTER TABLE shopify.stock.location2
    SET TBLPROPERTIES (delta.enableRowTracking = false);

Alternatives:

  • Keep delta.enableChangeDataFeed = true, it works on both compute types.
  • Use a SQL warehouse (non-serverless) if you need row tracking for that operation.
  • Or, consider using Change Data Feed instead of row tracking for audit/logging needs.

View solution in original post