Customer Summary Fact Table

Also known as members fact. This table summarizes all the data pertaining to the customer, such as their registration date, points information, total transaction amount, number of transactions made, their date of birth, and wedding date.

Databricks Table Name: customer_summary

Customer Summary (members) - Entity Relationship Diagram ERD

Zoom in the table for more clarity. Click the table title to view its details.