dbt

data transformation tools
data transformation

Data pipelines for dummies

dbt is a recent addition to the FIRN portfolio of software partnerships. It is a data transformation tool that enables data analysts and engineers to transform, test and document data in the cloud data warehouse. With dbt, anyone who knows SQL can build production-grade data pipelines. 

Software engineering

dbt helps data teams ship trusted data, faster. Your team can work like software engineers using its transformation workflow to collaborate and quickly deploy analytics code. Software engineering best practices like modularity, portability, CI/CD, and documentation become standard practice. 

With dbt, data teams work directly within the warehouse to produce trusted datasets for reporting, ML modeling, and operational workflows.

How dbt works

Version Control and CI/CD

Deploy safely using dev environments. Git-enabled version control enables collaboration and a return to previous states.

Test and Document

Test every model prior to production and share dynamically generated documentation with all stakeholders.

Develop

Write modular SQL models with SELECT statements and the ref() function– dbt handles the chore of dependency management.

dbt data
dbt data tool

Transforming data. Transforming teams.

data transformation tools

You saw dbt here first

dbt pioneered the practice of analytics engineering. It now supports a community of over 15,000 data practitioners committed to changing how data teams work together. FIRN is excited to be dbt’s first NZ-based preferred consulting partner.

Interested to learn more about fast, safe data transformation?

Talk to us about data transformation and your teams building production-grade data pipelines safely and efficiently for more collaborative workflows.

Data analytics news and views for NZ

Forget the A-list!
Are you on the FIRN list?

Sign up here to receive regular monthly insights and to have the opportunity to attend our exclusive insider events. You can unsubscribe at any time.