Spring Deals - hours only!Up to 70% off on all courses and bundles.-Close
Custom logging
Loading Customers
4. The dim_customer table
Subscriptions
Congratulations

Instruction

Now, let's review two more tables we're going to work with in the next exercises: dim_customer and stg_customer.

Let's start with the first table – dim_customer. It is the main table that contains all the customers we have in our system. This table is updated regularly based on the new data we receive weekly via the stg_customer table.

Exercise

Let's review the structure of the table – select the top five customers from the dim_customer table, sorted by date_of_first_purchase in ascending order.