Schema Conventions

The following conventions are used throughout the schema:

• Table Prefixes: All tables in the lakehouse schema are prefixed with ccdw to organize the tables into a model representing the Commerce Cloud Data Lakehouse.
• Table Types:
  • Dimensions (dim_ prefix): These tables represent business context.
  • Facts (fact_ prefix): These tables represent details about a measured business process.
  • Aggregates (aggr_ prefix): These tables represent aggregate data about a business process and support quick access to commonly used business questions.
• Currency Prefixes:
  • lcl_: Monetary values in the tendered currency
  • std_: Monetary values converted to a common reporting currency
• Time Prefixes:
  • utc_: Columns representing Universal Time Coordinated time