I want to update a dimension table in the gold model from a silver table by using  create_auto_cdc_from_snapshot_flow and SCD2. In the target table, I have defined an IDENTITY column, which should be populated automatically.

The dlt flow runs successfully, but then all the values in the identity column are NULLs. Why?!