Certain core functionality may vary. If you would like to report a bug, request a feature, or contribute, you can check out the linked repository and open an issue.
Overview of dbt-materialize
Maintained by: Materialize, Inc.
Core version: v0.18.1 and newer
The easiest way to install is to use pip:
pip install dbt-materialize
Connecting to Materialize with dbt-materialize
The dbt profile for Materialize is nearly identical to the profile configuration for Postgres:
dbt-materialize:target: devoutputs:dev:type: materializethreads: 1host: [host]port: [port]user: [user]pass: [password]dbname: [database]schema: [name of your dbt schema]
|view||YES||Creates a view.|
|materializedview||YES||Creates a materialized view.|
|table||YES||Creates a materialized view. (Actual table support pending #5266)|
|ephemeral||YES||Executes queries using CTEs.|
|incremental||NO||Use the |
dbt seed will create a static materialized view from a CSV file. You will not be able to add to or update this view after it has been created. If you want to rerun
dbt seed, you must first drop existing views manually with