Data Build Tool Playground

Lab Steps

lock
Data Build Tool Playground

The hands-on lab is part of this learning path

Ready for the real environment experience?

DifficultyIntermediate
Time Limit4h
Students13

Description

Data Build Tool (dbt) is a powerful tool that allows data analysts and data engineers to easily and efficiently perform data modeling and transformations. It allows you to define sources you want to start from, and the different transformations you want to apply on your data. All the transformations are dbt models and are SQL select statements. dbt also allows you to define the schema of the models you define and offers you the possibility to perform data quality by testing your data.

The playground is a safe and secure sandbox environment for you to explore your own ideas, follow along with Cloud Academy courses, or answer your own questions all without the need to install any software on your local machine. The extended duration of this playground provides you with ample time to play to your heart's content. The goal is to be able to experiment and learn with little start time or overhead. Feel free to experiment working with dbt by defining sources, models, schema definitions, and tests. You will have access to the dbt IDE where you can perform all the operations from.

Intended Audience

This lab is intended for:

  • Data analysts that need to model data to extract useful insights
  • Data engineers that need to build up ELT pipelines

Prerequisites

To get the most from this lab, you should have basic knowledge of dbt. To get ready, you can use the following labs:

About the Author
Students26609
Labs106
Courses2
Learning paths8

Stefano studies Computer Science and is passionate about technology. He loves working with Cloud services and learning all the best practices for them. Google Cloud Platform and Amazon Web Services are the cloud providers he prefers. He is a Google Cloud Certified Associate Cloud Engineer. Node.js is the programming language he always uses to code. When he's not involved in studying or working, Stefano loves riding his motorbike and exploring new places.