[Snowflake adapter] Supports transactions (pre-hook + model run in same transaction?)

Help
1

As per docs suggest only Postgres or Redshift adapters support transactions (meaning pre-hook(s) run in same transaction as model).

  1. So i wonder if Snowflake adapter as-of today 5-OCT-2024 still doesnt support it?
  2. where can i find a web page listing adapters vs transaction support (yes| no column for different target databases?

Thanks~

2

Here some test code I prepared, if anyone could test this:

--dbt-snowflake adapter test transaction support (pre-hook, post-hook + model run in same transaction).sql


delete from db.s.stg_table;


create or replace temporary table db.s.stg(id number);
create or replace temporary table db.s.control(batch_id number, s varchar(10));


--================================================================================================--
--test 1 - a successful pre-hook

--pre-hook:
{{ config(
    pre_hook="delete from db.s.stg_table" | "insert into db.s.control (select '1', 'started..')",
    post_hook="insert into db.s.control (select '1', 'completed!')",
) }}

--model:
insert into db.s.stg_table (select * from values (10),(20));
---------------------------------------------------------------------------


--after dbt run both tables should show:
select * from db.s.control;
BATCH_ID|S         |
--------+----------+
       1|started.. |
       1|completed!|

select * from db.s.stg_table;
ID|
--+
10|
20|




--================================================================================================--
--test 2 - force error on pre-hook (giving varchar too long for example)
--         stg_table should not be deleted if snowflake adapter supports transactions!!!!

--pre-hook:
{{ config(
    pre_hook="delete from db.s.stg_table" | "insert into db.s.control (select '2', 'started.. **OOPS TOO BIG VARCHAR ON PRE-HOOK')",
    post_hook="insert into db.s.control (select '1', 'completed!')",
) }}

--model:
insert into db.s.stg_table (select * from values (33);
---------------------------------------------------------------------------


--after dbt run both tables should noe have been affected, meaning they should show same rows as after 1st test:
select * from db.s.control;
BATCH_ID|S         |
--------+----------+
       1|started.. |
       1|completed!|

select * from db.s.stg_table;
ID|
--+
10|
20|




--================================================================================================--
--test 3 - force error on post-hook (giving varchar too long for example)
--         stg_table should not be deleted if snowflake adapter supports transactions!!!!

--pre-hook:
{{ config(
    pre_hook="delete from db.s.stg_table" | "insert into db.s.control (select '2', 'started..')",
    post_hook="insert into db.s.control (select '1', 'completed!  **OOPS TOO BIG VARCHAR ON POST-HOOK!!!!')",
) }}

--model:
insert into db.s.stg_table (select * from values (33);
---------------------------------------------------------------------------


--again, after dbt run both tables should noe have been affected, meaning they should show same rows as after 1st test:
select * from db.s.control;
BATCH_ID|S         |
--------+----------+
       1|started.. |
       1|completed!|

select * from db.s.stg_table;
ID|
--+
10|
20|

Thanks ~