Creating Indexes on Search Fields
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:
Example:
Define Search fields on the ADDRESS LU table of the Customer LU. Define the following table columns as Search fields:
- STREET
- CITY
- STATE
- COUNTRY
- ZIP_CODE
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:
- Save the data of the Search fields on each ADDRESS record of Customer 1. Each ADDRESS record creates a separate document in the search index.
Creating Indexes on Search Fields
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:
Example:
Define Search fields on the ADDRESS LU table of the Customer LU. Define the following table columns as Search fields:
- STREET
- CITY
- STATE
- COUNTRY
- ZIP_CODE
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:
- Save the data of the Search fields on each ADDRESS record of Customer 1. Each ADDRESS record creates a separate document in the search index.
