Skip to main content

Setting up the dev_customers model

This transformation for this model is just a single column rename. Since we've seen how to do this in the dev_payments model, we'll skip the details here.

The source table​

The source table for the dev_customers model is the raw.raw_customers table, which has the following columns:

img Raw Customer Schema

Creating and setting up the dev_customers model​

Create the dev_customers model in the same way we created the dev_payments model, except that we set the source table to raw.raw_customers and the destination table to dev_customers.

The only transformation we need to do is to rename the id column to customer_id. And the model finally looks like this:

img Dev Customers

That's pretty much it!