Skip to main content

dbt-coves

PyPI version fury.io PyPI - Python Version Build

Brought to you by Datacoves

Datacoves

dbt-coves automates the tedious parts of dbt development. Datacoves takes it further: a managed DataOps platform for dbt and Airflow, deployable in your private cloud or available as SaaS.

  • Private cloud or SaaS – your data, your choice
  • Managed dbt + Airflow – production-ready from day one
  • In-browser VS Code – onboard developers in minutes
  • Bring your own tools – integrates with your existing stack, no lock-in
  • AI-assisted development – connect your organization's approved LLM (Anthropic, OpenAI, Azure, Gemini, and more)
  • Built-in governance – CI/CD, guardrails, and best practices included

dbt-coves is the power tools. Datacoves is the workshop.

Explore the platform →

Overview

image

Table of contents

Introduction

dbt-coves is a CLI tool that automates and simplifies development and release tasks for dbt.

In addition to other functions listed below, dbt-coves generates dbt sources, staging models and property(yml) files by analyzing information from the data warehouse and creating the necessary files (sql and yml). It can even generate Airflow DAGs based on YML input.

Finally, dbt-coves includes functionality to bootstrap a dbt project and to extract and load configurations from data-replication providers.

Installation

pip install dbt-coves

We recommend using python virtualenvs and create one separate environment per project.

Supported dbt versions

Version Status
< 1.0 ❌ Not supported
>= 1.0 ✅ Tested

From dbt-coves 1.4.0 onwards, our major and minor versions match those of dbt-core. This means we release a new major/minor version once it's dbt-core equivalent is tested. Patch suffix (1.4.X) is exclusive to our continuous development and does not reflect a version match with dbt.

Supported dbt adapters

Feature Snowflake Redshift BigQuery
source model (sql) generation ✅ Tested ✅ Tested ✅ Tested
model properties (yml) generation ✅ Tested ✅ Tested ✅ Tested

NOTE: Other database adapters may work, although we have not tested them. Feel free to try them and let us know so we can update the table above.

Usage

dbt-coves, supports the following functions:

  • dbt: run dbt commands in CI and Airflow environments.
  • extract and load: save and restore your configuration from:
  • generate:
    • airflow dags: generate Airflow DAGs from YML files.
    • dbt docs: generate dbt docs by merging production catalog.json, useful in combination with dbt-checkpoint and when using Slim CI
    • dbt sources: generate the dbt source configuration as well as the initial dbt staging model(s) and their corresponding property(yml) files.
    • dbt properties: generate and/or update the properties(yml) file for a given dbt model(sql) file.
    • metadata: generate metadata extract(CSV file) that can be used to collect column types and descriptions and then provided as input inthe the generate sources or generate properties command
    • templates: generate the dbt-coves templates that dbt-coves utilizes with other dbt-coves commands
  • setup: used configure different components of a dbt project.
  • data-sync: sync Airflow's own metadata tables into Snowflake or Redshift.
    • snowflake: sync into a Snowflake database.
    • redshift: sync into a Redshift database.
  • blue-green: perform blue-green dbt deployments on Snowflake.

See the full command reference for a man-page-style breakdown of every command's arguments, and Settings for .dbt_coves/config.yml equivalents.

For a complete list of options, run:

dbt-coves -h
dbt-coves <command> -h

Contributing

If you're interested in contributing to the development of dbt-coves, please refer to the Contributing Guidelines. This document outlines the process for submitting bug reports, feature requests, and code contributions.

Metrics

Ruff Maintenance Maintainability Downloads

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

dbt_coves-1.12.2.tar.gz (95.0 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

dbt_coves-1.12.2-py3-none-any.whl (104.7 kB view details)

Uploaded Python 3

File details

Details for the file dbt_coves-1.12.2.tar.gz.

File metadata

  • Download URL: dbt_coves-1.12.2.tar.gz
  • Upload date:
  • Size: 95.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.9.30 {"installer":{"name":"uv","version":"0.9.30","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

File hashes

Hashes for dbt_coves-1.12.2.tar.gz
Algorithm Hash digest
SHA256 8adc776a63be9374212669c9eb79961027f4c93a6ad824d9ae1c3fa4e0342e52
MD5 d0e43b90a8fc7356e90fcdba1e066d7d
BLAKE2b-256 569d3923524145946d6d32de7a3055071913e9ea6474ddf618ec941fcb712505

See more details on using hashes here.

File details

Details for the file dbt_coves-1.12.2-py3-none-any.whl.

File metadata

  • Download URL: dbt_coves-1.12.2-py3-none-any.whl
  • Upload date:
  • Size: 104.7 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.9.30 {"installer":{"name":"uv","version":"0.9.30","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"Ubuntu","version":"24.04","id":"noble","libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":true}

File hashes

Hashes for dbt_coves-1.12.2-py3-none-any.whl
Algorithm Hash digest
SHA256 e46c7f63f6aca95c4ceaed3e3f3df50e0596888e9d238e00efc9143f964a4f81
MD5 1149475aebe7e560bdee881fce7c3347
BLAKE2b-256 df0d31356bd0807f6949e43e2702a6152d99db0686ccf07c80d9b87e9245e9d6

See more details on using hashes here.

Release history Release notifications | RSS feed

This release

1.12.2 This release

2 files

1.12.1

2 files

1.12.0

2 files

1.11.4

2 files

1.11.3

2 files

1.11.2

2 files

1.11.1

2 files

1.11.0

2 files

1.10.7

2 files

1.10.6

2 files

1.10.5

2 files

1.10.4

2 files

1.10.3

2 files

1.10.2

2 files

1.10.1

2 files

1.10.0

2 files

1.9.7

2 files

1.9.6

2 files

1.9.5

2 files

1.9.4

2 files

1.9.3

2 files

1.9.2

2 files

1.9.1

2 files

1.9.0

2 files

1.8.15

2 files

1.8.14

2 files

1.8.13

2 files

1.8.12

2 files

1.8.11

2 files

1.8.10

2 files

1.8.9

2 files

1.8.8

2 files

1.8.7

2 files

1.8.6

2 files

1.8.5

2 files

1.8.4

2 files

1.8.3

2 files

1.8.2

2 files

1.8.1

2 files

1.8.0

2 files

1.7.10

2 files

1.7.9

2 files

1.7.8

2 files

1.7.7

2 files

1.7.6

2 files

1.7.5

2 files

1.7.4

2 files

1.7.3

2 files

1.7.2

2 files

1.7.1

2 files

1.7.0

2 files

1.6.35

2 files

1.6.34

2 files

1.6.33

2 files

1.6.32

2 files

1.6.31

2 files

1.6.30

2 files

1.6.29

2 files

1.6.28

2 files

1.6.27

2 files

1.6.26

2 files

1.6.25

2 files

1.6.24

2 files

1.6.23

2 files

1.6.22

2 files

1.6.21

2 files

1.6.20

2 files

1.6.19

2 files

1.6.18

2 files

1.6.17

2 files

1.6.16

2 files

1.6.15

2 files

1.6.14

2 files

1.6.13

2 files

1.6.12

2 files

1.6.11

2 files

1.6.10

2 files

1.6.9

2 files

1.6.8

2 files

1.6.7

2 files

1.6.6

2 files

1.6.5

2 files

1.6.4

2 files

1.6.3

2 files

1.6.2

2 files

1.6.1

2 files

1.6.0

2 files

1.5.11

2 files

1.5.10

2 files

1.5.9

2 files

1.5.8

2 files

1.5.7

2 files

1.5.6

2 files

1.5.5

2 files

1.5.4

2 files

1.5.3

2 files

1.5.2

2 files

1.5.1

2 files

1.5.0

2 files

1.4.18

2 files

1.4.17

2 files

1.4.16

2 files

1.4.15

2 files

1.4.14

2 files

1.4.13

2 files

1.4.12

2 files

1.4.11

2 files

1.4.10

2 files

1.4.9

2 files

1.4.8

2 files

1.4.7

2 files

1.4.6

2 files

1.4.5

2 files

1.4.4

2 files

1.4.3

2 files

1.4.2

2 files

1.4.1

2 files

1.4.0.post1

2 files

1.4.0

2 files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page