# Does dbt cloud IDE supports creating Materialized views on BigQuery?

**URL:** https://discourse.getdbt.com/t/does-dbt-cloud-ide-supports-creating-materialized-views-on-bigquery/11054
**Category:** Help
**Tags:** materialization
**Created:** [December 5, 2023, 9:52am UTC](https://discourse.getdbt.com/t/does-dbt-cloud-ide-supports-creating-materialized-views-on-bigquery/11054 "2023-12-05T09:52:24Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![daniel.chiang](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/daniel.chiang/32/3012_2.png) [@daniel.chiang](https://discourse.getdbt.com/u/daniel.chiang)
#### Post date: [December 5, 2023, 9:52am UTC](https://discourse.getdbt.com/t/does-dbt-cloud-ide-supports-creating-materialized-views-on-bigquery/11054/1 "2023-12-05T09:52:24Z")

</div>

I’ve been reading tons of releasing notes as well as [issues](https://github.com/dbt-labs/dbt-bigquery/issues/818) recently. Yet it’s still puzzling to me whether dbt cloud IDE currently supports creating Materialized views on BQ.

I am new to the community and to the dbt per se, so I might be doing this wrong. but I make the config

```auto
{{
  config(
    materialized = "materialized_view",
    partition_by={
      "field": "date",
      "data_type": "DATE",
      "granularity": "day"
      }
  )
}}

```

to the model that I want it to be a MV. I use cloud IDE connected to my BQ, no additional package installed, and the log I got from the failed dbt run is

```auto
07:33:18 Began running node model.my_new_project.dim_daily_revenue
07:33:18 1 of 1 START sql materialized_views model dbt_test.dim_daily_revenue ........... [RUN]
07:33:18 Began compiling node model.my_new_project.dim_daily_revenue
07:33:18 Writing injected SQL for node "model.my_new_project.dim_daily_revenue"
07:33:18 Timing info for model.my_new_project.dim_daily_revenue (compile): 07:33:18.095992 => 07:33:18.114731
07:33:18 Began executing node model.my_new_project.dim_daily_revenue
07:33:18 Timing info for model.my_new_project.dim_daily_revenue (execute): 07:33:18.115668 => 07:33:18.119028
07:33:18 Compilation Error in model dim_daily_revenue (models/core/dim_daily_revenue.sql)
  No materialization 'materialized_views' was found for adapter bigquery! (searched types 'default' and 'bigquery')
07:33:18 1 of 1 ERROR creating sql materialized_views model dbt_test.dim_daily_revenue .. [ERROR in 0.03s]
07:33:18 Finished running node model.my_new_project.dim_daily_revenue

```

---

<div class="post-metadata">

### Author: ![a\_slack\_user](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/a_slack_user/32/1629_2.png) [@a\_slack\_user](https://discourse.getdbt.com/u/a_slack_user)
#### Post date: [December 15, 2023, 9:10am UTC](https://discourse.getdbt.com/t/does-dbt-cloud-ide-supports-creating-materialized-views-on-bigquery/11054/2 "2023-12-15T09:10:08Z")

</div>

you can just look here and check [https://github.com/dbt-labs/dbt-bigquery](https://github.com/dbt-labs/dbt-bigquery)

Note: `@obar1` originally [posted this reply in Slack](https://getdbt.slack.com/archives/CBSQTAPLG/p1702631399525289?thread_ts=1701769965.857449&cid=CBSQTAPLG). It might not have transferred perfectly.

---

<div class="post-metadata">

### Author: ![doug.beatty](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/doug.beatty/32/1940_2.png) [@doug.beatty](https://discourse.getdbt.com/u/doug.beatty)
#### Post date: [July 2, 2024, 4:36pm UTC](https://discourse.getdbt.com/t/does-dbt-cloud-ide-supports-creating-materialized-views-on-bigquery/11054/3 "2024-07-02T16:36:08Z")

</div>

[dbt-bigquery supports materialized views as-of v1.7](https://docs.getdbt.com/reference/resource-configs/bigquery-configs#materialized-views)

There is some example code [here](https://docs.getdbt.com/blog/announcing-materialized-views).