dbt Blog

What's fascinating to me as that it's happening at the same time as the "X as code" movement. Devops: Infrastructure as code. or dbt's viewpoint on analytics as code (see https://blog.getdbt.com/building-a-mature-analytics-workflow/) So I'm seeing it as an exercise in finding sweet spots. There are things that have been mostly manual or point-and-click and people are seeing wins from defining and managing them as code. Usually in terms of reproducibility and testability. Then there are things that people have traditionally done in code (e.g. admin UIs) where maybe most of it can be abstracted away into a point and click tool. No-code works great until it breaks, and then your ability to debug is going to be very constrained. We're fighting that problem with some no-code ETLs using Stitch at work today, for example.

It is primarily a tool for analytics engineers (coined by the dbt team I think[]) to write more robust, managed, version controlled, DRY analytics SQL. The tool is designed to be run on an analytics data warehouse (Snowflake/Bigquery/Redshift) and generally used to provide fact & dimension tables to BI/visualisation tools. I get your confusion, I don't think it is designed for a DBA, but it makes a great tool for an ETL engineer, especially in the modern ELT paradigm. > tool to avoid hiring a DBA Yes in a way. With ELT tools like Fivetran/Stitch and highly flexible "zero-tuning" data warehouses like Snowflake/Bigquery, there is very little need for a DBA unless it is a very large organisation, and the role will more likely fall to a "Data Engineer" type role, ultimately much the same as a DBA, just a modernisation. [] https://blog.getdbt.com/what-is-an-analytics-engineer/

Reminds me of Panoply, which had native SaaS integrations, a managed Redshift instance on the back-end, and a BI layer on top. Basically a fully turn-key "modern data stack" [1]. The stack is way easier to operate than it has ever been before, but still requires folks with expertise to manage each of the components. [1] https://blog.getdbt.com/future-of-the-modern-data-stack/

"Transform" step is happening after the load to data warehouse here. https://blog.getdbt.com/what--exactly--is-dbt-/ is a pretty good overview.

dbt Labs | Remote, USA | Transforming Data & Teams : https://www.getdbt.com/ We're a distributed remote team with a public commitment to open source, transparency, and creating more value than we capture. Check us out on Enterprise Tech 30: (https://www.enterprisetech30.com/#late-stage) Here's a bit about us: Our open-source software, dbt, enables anyone who knows SQL to engineer, document, and test data pipelines. By letting analysts work like data engineers, dbt makes it faster, cheaper and easier for teams to serve great analytics. dbt has 9,000+ active projects, and a Slack community of over 25,000 folks. Read about our Series D funding here! https://blog.getdbt.com/next-layer-of-the-modern-data-stack/ Meet our Team: >>CTO/Co-Founder: Connor McArthur: https://www.linkedin.com/in/connor-mcarthur/ >>Chief Product Officer/Co-Founder: Drew Banin: https://www.linkedin.com/in/drewbanin/ >Tech Stack: Python, Rust, Django, React, Kubernetes, AWS, SQL [we will teach you everything you need to know] >>>Software Engineer 2, Internal Services>>> https://jobs.lever.co/dbtlabs/c984b8c4-1652-4217-b5db-9aa79b6bbf24?lev… >>>Sr. Product Designer>>> https://jobs.lever.co/dbtlabs/86a28f38-3216-4727-9395-dd9e4ca9183b?lev… >>>Engineering Manager, Cloud IDE >>> https://jobs.lever.co/dbtlabs/7b36b862-e3f7-4fd1-b6db-ba05bf9ff924?lev… >>>Director…

dbt Labs | Remote, USA | Transforming Data & Teams : https://www.getdbt.com/ We're a distributed remote team with a public commitment to open source, transparency, and creating more value than we capture. Check us out on Enterprise Tech 30: (https://www.enterprisetech30.com/#mid-stage) Here's a bit about us: Our open-source software, dbt, enables anyone who knows SQL to engineer, document, and test data pipelines. By letting analysts work like data engineers, dbt makes it faster, cheaper and easier for teams to serve great analytics. dbt has 8,000+ active projects, and a slack community of over 24,000 folks. Check out our Series C & brand change announcement(https://blog.getdbt.com/of-the-community-by-the-community-fo...)! Meet our Team: >>CTO/Co-Founder: Connor McArthur: https://www.linkedin.com/in/connor-mcarthur/ >>Chief Product Officer: Margaret Francis: https://www.linkedin.com/in/margaretfrancis/ >> CEO/Cofounder: Tristan Handy - https://www.linkedin.com/in/tristanhandy/ >Tech Stack: Python, Go, Rust, Django, React, Kubernetes, AWS, SQL [we will teach you everything you need to know] >Software Engineer 2 (Enterprise): https://jobs.lever.co/dbtlabs/7cfdee9e-8283-4cbf-8226-fd56e7b79d5e?lev… >Software Engineer 2 (Internal Services):https://jobs.lever.co/dbtlabs/0035fcb0-e799-4446-8d69-b6781436d44a?lev… >>Software Engineer 4 (Enterprise):…

dbt Labs | Remote, USA | Transforming Data & Teams : https://www.getdbt.com/ We're a distributed remote team with a public commitment to open source, transparency, and creating more value than we capture. Check us out on Enterprise Tech 30: (https://www.enterprisetech30.com/#mid-stage) Here's a bit about us: Our open-source software, dbt, enables anyone who knows SQL to engineer, document, and test data pipelines. By letting analysts work like data engineers, dbt makes it faster, cheaper and easier for teams to serve great analytics. dbt has 8,000+ active projects, and a slack community of over 15,000 folks. Check out our Series C & brand change announcement(https://blog.getdbt.com/of-the-community-by-the-community-fo...)! Meet our Team: >>CTO/Co-Founder: Connor McArthur: https://www.linkedin.com/in/connor-mcarthur/ >>Chief Product Officer/Co-Founder: Drew Banin: https://www.linkedin.com/in/drewbanin/ >Tech Stack: Python, Rust, Django, React, Kubernetes, AWS, SQL [we will teach you everything you need to know] >>>Software Engineer 2 (Full-Stack)>>> https://jobs.lever.co/dbtlabs/0035fcb0-e799-4446-8d69-b6781436d44a?lev… >> Software Engineer 3 (Senior, Full-Stack)>>> https://jobs.lever.co/dbtlabs/c9cfb7a0-0d25-44da-bc2d-8dbb51092882?lev… >>>Software Engineer 4 (Senior, Full-Stack)>>>…

dbt Labs | Remote, USA | Transforming Data & Teams : https://www.getdbt.com/ We're a distributed remote team with a public commitment to open source, transparency, and creating more value than we capture. Check us out on Enterprise Tech 30: (https://www.enterprisetech30.com/#mid-stage) Here's a bit about us: Our open-source software, dbt, enables anyone who knows SQL to engineer, document, and test data pipelines. By letting analysts work like data engineers, dbt makes it faster, cheaper and easier for teams to serve great analytics. dbt has 8,000+ active projects, and a slack community of over 14,000 folks. Check out our Series C & brand change announcement(https://blog.getdbt.com/of-the-community-by-the-community-for-the-comm… Meet our Team: >>CTO/Co-Founder: Connor McArthur: https://www.linkedin.com/in/connor-mcarthur/ >>Chief Product Officer/Co-Founder: Drew Banin: https://www.linkedin.com/in/drewbanin/ >> CEO/Cofounder: Tristan Handy - https://www.linkedin.com/in/tristanhandy/ >Tech Stack: Python, Rust, Django, React, Kubernetes, AWS, SQL [we will teach you everything you need to know] >>>>>>>Engineering Manager: https://jobs.lever.co/dbtlabs/bd1d30a5-2d7d-4586-9f15-a09111587fa2?lev… >>>>>Staff Software Engineer: https://jobs.lever.co/dbtlabs/0eb549bf-4a4a-497e-8766-8bff3a5f9518?lev… >>>>Senior II Software Engineer :…