Fabric creates a separate index in the Search provider (Elasticsearch or OpenSearch) on each LU table that has Search fields.
Search indexes are created after a CDC Schema message or a CDC Schema Update message when a Search field is added on a new LU table.
The following displays mapping of Fabric LU Search fields and Search indexes:
Define Search fields on the ADDRESS LU table of the Customer LU. Define the following table columns as Search fields:
Deploy the Customer LU.
Fabric creates an search index for the ADDRESS LU table. The fields below are set as the Columns of the index.
Sync Customer 123 into Fabric. This customer has 3 ADDRESS records.
The CDC Table Change Info message initiates an update of the search index:
Fabric creates a separate index in the Search provider (Elasticsearch or OpenSearch) on each LU table that has Search fields.
Search indexes are created after a CDC Schema message or a CDC Schema Update message when a Search field is added on a new LU table.
The following displays mapping of Fabric LU Search fields and Search indexes:
Define Search fields on the ADDRESS LU table of the Customer LU. Define the following table columns as Search fields:
Deploy the Customer LU.
Fabric creates an search index for the ADDRESS LU table. The fields below are set as the Columns of the index.
Sync Customer 123 into Fabric. This customer has 3 ADDRESS records.
The CDC Table Change Info message initiates an update of the search index: