[Spark] Temporary tables created in default schema instead of configured schema

[ahurducas]

Describe the bug
When running dbt run --select elementary with Spark (Hive), Elementary attempts to create temporary tables (e.g., dbt_models__tmp_...) in the default schema instead of using the schema specified in dbt_project.yml. This causes a permission error because the user doesn't have CREATE privileges on the default database.

To Reproduce

1. Configure Elementary in dbt_project.yml with a custom schema:

   models:
     elementary:
       +schema: elementary
       +file_format: "iceberg"

2. Run dbt run --select elementary
3. Observe that temporary tables are created in default schema instead of elementary

Expected behavior
All Elementary tables, including temporary/intermediate tables (__tmp_...), should be created in the configured schema (elementary), not in the default schema.

Environment:

• Elementary CLI (edr) version: N/A
• Elementary dbt package version: 0.23.0
• dbt version you're using: 1.9.2
• Data warehouse: Spark (Hive Metastore)
• Infrastructure details: Hive with permission restrictions on default database

Additional context
Error log:

Runtime Error in model dbt_models (models/edr/dbt_artifacts/dbt_models.sql)
  Runtime Error
    Error while executing query: org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message:Permission denied: user [myuser] does not have [CREATE] privilege on [default/dbt_models__tmp_20260320073326791798])

The issue appears to be that the __tmp_ table creation logic doesn't inherit or respect the schema configuration, defaulting to default instead.

Would you be willing to contribute a fix for this issue?
Yes

[github-actions]

This issue is stale because it has been open for too long with no activity.
If you would like the issue to remain open, please remove the stale label or leave a comment.