2. Register Tables

Our catalog is created and we can start registering tables in it.

---

Step 1: Select Data

We'll utilize the four tables of our Grocery Datasets:

Table	Description
GROCERYINVOICE	Grocery invoice details, containing the timestamp and the total amount of the invoice
INVOICEITEMS	The grocery product item details within each invoice, including the quantity, total cost, discount applied, and product ID
GROCERYCUSTOMER	Customer details, including their name, address, and date of birth
GROCERYPRODUCT	The product group description for each grocery product

---

Step 2: Locate Your data

From the menu, go to the Explore section and access the source tables.

You will find the four tables under the "DEMO_DATASETS" database and the "GROCERY" schema.

---

Step 3: Understand Table Types

For accurate feature derivation, FeatureByte needs to understand the 'roles' of the various tables.

Identify each table's type:

• GROCERYINVOICE: Event table (captures specific business events).
• INVOICEITEMS: Item table (details about events).
• GROCERYCUSTOMER: Slowly Changing Dimension (SCD) table (customer details that change over time).
• GROCERYPRODUCT: Dimension table (descriptive, static data).

---

Step 4: Register the GROCERYINVOICE table as an Event Table

1. Select the GROCERYINVOICE table.

2. Click on

3. Set the table type as 'Event Table', identify its key columns (Event Timestamp Column, Event ID Column), set the event time zone if any and establish a Default Feature Job Setting as follows:

---

---

Step 4: Register the INVOICEITEMS table as an Item Table

1. Select the INVOICEITEMS table.

2. Click on

3. Set the table type as 'Item Table', identify the Event table it is associated with and the key columns (Item ID Column, Event ID Column) as follows:

---

---

Step 5: Register the GROCERYCUSTOMER table as a SCD Table

1. Select the GROCERYCUSTOMER table.

2. Click on

3. Set the table type as 'Slowly Changing Dimension Table', identify its key columns (Natural Key Column, Surrogate Key Column, Effective Timestamp Column, End Timestamp Column, Current Flag Column) as follows:

---

---

Step 6: Register the GROCERYPRODUCT table

1. Select the GROCERYPRODUCT table.

2. Click on

3. Set the table type as 'Dimension Table' and identify its Dimension ID Column as follows:

---

---

Step 7: Review Registered Tables

Verify the registration by checking the Table Catalog under the 'Explore' section.