Deploy your dbt Jobs

Jobs are like a set of instructions for dbt that you want to execute at specific times. Think of it as a schedule for your dbt commands, for instance, dbt build.

As the jaffle_shop business expands and attracts more customers, those customers will inevitably generate more orders, leading to an increase in the number of records added to your source data. Since you materialized the customers model as a table, you'll need to periodically rebuild your table to keep the data current. This update occurs when you run a job.

Use the steps to create a dbt Job -

  1. Go to the Job Section next to Environment

  2. Click Create one and provide a name, for example, "Job Demo", and link to the Production Environment that was created for you.

  3. Mention the number of threads that you want (You can keep it 2 for now)

  4. Under Commands, add dbt run For this exercise, do not set a schedule for your project to run — while your organization's project should run regularly, there's no need to run this example project on a schedule. Scheduling a job is sometimes referred to as deploying a project.

  5. Select Save, then click Run now to run your job. Click the run and watch its progress under "Run history."

Last updated