[Feature] Control glue database/schema for tmp tables generated by incremental models

[nicor88]

Is this your first time submitting a feature request?

• I have searched the existing issues, and I could not find an existing issue for this feature

Describe the feature

In case of incremental models tmp tables I would like to have control where the tmp table is going to be written.
It will be nice to have an additional parameter tmp_schema or schema_tmp that can be used in case of tmp tables.
Ideally those tmp tables are written in place not exposed to final users, that's why having control on such schema/glue db make sense.
If we take in mind also Lakeformation permissions make even more sense.

Describe alternatives you've considered

No response

Who will this benefit?

Use that don't want to expose tmp tables to final users that query their data-platform.

Are you interested in contributing this feature?

No response

Anything else?

No response

[nicor88]

Covered by #659