Data Sources

Sales Transactions

• Source: PostgreSQL
• Database: postgres
• Schema: favorita
• Table: transaction_details
• Connection Endpoint: jdbc:postgresql://ai-vector-db.czcuptfky4cm.eu-west-1.rds.amazonaws.com/postgres
• Username: postgres
• Password: Schema-Favorita-PostgreSQL

Product Catalogue

• Source: Google Sheets
• Authentication Type: OAuth 2.0 Authorization Code
• Authentication Name: Favorita-Grocery-GSheets
• Spreadsheet Name: product_catalogue
• Contains Header Row: Yes
• Load Strategy: Replace

Additional Data

• Additional tables are located in the default data warehouse.
• All tables related to Favorita Grocery include favorita_grocery in the table name.

---

Rules

Star Schema Design

The following star schema rules must always be followed when creating fact and dimension tables:

• Dimension tables must contain descriptive attribute fields that describe the object and its dimension keys.
• Fact tables must contain only measures and the relevant dimension key relationships. They must not include descriptive attributes.

Table Naming Conventions

• Fact tables must begin with the prefix: FACT_FAVORITA_GROCERY
• Dimension tables must begin with the prefix: DIM_FAVORITA_GROCERY
• All other tables must begin with the prefix: FAVORITA_GROCERY