How to use Incremental models when adapter doesn't support view?

Help
1

Hi, everyone:

I use dbt with trino adapter, some trino’s data source does not support view in trino. So if I build a “Incremental model” on such a data source, it will fail because dbt use view to achieve it.
How can I build the Incremental model in this situation?

Thanks a lot!

2

I modify the source code to use table for such a situation. It works, but has performance issue. And the iceberg community is working on view supporting. I’ll track on it…
And some other suggestion?

Thanks!