Doug Beatty

Thanks for reporting this @rbs392 and providing a nice example @rbs392 👍 I was able to reproduce what you described using dbt-duckdb, and I've included a reproduction case for each...

@rbs392 We don't have any timeline for this. In the meantime, we'd suggest using the workaround you identified. ### Workaround Add the `materialized` config into the model-level configuration with the...

This might have the same root cause as https://github.com/dbt-labs/dbt-core/issues/8520, and it might be resolved by https://github.com/dbt-labs/dbt-core/pull/8538

Thanks for your PR in https://github.com/dbt-labs/dbt-core/pull/8538 @devmessias ! We've got it queued up for an initial code review.

Thanks for reporting this @PiotrBB ! Agreed that the problem is the way the CTE is being named, and the solution is likely to be either: - quoting the CTE...

Thanks for reporting this @edgarrmondragon ! It looks like the conversion here that this might be [limited to the `dbt-duckdb` adapter](https://github.com/duckdb/dbt-duckdb/issues/448#issuecomment-2392632384) and fixed in https://github.com/duckdb/dbt-duckdb/pull/451? If not, can you share...

@edgarrmondragon I'm going to close this (and the associated PR https://github.com/dbt-labs/dbt-core/pull/10809) with the assumption that https://github.com/duckdb/dbt-duckdb/issues/448#issuecomment-2392632384 was fixed in https://github.com/duckdb/dbt-duckdb/pull/451. If this is still an issue, please open a new...

See https://github.com/dbt-labs/dbt-core/issues/10822#issuecomment-2521842260

Thanks for reporting this @njrs92 ! Yes, I see what you are saying about a [programmatic invocations](https://docs.getdbt.com/reference/programmatic-invocations) Python script executing twice when the name of the script starts with `dbt_`....

@jeancochrane with the latest version of https://github.com/dbt-labs/dbt-adapters/pull/236, do we need this PR in dbt-core anymore?