SourceTable
A SourceTable object is a table from a data warehouse that the feature store can access.
Getting a Source Table¶
-
Obtain the DataSource object associated with a FeatureStore object using the
'get_data_source()
method: -
Obtain a SourceTable object using the
get_source_table()
method:
Exploring a Source Table¶
- Obtain descriptive statistics for the table using the
describe()
method: - Preview a selection of rows from the table using the
preview()
method:
Registering the table to the catalog¶
-
Activate the desired catalog using the
activate()
class method: -
Determine the table's type and register the table using the method specific to its type:
create_event_table()
: creates an EventTable object from a source table, where each row indicates a unique business event occurring at a particular time.create_item_table()
creates an ItemTable object from a source table containing detailed information about a specific business event.create_dimension_table()
: creates a DimensionTable object from a source table containing static descriptive data.create_scd_table()
: creates an SCDTable object from a source table containing data that changes slowly and unpredictably over time, known as a Slowly Changing Dimension (SCD) table.
Example of registering an event table using the create_event_table()
method:
invoice_table = source_table.create_event_table(
name="GROCERYINVOICE",
event_id_column="GroceryInvoiceGuid",
event_timestamp_column="Timestamp",
event_timestamp_timezone_offset_column="tz_offset",
record_creation_timestamp_column="record_available_at"
)
In this example, the table is added to the catalog as an EventTable object under the name of GROCERYINVOICE.