Materialize Profile

Vendor-supported plugin

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.
Source: Github
Core version: v0.18.1 and newer
dbt Cloud: Not Supported
dbt Slack channel Link to channel

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:

profiles.yml

dbt-materialize:
  target: dev
  outputs:
    dev:
      type: materialize
      threads: 1
      host: [host]
      port: [port]
      user: [user]
      pass: [password]
      dbname: [database]
      schema: [name of your dbt schema]

Supported Features

Materializations

Type	Supported?	Details
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 materializedview materialization instead. Materialized views will always return up-to-date results without manual or configured refreshes. For more information, check out Materialize documentation.

Seeds

Running 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 drop view.

Resources

• Get started using dbt and Materialize together
• Materialize docs about dbt