Did you ever succeed in getting this to run?

Im using dbt 1.8.9 sql server 1.8.4

Snapshot table and model are in different databases on the same server, running with no snapshot table existing works.

Running as a db user with db_owner access works, even after the table is already created.

Delete the table, run as a service account, it succeeds.

Run again as the service account and sql server returns a permissions error (table already exists error.)

Cannot figure out what sql server permission the service account is missing.