Unable to use post_hook after_commit

[ericmuijs]

{{ 
    config(
        materialized='table', 
        unique_key='pk_project',
        as_columnstore=false,
        post_hook=after_commit("SELECT 1")
    ) 
}}

Running with the above config, simplest SQL code for a post hook, I get an error:

('25000', '[25000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (3902) (SQLExecDirectW)')

Adding after_commit seems to execute an empty "commit;" to the database. Do I have my setup wrong?

Thanks in advance.

[ryanmeekins]

Related to this issue, I'm trying to create an index on a table model with name pk_<model_name> using a post_hook, however, after every other dbt build, this model fails saying that the index already exists. It looks like the existing table is renamed to <model_name>__dbt_backup and this table still contains the index with name pk_<model_name>. I could likely fix this by running the post_hook via after_commit, however, getting the same issue as mentioned here.