Skip to content

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 Dataset:

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. If summary is not available yet, select tables you are interested in and click Summary Button to generate a summary for each table. Click Show more Button to read full summary.

Name


Step 3: Understand Table Types

For accurate feature derivation, FeatureByte needs to recognize the roles of different tables.

Each table should be assigned a specific type based on its structure and purpose:

  • GROCERYINVOICE --> Event table.

    Why Event Table?

    The table records invoices of the Customer purchase events, making it suitable for an Event Table designation.

  • INVOICEITEMS --> Item table.

    Why Item Table?

    The table records breakdown of the invoices of the Customer purchase events, making it suitable for an Item Table designation.

  • GROCERYCUSTOMER --> Slowly Changing Dimension (SCD) table.

    Why Slowly Changing Dimension (SCD) table?

    The table tracks the Customer profile and dynamic fields that change over time, making it a Slowly Changing Dimension (SCD) Table.

  • GROCERYPRODUCT --> Dimension table.

    Why Dimension table?

    The table provides a static mapping of products with their corresponding product group , making it a Dimension Table.


Step 4: Register the GROCERYINVOICE table as an Event Table

  1. Select the GROCERYINVOICE table. Name

  2. Click on Register Table

  3. Click on Magic Wand to get assistance. Name

  4. Accept suggestions to:

    Name

  5. Establish a Default Feature Job Setting, either automatically (if a Record Creation Timestamp Column is provided) or manually. We will set the job automatically by clicking Register Table.

  6. Complete registration by clicking Confirm Registration.

    Register BUREAU


Step 5: Register the INVOICEITEMS table as an Item Table

  1. Select the INVOICEITEMS table. Name

  2. Click on Register Table

  3. Click on Magic Wand to get assistance. Name

  4. Accept suggestions to:

  5. Complete registration by clicking Confirm Registration. Name


Step 6: Register the GROCERYCUSTOMER table as a SCD Table

  1. Select the GROCERYCUSTOMER table. Name

  2. Click on Register Table

  3. Click on Magic Wand to get assistance. Name

  4. Accept suggestions to:

  5. Complete registration by clicking Confirm Registration. Name


Step 7: Register the GROCERYPRODUCT table

  1. Select the GROCERYPRODUCT table. Name

  2. Click on Register Table

  3. Set the table type as Dimension Table.
  4. Identify its Dimension ID Column.

Register Tables


Step 8: Review Registered Tables

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

Table Description