Generate Model Yaml not seeing columns, just model name. about dbt-codegen HOT 11 CLOSED

I was experiencing the same bug, and at least for me, it was resolved by a dbt run prior to using generate_model_yaml

from dbt-codegen.

Experienced the same issue using Redshift myself, I figured out a temporary patch that you can clone/use from my fork. The only change I needed to make was in the macro itself, changing the relation variable assignment from:

{% set relation=ref(model_name) %}

to

{% set relation=api.Relation.create(identifier=model_name) %}

@dbeatty10 unsure if this is just a redshift only issue, presumably the ref() function should return a relation object as it is, but I'm starting to cap out my knowledge of the dbt codebase to try an troubleshoot this deeply.

from dbt-codegen.

I also found that generate_base_model has no columns in renamed CTE on BigQuery like the below.

with source as (

    select * from {{ source('foo', 'bar') }}

),

renamed as (

    select

    from source

)

select * from renamed

The operation depends on source to gather column names.

On the other hand, generate_source still works correctly because the macro depends on the API, as @trouze described

So, I think, ref and source cannot collect columns by some reasons.

from dbt-codegen.

Was able to fix this issue by running dbt run --select <model_name> before trying to generate the model's YAML, you sohuld try this !

from dbt-codegen.

So, I had the same issue but on Snowflake. I was missing schema from the source file that we generated, adding it to the source made it work

from dbt-codegen.

I encountered the same issue, running on Redshift.

from dbt-codegen.

Thanks for opening @pkanter! 🙌

And thank you for the helpful affirmations and work arounds @hesterluu, @abhineetgupta, and @trouze 🧠

Based on the experience of @abhineetgupta, I'm wondering if forcing dependencies is needed.

I'm surprised by the experience reported by @trouze -- if the latter works, I'd expect the former to work also.

from dbt-codegen.

Thanks for this report @hiro-o918

Are you also using Redshift? Or a different warehouse?

from dbt-codegen.

Thank you for quick response 🙏
I use BigQuery

from dbt-codegen.

This issue has been marked as Stale because it has been open for 180 days with no activity. If you would like the issue to remain open, please comment on the issue or else it will be closed in 7 days.

from dbt-codegen.

Although we are closing this issue as stale, it's not gone forever. Issues can be reopened if there is renewed community interest. Just add a comment to notify the maintainers.

from dbt-codegen.