{"repo":"pgoslatara/dbt-beyond-the-basics","free":true,"listed":false,"github":"https://github.com/pgoslatara/dbt-beyond-the-basics","clone":"git clone https://github.com/pgoslatara/dbt-beyond-the-basics.git","description":"Showcase of advanced use cases relating to CI in dbt","language":"Python","stars":105,"topics":["continuous-integration","dbt","python","sql"],"license":"MIT","category":"data-pipelines","readme_excerpt":"dbt-beyond-the-basics A repository demonstrating advanced use cases of dbt in the following areas: - Continuous Integration (CI) - Pre-commit - dbt Artifacts and Pytest - Coverage reports - dbt-bouncer - dbt commands - Using state:modified - Mart Monitor - Continuous Deployment (CD) - dbt Docs - Entity Relationship Diagram (ERD) - Docker-ising dbt - Dev Containers - Python - The .python-version file - Package Managers - Caching in GitHub Workflows - Others - Running dbt from python - Conferences - References See something incorrect, open an issue! Want to see something else included, open an issue 😉! Continuous Integration Continuous Integration (CI) is the process of codifying standards, these range from formatting of file contents to validating the correctness of generated data in a data warehouse. Pre-commit Pre-commit provides a standardised process to run some basic tests (generally formatting and linting) before committing to your local branch. This has several benefits, primarily providing the developer with a quick feedback loop on their work as well as ensuring changes that do not align with standards are automatically identified before being merged. Pre-commit operates via hooks, all of these hooks are sepecified in a .pre-commit-config.yaml file. To install pre-commit run: Then install the hooks specified in your .pre-commit-config.yaml file: There are several hooks that are relevant to a dbt project: - Pre-commit itself provides several standard hooks that ensure","default_branch":null,"files":null,"tree":[],"storefront":"/r/pgoslatara","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/pgoslatara/dbt-beyond-the-basics/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."}