{"id":11155,"date":"2024-03-01T18:03:00","date_gmt":"2024-03-01T17:03:00","guid":{"rendered":"https:\/\/wearekemb.com\/?p=11155"},"modified":"2025-03-03T17:38:31","modified_gmt":"2025-03-03T16:38:31","slug":"streamlining-bi-projects-with-github-and-dbt","status":"publish","type":"post","link":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/","title":{"rendered":"Streamlining BI Projects with Github and dbt"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; custom_padding_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; background_enable_image=&#8221;off&#8221; background_size=&#8221;initial&#8221; background_position=&#8221;top_right&#8221; custom_margin=&#8221;||||false|false&#8221; custom_padding=&#8221;0%||0%||false|false&#8221; custom_padding_tablet=&#8221;&#8221; custom_padding_phone=&#8221;&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_row gutter_width=&#8221;3&#8243; make_equal=&#8221;on&#8221; custom_padding_last_edited=&#8221;on|tablet&#8221; _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; width=&#8221;95.1%&#8221; width_phone=&#8221;100%&#8221; custom_margin=&#8221;70px|auto|-20px|auto|false|false&#8221; custom_padding=&#8221;||0px||false|false&#8221; custom_padding_tablet=&#8221;80px||||false|false&#8221; custom_padding_phone=&#8221;120px||||false|false&#8221; custom_css_main_element=&#8221;align-items: center;&#8221; global_colors_info=&#8221;{}&#8221; custom_css_main_element_last_edited=&#8221;on|phone&#8221; custom_css_main_element_tablet=&#8221;display: flex;||&#8221; custom_css_main_element_phone=&#8221;flex-wrap: wrap;||display: flex;&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; custom_padding_tablet=&#8221;&#8221; custom_padding_phone=&#8221;5%|5%||5%|false|true&#8221; custom_padding_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; custom_css_main_element_last_edited=&#8221;on|phone&#8221; custom_css_main_element_phone=&#8221;order: 2;&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#First_things_first_Why_combine_GitHub_and_dbt\" >First things first: Why combine GitHub and dbt?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#Getting_Started_with_GitHub_and_dbt\" >Getting Started with GitHub and dbt<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#Automating_dbt_Evaluation_on_Pull_Requests\" >Automating dbt Evaluation on Pull Requests<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#Best_Practices_for_GitHub_and_dbt_Integration\" >Best Practices for GitHub and dbt Integration<\/a><\/li><\/ul><\/nav><\/div>\n\n<h3><b>Best Practices for Effective Version Control<\/b><\/h3>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><em>In the realm of BI, where collaboration, reproducibility, and efficiency are paramount, integrating version control tools like GitHub with powerful data modeling tools like dbt (data build tool) can significantly enhance project management and code quality. In this article, we explore how to leverage GitHub alongside dbt and its associated packages\u2014dbt utils, dbt project evaluator, and dbt audit helper\u2014to implement best practices for version control and project evaluation in data analytics workflows.<\/em><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"First_things_first_Why_combine_GitHub_and_dbt\"><\/span>First things first: Why combine GitHub and dbt?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>GitHub serves as a centralized platform for version control, facilitating collaboration, code review, and project management. By integrating dbt\u2014a data modeling tool that enables analysts to transform, test, and document data pipelines\u2014teams can enforce data modeling best practices, automate testing, and ensure the reliability of analytics outputs.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Getting_Started_with_GitHub_and_dbt\"><\/span>Getting Started with GitHub and dbt<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>1. Setting Up a Repository<\/strong><\/h3>\n<p>Create a new repository on GitHub to host your dbt project. Initialize the repository with a README file and a .gitignore file tailored to dbt-specific files and directories.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>2. Cloning the Repository<\/strong><\/h3>\n<p>Clone the GitHub repository to your local machine. This local copy will serve as your development environment for dbt projects.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>3. Configuring dbt<\/strong><\/h3>\n<p>Configure your dbt project by creating a profiles.yml file to define connections to your data warehouse (e.g., Snowflake). Additionally, set up your dbt project configuration file (dbt_project.yml) to specify project settings and dependencies.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>4. Implementing dbt Packages<\/strong><\/h3>\n<p>Integrate dbt packages like dbt utils, dbt project evaluator, and dbt audit helper into your project. These packages offer utilities for data transformation, project evaluation, and auditing, enhancing the capabilities of your dbt workflows<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>5. Branching Strategy<\/strong><\/h3>\n<p>Adopt a branching strategy that aligns with your project&#8217;s needs. Create feature branches for implementing new dbt models or making changes to existing ones, and use pull requests for code review and merging.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Automating_dbt_Evaluation_on_Pull_Requests\"><\/span>Automating dbt Evaluation on Pull Requests<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>Pull Request Workflow:<\/strong><\/h3>\n<p>When a developer creates a pull request on GitHub, it triggers automated dbt evaluation using GitHub Actions or similar CI\/CD tools. The evaluation process includes compiling dbt models, running tests, and auditing data quality.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>dbt Model Compilation:<\/strong><\/h3>\n<p>During the pull request review, dbt compiles the dbt project to ensure that all models are syntactically valid and free of errors. Any compilation errors are reported back to the developer for resolution.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>Data Quality Auditing:<\/strong><\/h3>\n<p>Leveraging dbt audit helper, the evaluation process includes auditing data quality metrics such as completeness, accuracy, and consistency. Any deviations from predefined thresholds trigger alerts, prompting developers to investigate and address potential issues.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Best_Practices_for_GitHub_and_dbt_Integration\"><\/span>Best Practices for GitHub and dbt Integration<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>Code Review:<\/strong><\/h3>\n<p>Encourage thorough code review on pull requests to ensure code quality, adherence to dbt best practices, and alignment with project objectives.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>Documentation:<\/strong><\/h3>\n<p>Supplement dbt models with descriptive comments, data lineage diagrams, and documentation files to facilitate understanding and maintainability.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;||0px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>Continuous Improvement:<\/strong><\/h3>\n<p>Continuously refine and optimize your dbt project and GitHub workflows based on feedback, lessons learned, and evolving business requirements.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.24.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3><strong>Conclusion<\/strong><\/h3>\n<p>By combining the collaborative capabilities of GitHub with the data modeling prowess of dbt and its associated packages, data analytics teams can establish robust version control workflows, automate testing and evaluation, and uphold data quality standards effectively. Through diligent adherence to best practices and seamless integration of these tools, organizations can streamline their data analytics projects, foster collaboration among team members, and deliver insights that drive informed decision-making.<\/p>\n<p>If you are facing just such challenges and would like to take your data strategy to the next level, feel free to <a href=\"https:\/\/wearekemb.com\/en\/contact-us\/\"><span style=\"text-decoration: underline;\"><strong>get in touch with our experts<\/strong><\/span><\/a> at any time for a no-obligation call.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Improve your BI projects with seamless integration of GitHub and dbt: Essentials for efficient version control to streamline workflows.<\/p>\n","protected":false},"author":15,"featured_media":11149,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","content-type":"","inline_featured_image":false,"footnotes":""},"categories":[24,26],"tags":[],"class_list":["post-11155","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence-en","category-data-reporting-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Streamlining BI Projects with Github and dbt - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation<\/title>\n<meta name=\"description\" content=\"Improve your BI projects with seamless integration of GitHub and dbt: Essentials for efficient version control to streamline workflows.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Streamlining BI Projects with Github and dbt - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\" \/>\n<meta property=\"og:description\" content=\"Improve your BI projects with seamless integration of GitHub and dbt: Essentials for efficient version control to streamline workflows.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/\" \/>\n<meta property=\"og:site_name\" content=\"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-01T17:03:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-03T16:38:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wearekemb.com\/wp-content\/uploads\/2024\/03\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2200\" \/>\n\t<meta property=\"og:image:height\" content=\"1500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Abhiram Palicherla\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Abhiram Palicherla\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/\"},\"author\":{\"name\":\"Abhiram Palicherla\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#\\\/schema\\\/person\\\/39615c80a772450e39b7dad524cabae8\"},\"headline\":\"Streamlining BI Projects with Github and dbt\",\"datePublished\":\"2024-03-01T17:03:00+00:00\",\"dateModified\":\"2025-03-03T16:38:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/\"},\"wordCount\":1181,\"publisher\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png\",\"articleSection\":[\"Business Intelligence\",\"Data &amp; reporting\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/\",\"name\":\"Streamlining BI Projects with Github and dbt - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png\",\"datePublished\":\"2024-03-01T17:03:00+00:00\",\"dateModified\":\"2025-03-03T16:38:31+00:00\",\"description\":\"Improve your BI projects with seamless integration of GitHub and dbt: Essentials for efficient version control to streamline workflows.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/#primaryimage\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png\",\"contentUrl\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png\",\"width\":2200,\"height\":1500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/streamlining-bi-projects-with-github-and-dbt\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Streamlining BI Projects with Github and dbt\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/\",\"name\":\"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\",\"description\":\"We help you bring your business to the next level\",\"publisher\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#organization\",\"name\":\"kemb GmbH\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/kemb-logo-512x512-1.png\",\"contentUrl\":\"https:\\\/\\\/wearekemb.com\\\/wp-content\\\/uploads\\\/2023\\\/02\\\/kemb-logo-512x512-1.png\",\"width\":512,\"height\":512,\"caption\":\"kemb GmbH\"},\"image\":{\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/kemb-gmbh\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/wearekemb.com\\\/en\\\/#\\\/schema\\\/person\\\/39615c80a772450e39b7dad524cabae8\",\"name\":\"Abhiram Palicherla\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e440458de8259f634dc0c1e04d8a9b33dcb5936f3556798507d9ad9bf48ce43?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e440458de8259f634dc0c1e04d8a9b33dcb5936f3556798507d9ad9bf48ce43?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0e440458de8259f634dc0c1e04d8a9b33dcb5936f3556798507d9ad9bf48ce43?s=96&d=mm&r=g\",\"caption\":\"Abhiram Palicherla\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Streamlining BI Projects with Github and dbt - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","description":"Improve your BI projects with seamless integration of GitHub and dbt: Essentials for efficient version control to streamline workflows.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/","og_locale":"en_US","og_type":"article","og_title":"Streamlining BI Projects with Github and dbt - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","og_description":"Improve your BI projects with seamless integration of GitHub and dbt: Essentials for efficient version control to streamline workflows.","og_url":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/","og_site_name":"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","article_published_time":"2024-03-01T17:03:00+00:00","article_modified_time":"2025-03-03T16:38:31+00:00","og_image":[{"width":2200,"height":1500,"url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2024\/03\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png","type":"image\/png"}],"author":"Abhiram Palicherla","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Abhiram Palicherla","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#article","isPartOf":{"@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/"},"author":{"name":"Abhiram Palicherla","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/person\/39615c80a772450e39b7dad524cabae8"},"headline":"Streamlining BI Projects with Github and dbt","datePublished":"2024-03-01T17:03:00+00:00","dateModified":"2025-03-03T16:38:31+00:00","mainEntityOfPage":{"@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/"},"wordCount":1181,"publisher":{"@id":"https:\/\/wearekemb.com\/en\/#organization"},"image":{"@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#primaryimage"},"thumbnailUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2024\/03\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png","articleSection":["Business Intelligence","Data &amp; reporting"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/","url":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/","name":"Streamlining BI Projects with Github and dbt - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","isPartOf":{"@id":"https:\/\/wearekemb.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#primaryimage"},"image":{"@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#primaryimage"},"thumbnailUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2024\/03\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png","datePublished":"2024-03-01T17:03:00+00:00","dateModified":"2025-03-03T16:38:31+00:00","description":"Improve your BI projects with seamless integration of GitHub and dbt: Essentials for efficient version control to streamline workflows.","breadcrumb":{"@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#primaryimage","url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2024\/03\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png","contentUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2024\/03\/streamlining-bi-projects-with-github-and-dbt-kemb-thumbnail.png","width":2200,"height":1500},{"@type":"BreadcrumbList","@id":"https:\/\/wearekemb.com\/en\/streamlining-bi-projects-with-github-and-dbt\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wearekemb.com\/en\/"},{"@type":"ListItem","position":2,"name":"Streamlining BI Projects with Github and dbt"}]},{"@type":"WebSite","@id":"https:\/\/wearekemb.com\/en\/#website","url":"https:\/\/wearekemb.com\/en\/","name":"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","description":"We help you bring your business to the next level","publisher":{"@id":"https:\/\/wearekemb.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wearekemb.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/wearekemb.com\/en\/#organization","name":"kemb GmbH","url":"https:\/\/wearekemb.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/02\/kemb-logo-512x512-1.png","contentUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/02\/kemb-logo-512x512-1.png","width":512,"height":512,"caption":"kemb GmbH"},"image":{"@id":"https:\/\/wearekemb.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/kemb-gmbh\/"]},{"@type":"Person","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/person\/39615c80a772450e39b7dad524cabae8","name":"Abhiram Palicherla","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/0e440458de8259f634dc0c1e04d8a9b33dcb5936f3556798507d9ad9bf48ce43?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0e440458de8259f634dc0c1e04d8a9b33dcb5936f3556798507d9ad9bf48ce43?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0e440458de8259f634dc0c1e04d8a9b33dcb5936f3556798507d9ad9bf48ce43?s=96&d=mm&r=g","caption":"Abhiram Palicherla"}}]}},"_links":{"self":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts\/11155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/comments?post=11155"}],"version-history":[{"count":0,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts\/11155\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/media\/11149"}],"wp:attachment":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/media?parent=11155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/categories?post=11155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/tags?post=11155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}