Creating snapshot in a custom location with Trino connector

Help
,
1

Hello. Is that possible to set a custom s3 location for my dbt snapshots? ( Im using iceberg+hive and I don’t want to enable random s3 locations on trino since it’s creating more problems for us in other models)

the location in dbt-trino is usually configured as the following:

{{
  config(
    table_format = 'iceberg',
    materialized = 'table',
    location = "'s3a://bucket/folder'"
  )
}}

It usually works but then I found the following (inside dbt-trino/dbt/include/trino/macros/materializations/snapshot.sql at master · starburstdata/dbt-trino · GitHub)

{% materialization snapshot, adapter='trino' %}
    {% if config.get('properties') %}
        {% if config.get('properties').get('location') %}
            {%- do exceptions.raise_compiler_error("Specifying 'location' property in snapshots is not supported.") -%}
        {% endif %}
    {% endif %}
    {{ return(materialization_snapshot_default()) }}
{% endmaterialization %}

Seems like it blocks this default configuration, the question is - is there a work around for this issue?