dbt python model to configure as view

The problem I’m having is I can’t configure dbt python model as view.

import snowflake.snowpark.functions as F

def model(dbt, session):
   dbt.config(materialized="view")
   df = dbt.ref("sample")

   return df

Facing Error when ran the model

 Materialization "materialization_view_snowflake" only supports languages ['sql']; got "python"

So my understanding is we can’t materialize model as view using dbt-python model

Currently you can’t materialize dbt python models as views, only table and incremental

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.