Companies Home Search Profile

Deploy dbt with Github Actions

Focused View

Jeremy Holtzman

1:36:49

11 View
  • 1. Introduction.mp4
    02:02
  • 2.1 1 deploy dbt - snowflake sql setup commands.zip
  • 2.2 dbt Free Signup.html
  • 2.3 Snowflake Free Trial.html
  • 2. Setting Up Github, Snowflake, and dbt Cloud.mp4
    13:30
  • 3. dbt Deployments with dbt Cloud.mp4
    08:35
  • 4.1 3 deploy dbt - demo workflow.zip
  • 4.2 Github Actions Documentation.html
  • 4. Dive into Github Actions.mp4
    08:35
  • 5.1 5 deploy dbt - bash commands.zip
  • 5.2 5 deploy dbt - create environment variables mac zshrc.zip
  • 5.3 5 deploy dbt - profiles.zip
  • 5.4 Install dbt documentation.html
  • 5.5 Install Git documentation.html
  • 5. Setting Up and Developing with dbt Locally.mp4
    19:30
  • 6.1 6 deploy dbt - production job on schedule.zip
  • 6.2 6 deploy dbt - production job.zip
  • 6.3 Cron Syntax Documentation.html
  • 6. Deploying Production dbt Jobs using GitHub Actions.mp4
    12:05
  • 7.1 6 deploy dbt - production job on merge.zip
  • 7. Auto-Deploying dbt on Merges with GitHub Actions.mp4
    05:21
  • 8.1 8 deploy dbt - ci job.zip
  • 8.2 8 deploy dbt - production job updated.zip
  • 8.3 dbt Defer Documentation.html
  • 8.4 dbt Manifest file documentation.html
  • 8.5 dbt State Method documentation.html
  • 8.6 Github Action Download Workflow Artifact Documentation.html
  • 8.7 Github Actions Pull Request Documentation.html
  • 8. Setting Up CI dbt Jobs with GitHub Actions.mp4
    27:11
  • Description


    Complete guide to Deploying your dbt Project with Github Actions

    What You'll Learn?


    • How to deploy a production dbt job using Github Actions
    • How to deploy a CI dbt job using Github Actions to run and test your code before merging
    • How to install and setup dbt locally
    • How to connect dbt to Snowflake and Github
    • How to use Github Actions

    Who is this for?


  • Analytics Engineers
  • Data Analysts
  • BI Analysts
  • Data Scientists
  • Data Engineers
  • Anyone looking for an alternative and simple approach to deploying dbt
  • What You Need to Know?


  • SQL
  • dbt basics
  • Github basics
  • How to work in the terminal
  • More details


    Description

    What you'll learn

    Welcome to "Deploy dbt with Github Actions" – your definitive guide to streamlined and efficient dbt deployment. If you're looking to seamlessly deploy dbt without worrying about the hassle of maintaining an orchestration tool, or paying for dbt Cloud, but you still want the benefits of modern version control systems and deployment methodologies, this course is tailor-made for you.

    In this comprehensive mini-course, you'll embark on a journey that walks you through the initial setup all the way through the development lifecycle and deploying your code.

    As you progress, you'll set up dbt Cloud - as a development environment, and also to see how you could deploy in dbt Cloud). Then, we'll switch gears and focus on the world of GitHub Actions. This will empower you to confidently develop with dbt locally, and when you're ready, the latter videos will guide you step-by-step on deploying production dbt jobs, both on a schedule and automatically upon merges.

    The cherry on top? Our final module focuses on setting up a CI (Continuous Integration) dbt job with GitHub Actions, ensuring that your deployments are not just efficient, but also reliable and error-free.


    Why you should deploy dbt with Github Actions

    When it comes to deploying dbt, various platforms and tools such as dbt Cloud and Apache Airflow are available. However, GitHub Actions emerges as an incredibly powerful and flexible choice for several reasons:

    1. Seamless Integration with GitHub: If your codebase and team already operate on GitHub, deploying with GitHub Actions ensures you don’t have to juggle multiple platforms. This integrated approach streamlines workflows, allowing developers and data engineers to stay within one ecosystem.

    2. Granular Control: While dbt Cloud provides an excellent interface for dbt deployments, GitHub Actions offers more granular control over deployment workflows, allowing for tailored operations based on specific project requirements.

    3. Flexibility: With GitHub Actions, you can easily integrate other tools and systems in your workflow. It’s not just about dbt; perhaps you want to add linters, testing suites, or any other tools into your CI/CD process.

    4. Cost-Effective: For teams operating on a budget, GitHub Actions can be more cost-effective than maintaining a dedicated orchestration system or subscribing to premium tiers of dbt Cloud.

    5. Automated Workflows: The automation capabilities in GitHub Actions mean you can trigger dbt runs and tests on specific events, such as pull requests or merges. This can be harder to achieve and often less native with other platforms.

    6. Versatility: While tools like Airflow are powerful and designed for complex workflows, not every dbt deployment demands such intricacy. GitHub Actions strikes a balance, offering both simplicity for beginners and depth for advanced users.

    7. Active Community and Updates: Given GitHub’s vast community, you’ll find a plethora of pre-built actions, consistent updates, and an active community ready to assist, ensuring you remain at the forefront of best practices.

    While dbt Cloud and orchestration tools like Airflow have their own sets of advantages, GitHub Actions offers a unique blend of control, flexibility, and integration. For teams looking to maintain a streamlined workflow with fewer platforms to manage, GitHub Actions might just be the optimal solution.


    Why you should enroll in this course

    This course will quickly teach you the basics you need to get your dbt project fully deployed using Github Actions. This includes:

    • Efficient Deployment: Streamline your dbt deployment processes with the integration of GitHub Actions.

    • Hands-on Learning: Real-world examples and practical guidance for setting up and deploying in multiple environments.

    • Enhanced Reliability: Learn how to implement CI for your dbt jobs, ensuring consistent and error-free deployments.

    • Skill Enhancement: Master a crucial skill set that is in high demand in the data engineering and DevOps landscapes.

    Equip yourself with the skills to blend the power of dbt with the flexibility and efficiency of GitHub Actions. Enroll today and elevate your deployment game!

    Who this course is for:

    • Analytics Engineers
    • Data Analysts
    • BI Analysts
    • Data Scientists
    • Data Engineers
    • Anyone looking for an alternative and simple approach to deploying dbt

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Jeremy Holtzman
    Jeremy Holtzman
    Instructor's Courses
    I've been working with data for the last 7 years, and I've recently started sharing the skills I've learned along the way in these online courses.I love helping to simplify all of the upfront time it takes to learn these super useful data tools, and I hope you enjoy the different courses I've put together to add to your toolbox of skills.
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 8
    • duration 1:36:49
    • Release Date 2023/12/16