Skip to content

Latest commit

 

History

History
70 lines (51 loc) · 2.42 KB

File metadata and controls

70 lines (51 loc) · 2.42 KB

dbt-coves generate properties

Overview

image

You can use dbt-coves to generate and update the properties(yml) file for a given dbt model(sql) file.

Arguments

dbt-coves generate properties supports the following args:

--destination
# Where models yml files will be generated, default: '{{model_folder_path}}/{{model_file_name}}.yml'
--update-strategy
# Action to perform when a property file already exists: 'update', 'recreate', 'fail', 'ask' (per file)
-s --select
# Filter model(s) for which to generate property file(s)
--exclude
# Filter model(s) to exclude from property file(s) generation
--selector
# Specify dbt selector for more complex model filtering
--templates-folder
# Folder with jinja templates that override default properties generation templates, i.e. 'templates'
--metadata
# Path to csv file containing metadata, i.e. 'metadata.csv'
--no-prompt
# Silently generate dbt models property files

Note: --select (or -s), --exclude and --selector work exactly as dbt ls selectors do. For usage details, visit dbt list docs

Metadata

dbt-coves supports the argument --metadata which allows users to specify a csv file containing field types and descriptions to be used when creating the staging models and property files.

dbt-coves generate sources --metadata metadata.csv

Metadata format: You can download a sample csv file as reference

database schema relation column key type description
raw raw _airbyte_raw_country_populations _airbyte_data Year integer Year of country population measurement
raw raw _airbyte_raw_country_populations _airbyte_data variant Airbyte data columns (VARIANT) in Snowflake
raw raw _airbyte_raw_country_populations _airbyte_ab_id varchar Airbyte unique identifier used during data load