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: devoutputs:dev:type: materializethreads: 1host: [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