search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.53k stars 3.03k forks source link

Trino supports materialized views ? #24304

Closed vignesh-clustrex closed 2 days ago

vignesh-clustrex commented 2 days ago

If trino supports materialized views, why do I get error when running dbt models using dbt-trino,

Error : This connector doesn’t support materialized_views

Any thoughts on this ?

mosabua commented 2 days ago

Only the Iceberg connector supports materialized views. Every connectors supports different operations to some degree and you can find out more from the documentation.

https://trino.io/docs/current/connector/iceberg.html#sql-support