Free Architecture Checklist

#040: 3 Ways to Deploy Data Projects

May 10, 2023

It's one thing to write code, it's another to plan and strategize your deployment approach.  

And over the years I've worked on a handful of different teams where the strategies have been different.

Sometimes this is due to personal preference of the team lead.

Other times it was mainly based around the technology.

For example, the strategy you'll use on Postgres is likely different than, say, Snowflake.

 

So in this week's video, I've compiled three of the most common approaches that I've seen in my career.

The goal is to help you understand common strategies teams are taking and find ways to add your own spin on it.

 

As a heads up, this video will be based off of a dbt (data-build-tool) project, which is a popular data transformation tool.  

But, these approaches & concepts can work regardless of tool selection. 

 

Enjoy!

 

What will you learn? 

  • 3 ways to deploy a database project
  • Example naming conventions
  • Example db/schema layouts

 


 

Looking for more? Here are 4 other ways I can help you:

  1. Modern Data Mastery (Course) - A clear & straightforward overview of concepts & strategies in modern data stacks so you can navigate your data career with confidence.
  2. The Playbook for dbt™ (Course) - A complete project-based course on dbt™ sharing functionality, best practices & strategies so you're ready to contribute on any team.
  3. Consulting - Hire me as a hands-on consultant to help complete your next data project.
  4. Sponsorship - Promote your product or brand to 5,000+ email subscribers and/or 21k+ YouTube subscribers.

 

 

 

Set Your New Data Stack Up for Success with a Free Strategy Call

You’ve modernized your data architecture - now let’s ensure it’s setup for long-term success.

In this Free 30-Minute Strategy Call, we’ll:

  • Review your current setup and progress
  • Identify potential gaps or risks
  • Provide actionable next steps to optimize your process

Whether you’re managing this effort solo or with a small team, you’ll leave with a clear roadmap to confidently build a structured, scalable, and maintainable data architecture.

For best results, please provide as much detail as possible.