Problem with materializing my models

[LeonSGH]

Hi Guys,

I am currently trying to setup dbt with a locally hosted oracle, but have problems materializing my models. As far as I understand you can set this option either in the sql, the model or the dbt_project itself. The problem ist, that neither of these configurations work for me. For my models it always just creates a view in the database. On the other hand seeds are created as a table, so I assume there is no problem with the privileges of the database user.

Do you have any idea of why my models are always created views? Is there a problem with the adapter/ adapter settings?

Best Regards Leon

[aosingh]

Hi @LeonSGH

Let me check, Could you share your model configuration ? Also, please share the dbt logs with --debug option enabled. This will help me understand the cause.

Sorry for the delayed response. Somehow, I don't get notifications for discussions. I recommend creating an issue here https://github.com/oracle/dbt-oracle/issues

[LeonSGH]

Hi @aosingh,

thank you for your reply and taking a look into it. I have created an issue here: #178

If you need any other information about my setup, feel free to let me know.

Best regards Leon