-
Notifications
You must be signed in to change notification settings - Fork 56
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
DBT Trino - Connector doesn't support view #451
Comments
For the incremental strategies If your connector doesn't support views, set the |
Thanks @damian3031 As per this link, it is supporting materialized view, but if I run it is throwing an error like this connector doesn't support materialized view. Since we use postgres database it doesn't support view in Parquet format. It will be really helpful, if you help us to solve this. |
@vignesh-clustrex You mixed up |
@damian3031 First I was running dbt model as incremental, at that time I got this error This connector doesn't support view. As per your comment I have set Now when I change running dbt model with config materialized view , its throwing an error like this connector doesn't support materialized view. |
This issue is related to the underlying trino connector, not dbt-trino itself. Please refer to the connector documentation and/or check for relevant issues, or create a new one in https://github.com/trinodb/trino repository. |
Expected behavior
I am using dbt-trino adapter to run dbt models, When I run model as incremental it is throwing an error like
This connector doesn't support view, why is creating view ?
I need it as table
Actual behavior
create or replace view\n "postgresql"."schema"."example_model__dbt_tmp"\n security definer\n
Steps To Reproduce
I am runnig dbt model using dbt run command, with incremental config
Log output/Screenshots
No response
Operating System
windows
dbt version
1.8.8
Trino Server version
465
Python version
3.12
Are you willing to submit PR?
The text was updated successfully, but these errors were encountered: