Package Health Score

81 / 100

security
No known security issues
popularity
Small
maintenance
Healthy
community
Active

Explore Similar Packages

table
46

Popularity

Small

GitHub Stars: 5.81K
Forks: 468
Contributors: 140

Direct Usage Popularity

Based on project statistics from the GitHub repository for the PyPI package dbt-materialize, we found that it has been starred 5,809 times.

Security

No known security issues

Security and license risk for latest version

Release Date: Sep 25, 2024
Direct Vulnerabilities: 0
C
0
H
0
M
0
L
Indirect Vulnerabilities: 0
C
0
H
0
M
0
L
License Risk: 0
H
0
M
0
L

All security vulnerabilities belong to production dependencies of direct and indirect packages.

License

(Apache-2.0 OR BSD-3-Clause OR MIT)

Security Policy

We found a way for you to contribute to the project! Looks like dbt-materialize is missing a security policy.

You can connect your project's repository to Snyk to stay up to date on security alerts and receive automatic fix pull requests.

Keep your project free of vulnerabilities with Snyk

Maintenance

Healthy

Commit Frequency

Open Issues: 0
Open PR: 369
Last Release: 3 months ago
Last Commit: 1 month ago

Further analysis of the maintenance status of dbt-materialize based on released PyPI versions cadence, the repository activity, and other data points determined that its maintenance is Healthy.

We found that dbt-materialize demonstrates a positive version release cadence with at least one new version released in the past 3 months.

In the past month we didn't find any pull request activity or change in issues status has been detected for the GitHub repository.

Community

Active

Readme: Yes
Contributing.md: Yes
Code of Conduct: No
Contributors: 140
Funding: No

A good and healthy external contribution signal for dbt-materialize project, which invites more than one hundred open source maintainers to collaborate on the repository.

We found a way for you to contribute to the project! Looks like dbt-materialize is missing a Code of Conduct.

Embed Package Health Score Badge

Keep your project healthy

Check your requirements.txt

Ensure all the packages you're using are healthy and well-maintained

Snyk Vulnerability Scanner

Get health score & security insights directly in your IDE

Package

Python Versions Compatibility: Unspecified

Age: 4 years
Latest Release: 3 months ago
Dependencies: N/A
Versions: 51
Maintainers: 0
Wheels: No

Readme

dbt-materialize

dbt adapter for Materialize.

For a complete step-by-step guide on how to use dbt and Materialize, check the documentation.

Installation

dbt-materialize is available on PyPI. To install the latest version via pip (optionally using a virtual environment), run:

python3 -m venv dbt-venv                  # create the virtual environment
source dbt-venv/bin/activate              # activate the virtual environment
pip install dbt-core dbt-materialize      # install dbt-core and the adapter

Requirements

dbt-materialize requires Materialize v0.68.0+.

Configuring your profile

To connect to a Materialize instance, use the reference profile configuration in your connection profile:

dbt-materialize:
  target: dev
  outputs:
    dev:
      type: materialize
      threads: 1
      host: [host]
      port: [port]
      user: [user@domain.com]
      pass: [password]
      dbname: [database]
      schema: [dbt schema]
      cluster: [cluster] # default 'quickstart'
      sslmode: require
      keepalives_idle: 0 # default 0
      retries: 1  # default 1 retry on error/timeout when opening connections
      search_path: [optional, override the default search_path]

Complete sample profiles can be found in sample_profiles.yml.

Supported Features

Materializations

Type	Supported?	Details
`source`	YES	Creates a source.
`view`	YES	Creates a view.
`materializedview`	YES	(Deprecated) Creates a materialized view.
`materialized_view`	YES	Creates a materialized view. The `materializedview` legacy materialization name is supported for backwards compatibility.
`table`	YES	Creates a materialized view. (Actual table support pending #5266.)
`sink`	YES	Creates a sink.
`ephemeral`	YES	Executes queries using CTEs.
`incremental`	NO	Use the `materialized_view` materialization instead! dbt's incremental models are valuable because they only spend your time and money transforming your new data as it arrives. Luckily, this is exactly what Materialize's materialized views were built to do! Better yet, our materialized views will always return up-to-date results without manual or configured refreshes. For more information, check out our documentation.

Indexes

Use the indexes option to define a list of indexes on source, view, table or materialized view materializations. Each Materialize index can have the following components:

Component	Value	Description
`columns`	`list`	One or more columns on which the index is defined. To create an index that uses all columns, use the `default` component instead.
`name`	`string`	The name for the index. If unspecified, Materialize will use the materialization name and column names provided.
`cluster`	`string`	The cluster to use to create the index. If unspecified, indexes will be created in the cluster used to create the materialization.
`default`	`bool`	Default: `False`. If set to `True`, creates a default index that uses all columns.

Additional macros

We provide a materialize-dbt-utils package with Materialize-specific implementations of dispatched macros from dbt-utils. To use this package in your dbt project, check the latest installation instructions in dbt Hub.

Hooks

Supported.

Custom Schemas

Supported. Custom schemas in dbt might behave differently than you'd expect, so make sure to read the documentation!

Sources

You can instruct dbt to create a dbt source in Materialize using the custom source materialization, which allows for injecting the complete source statement into your .sql file.

source freshness is not supported because using Materialize, your sources will always be fresh.

Documentation

dbt docs is supported, as well as --persist-docs.

Testing

dbt test is supported.

If you set the optional --store-failures flag or store-failures config, dbt will save the results of a test query to a materialized_view. To use a view instead, use the store_failures_as config.

These objects will be created in a schema suffixed or named dbt_test__audit by default. Change this value by setting a schema config. If both store_failures and store_failures_as are specified, store_failures_as takes precedence.

Snapshots

Not supported. Support is not planned for the near term.

Contributors

A huge thank you to Josh Wills, who created the original version of this adapter. 🤠

FAQs

What is dbt-materialize?

The Materialize adapter plugin for dbt. Visit Snyk Advisor to see a full health score report for dbt-materialize, including popularity, security, maintenance & community analysis.

Is dbt-materialize popular?

The python package dbt-materialize receives a total of 974 weekly downloads. As such, dbt-materialize popularity was classified as small. Visit the popularity section on Snyk Advisor to see the full health analysis.

Is dbt-materialize well maintained?

We found that dbt-materialize demonstrated a healthy version release cadence and project activity. It has a community of 140 open source contributors collaborating on the project. See the full package health analysis to learn more about the package maintenance status.

Is dbt-materialize safe to use?

The python package dbt-materialize was scanned for known vulnerabilities and missing license, and no issues were found. Thus the package was deemed as safe to use. See the full health analysis review.

Last updated on 21 December-2024, at 08:26 (UTC).

Build a secure application checklist

Select a recommended open source package

Minimize your risk by selecting secure & well maintained open source packages

DONE

Scan your app for vulnerabilities

Scan your application to find vulnerabilities in your: source code, open source dependencies, containers and configuration files

SCAN NOW

Fix identified vulnerabilities

Easily fix your code by leveraging automatically generated PRs

AUTO FIX

Monitor for new issues

New vulnerabilities are discovered every day. Get notified if your application is affected

MONITOR APP