big query Materialized view

minhajpasha · December 20, 2022, 6:56pm

Hello

I followed the instructions given in below:

dbt-labs/dbt-labs-experimental-features/blob/main/materialized-views/README.md

## dbt_labs_materialized_views

`dbt_labs_materialized_views` is a dbt project containing materializations, helper macros, and some builtin macro overrides that enable use of materialized views in your dbt project. It takes a conceptual approach similar to that of the existing `incremental` materialization:
- In a "full refresh" run, drop and recreate the MV from scratch.
- Otherwise, "refresh" the MV as appropriate. Depending on the database, that could require DML (`refresh`) or no action.

At any point, if the database object corresponding to a MV model exists instead as a table or standard view, dbt will attempt to drop it and recreate the model from scratch as a materialized view.

Materialized views vary significantly across databases, as do their current limitations. Be sure to read the documentation for your adapter.

If you're here, you may also like the [dbt-materialize](https://github.com/MaterializeInc/materialize/tree/main/misc/dbt-materialize) plugin, which enables dbt to materialize models as materialized views in [Materialize](https://materialize.io/).

## Setup

### General installation:

You can install the materialized-view funcionality using one of the following methods.

- Install this project as a package ([package-management docs](https://docs.getdbt.com/docs/building-a-dbt-project/package-management))
  - [Local package](https://docs.getdbt.com/docs/building-a-dbt-project/package-management#local-packages): by referencing the [`materialized-views`](https://github.com/dbt-labs/dbt-labs-experimental-features/tree/master/materialized-views) folder.

This file has been truncated. show original

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)
{{
config(materialized=‘materialized_view’,
auto_refresh = true,
)
}}

select * from stg_customers;

when iam running : dbt run --select customers iam getting below error.

18:42:20 Compilation Error in macro materialization_materialized_view_bigquery (macros/materialized-views/big_query/materalized_view.sql)
18:42:20 ‘dbt_labs_materialized_views’ is undefined

Can you please help me on this

Regards
Minhaj Pasha

kedar.k · July 21, 2023, 8:11am

Hi,

Did you find any solution for this?

Topic		Replies	Views
Pivoting and Incremental Materializations Show and Tell dbt-utils , incremental	0	6312	August 22, 2019
BigQuery + dbt: Incremental Changes Archive	8	34541	June 19, 2020
snapshots and incremental models implementation in dbt with Bigquery Help snapshots , incremental , bigquery	2	904	February 13, 2023
Enquiry on incremental materialisation Help incremental	4	1223	November 30, 2022
Handling BigQuery Incremental __dbt_tmp tables Help incremental , best-practice , bigquery	2	3417	March 29, 2023

big query Materialized view

Related Topics