Understand and Use dbt Jinja Macros

Connecting to the dbt Web IDE

Lab Steps

Understanding What Are dbt Jinja Macros

Defining a Custom dbt Macro

Creating a Model Leveraging dbt Macros

Executing the dbt Model

Need help? Contact our support team

Here you can find the instructions for this specific Lab Step.

If you are ready for a real environment experience please start the Lab. Keep in mind that you'll need to start from the first step.

Introduction

This dbt lab provides you with a web browser integrated development environment (IDE). The host has dbt, PostgreSQL, as well as common development tools such as git installed and ready for you to play with.

The following instructions allow you to connect to the in-browser dbt IDE. Once connected you can explore, test, build, and play with dbt until the lab time expires.

Instructions

1. Once fully provisioned, click the following button to open the lab’s cloud environment:

Open Code Environment

Note: It takes approximately 1 minute for the development environment to startup.

2. The web-based dbt IDE will be presented as a similar IDE to Visual Studio Code.

alt

Summary

In this lab step, you used your local browser to navigate to the web-based dbt IDE.