Transaction management

Using post_hook to log the audit information in my databricks process. If the post hook fails due to any exception scenario, is it possible rollback the main model transaction?
i.e is it possible to perform SQL in the model and post hook as single transaction?