Change the tmp table name while doing incremental in dbt snowflake

Help
,
1

The problem I’m having

Database used - Snowflake Adapters
I have created a model with incremental config and it uploads files from s3 to a table suppose LND_TABLES.
Now with internal working of dbt it tends to create a temp table with same name.
If I have 4 files in s3 and I want to do it in parallel, I have to change the temp table name. Is there any way I could customise the tmp table suffix in dbt snowflake adapter?

The context of why I’m trying to do this

What I’ve already tried

Some example code or error messages

Put code inside backticks
  to preserve indentation
    which is especially important 
      for Python and YAML!
2

In dbt with Snowflake, the temporary table names are auto-generated during the incremental model process, and currently, there’s no built-in way to modify the suffix through configurations.

Instead of modifying the temp table name, consider defining a custom schema per process run using generate_schema_name in dbt_project.yml.

If your main concern is managing concurrent loads, setting on_schema_change=‘append’ in the incremental config might help avoid conflicts.