Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2025 04:06 AM
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.