{"repo":"MarkPhamm/dbt-Fundamental","free":true,"listed":false,"github":"https://github.com/MarkPhamm/dbt-Fundamental","clone":"git clone https://github.com/MarkPhamm/dbt-Fundamental.git","description":"Repo for learning DBT with Snowflake, featuring projects and models for data transformation and automation","language":null,"stars":27,"topics":["dbt","git","snowflake"],"license":null,"category":"data-pipelines","readme_excerpt":"common dbt Commands 1. Running and Building Models Command Description ------------------------------ ------------- dbt run Executes models by running SQL queries and materializing results in the data warehouse. dbt build Runs dbt run , dbt test , and dbt source freshness in a single command. dbt run --select Runs a specific model instead of all models in the project. dbt run --exclude Runs all models except the specified one. dbt run --full-refresh Forces a full refresh for incremental models. dbt run --select state:modified+ Runs only the models that have been modified since the last run. dbt retry Retries failed models a specified number of times from the last point of failure. 2. Testing and Validating Data Command Description ------------------------------ ------------- dbt test Runs all tests on models to validate data integrity. dbt test --data Runs only data tests (e.g., uniqueness, referential integrity). dbt test --schema Runs only schema tests (e.g., constraints on table structures). dbt test --select Runs tests only on a specific model. 3. Data Freshness and Snapshots Command Description ------------------------------ ------------- dbt source freshness Checks the freshness of source data by comparing last updated timestamps. dbt source snapshot-freshness Alias for dbt source freshness , checking source freshness. dbt snapshot Captures changes in slowly changing dimensions (SCD) over time. dbt snapshot --select Runs a specific snapshot instead of all snapshots. 4. ","default_branch":null,"files":null,"tree":[],"storefront":"/r/MarkPhamm","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/MarkPhamm/dbt-Fundamental/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}