# \#views

**URL:** https://discourse.getdbt.com/tag/views/92.md

[Latest](https://discourse.getdbt.com/latest.md) · [Categories](https://discourse.getdbt.com/categories.md) · [Tags](https://discourse.getdbt.com/tags.md)

---

## [BigQuery tables or views to expose data?](https://discourse.getdbt.com/t/bigquery-tables-or-views-to-expose-data/20198)

<div class="topic-metadata">

**Author:** [@Etiennr](https://discourse.getdbt.com/u/Etiennr)\
**Replies:** 1\
**Last updated:** [September 8, 2025, 8:00am UTC](https://discourse.getdbt.com/t/bigquery-tables-or-views-to-expose-data/20198 "2025-09-08T08:00:06Z")

</div>

Hey everyone :wave: I am wondering if you use tables or views to expose data in BigQuery, and if so why? 1) Context We use dbt + BigQuery in a data mesh setup, where our data products expose one or multiple public data…

---

## [How to deal with a SQL which creates a view itself](https://discourse.getdbt.com/t/how-to-deal-with-a-sql-which-creates-a-view-itself/19849)

<div class="topic-metadata">

**Author:** [@xpegenaute](https://discourse.getdbt.com/u/xpegenaute)\
**Replies:** 0\
**Last updated:** [July 14, 2025, 1:14pm UTC](https://discourse.getdbt.com/t/how-to-deal-with-a-sql-which-creates-a-view-itself/19849 "2025-07-14T13:14:48Z")

</div>

Hi, I am using Vertica DB and I have a SQL table. I want to normalize \[1\] some columns. The problem is that the NORMALIZE () function already creates a view. I would like to know how I should treat this in dbt scenario. …

---

## [Redshift error: External tables are not supported in views](https://discourse.getdbt.com/t/redshift-error-external-tables-are-not-supported-in-views/17287)

<div class="topic-metadata">

**Author:** [@santosh2k2](https://discourse.getdbt.com/u/santosh2k2)\
**Replies:** 0\
**Last updated:** [December 10, 2024, 10:00am UTC](https://discourse.getdbt.com/t/redshift-error-external-tables-are-not-supported-in-views/17287 "2024-12-10T10:00:43Z")

</div>

Problem Getting error while building model to create view… reading data from redshift spectrum. I thought dbt\_external\_tables package will be able to help … and made changes accordingly … but no luck… Any guidance wil…

---

## [Unable to materialize models to views running on Oracle](https://discourse.getdbt.com/t/unable-to-materialize-models-to-views-running-on-oracle/16582)

<div class="topic-metadata">

**Author:** [@Denys](https://discourse.getdbt.com/u/Denys)\
**Replies:** 0\
**Last updated:** [October 14, 2024, 9:44am UTC](https://discourse.getdbt.com/t/unable-to-materialize-models-to-views-running-on-oracle/16582 "2024-10-14T09:44:24Z")

</div>

Hi, I have a dbt project that runs on a dockerized Oracle DB (doctorkirk/oracle-19c). I tend to use CTEs in my models. The problem I’m having When materialization strategy is view (implicitly or explicitily), models fa…

---

## [Tactics for dbt tests running on views](https://discourse.getdbt.com/t/tactics-for-dbt-tests-running-on-views/12769)

<div class="topic-metadata">

**Author:** [@kshysiek](https://discourse.getdbt.com/u/kshysiek)\
**Replies:** 1\
**Last updated:** [April 5, 2024, 12:53pm UTC](https://discourse.getdbt.com/t/tactics-for-dbt-tests-running-on-views/12769 "2024-04-05T12:53:43Z")

</div>

The problem I’m having Tests in our data warehouse take a lot of time. I discovered that it models materialized as views take a long time to be tested. I assume that for each test all the data must be collected. When I …

---

## [create view with two part identifiers instead of 3](https://discourse.getdbt.com/t/create-view-with-two-part-identifiers-instead-of-3/7292)

<div class="topic-metadata">

**Author:** [@annamalai](https://discourse.getdbt.com/u/annamalai)\
**Replies:** 1\
**Last updated:** [March 29, 2024, 12:00am UTC](https://discourse.getdbt.com/t/create-view-with-two-part-identifiers-instead-of-3/7292 "2024-03-29T00:00:56Z")

</div>

The problem I’m having VIEWS (materialization) are created with 3 part identifiers. Example of a dbt compiled code sql: create view "schema\_name"."view\_name" as select ......... from "\*\*database\_name\*\*"."schema\_name".…

---

## [Redshift view deadlocks?](https://discourse.getdbt.com/t/redshift-view-deadlocks/7179)

<div class="topic-metadata">

**Author:** [@FredNunes](https://discourse.getdbt.com/u/FredNunes)\
**Replies:** 3\
**Last updated:** [March 14, 2023, 5:05am UTC](https://discourse.getdbt.com/t/redshift-view-deadlocks/7179 "2023-03-14T05:05:30Z")

</div>

Hi everyone, I am running into an issue with Redshift and would appreciate any suggestions. I am creating some views on redshift using dbt. One of the in particular controls the row level access per user, so all models …

---

## [big query Materialized view](https://discourse.getdbt.com/t/big-query-materialized-view/5787)

<div class="topic-metadata">

**Author:** [@minhajpasha](https://discourse.getdbt.com/u/minhajpasha)\
**Replies:** 1\
**Last updated:** [July 21, 2023, 8:11am UTC](https://discourse.getdbt.com/t/big-query-materialized-view/5787 "2023-07-21T08:11:30Z")

</div>

Hello I followed the instructions given in below: I have copy/pasted \[installation via files COPY\] 1 adapters.sql 2 materalized\_view.sql from bigquery folder \[as my dwh is BQ\] Below is my model(customers.sql) {{ …

---

## [dbt {materialized = "view"} creates a table in the database](https://discourse.getdbt.com/t/dbt-materialized-view-creates-a-table-in-the-database/7876)

<div class="topic-metadata">

**Author:** [@EranK](https://discourse.getdbt.com/u/EranK)\
**Replies:** 2\
**Last updated:** [April 19, 2023, 12:32pm UTC](https://discourse.getdbt.com/t/dbt-materialized-view-creates-a-table-in-the-database/7876 "2023-04-19T12:32:17Z")

</div>

Trying to understand dbt Materialization strategies - Some of our models are using the {materialized = “view”} option, and still I see that an underlying table is created in the database (We are using AWS Redshift) dbt…