How to enable multi-statement queries for snowflake connections?

Queries and Resources
1

I'm trying to run a transaction in snowflake's query. Transactions are by nature are multi-statement. Whenever I run a multi-statement query I'm getting error:

error:"Actual statement count 7 did not match the desired statement count 1."

the query itself is pretty simple

BEGIN TRANSACTION;
SET CUSTOMER_ID = customer_seq.nextval;

INSERT INTO settings_customers (
    CUSTOMER_ID, CUSTOMER_NAME, TENANT_ID, SCHEMA_NAME, VAT_NUMBER, EMAIL, PHONE, CUSTOMER_STATUS, CUSTOMER_TYPE, SYNC_FREQUENCY, REPORT_GRANULARITY, CREATED_DATE, CREATED_BY, UPDATED_DATE
)
VALUES (
  $CUSTOMER_ID,
  {{ customer_name }} ,
  {{ tenant_id }} ,
  {{ schema_name }}, {{ vat_number }}, {{ email }}, {{ phone }}, {{ customer_status }}, {{ customer_type }}, {{ sync_frequency }}, {{ report_granularity }}, CURRENT_TIMESTAMP, {{ created_by }}, CURRENT_TIMESTAMP
);
SELECT $CUSTOMER_ID;
COMMIT;

Snowflake itself allows multi-statement queries. This is retool issue. How to solve it? Can it be configured somewhere? Any workarounds?