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.