The Search Engine is used to connect Fabric to the Elasticsearch engine when running Search commands. During a search, the Search Engine's interface is populated with the Elasticsearch engine's connection details.
To create a new Search Engine interface:
Parameter |
Description |
Host(s) |
Comma-delimited list of Elasticsearch server hosts and ports. |
User |
User Id |
Password |
User Password |
SSL |
By default, set to False. |
Search fields must be defined on the selected LU table's columns to enable a cross-instance search based on these columns. For example, to enable a search of all customers named "John Doe", define the FIRST_NAME and LAST_NAME columns of the customer schema as search indexes.
To create a search index on a column, do either:
Note that Fabric Studio does not enable defining more than 63 columns in the same LU table as CDC fields, assuming that all columns are positioned according to 1 to 63 in the LU table.
The default built-in types of Search fields are:
Example:
The Search Engine is used to connect Fabric to the Elasticsearch engine when running Search commands. During a search, the Search Engine's interface is populated with the Elasticsearch engine's connection details.
To create a new Search Engine interface:
Parameter |
Description |
Host(s) |
Comma-delimited list of Elasticsearch server hosts and ports. |
User |
User Id |
Password |
User Password |
SSL |
By default, set to False. |
Search fields must be defined on the selected LU table's columns to enable a cross-instance search based on these columns. For example, to enable a search of all customers named "John Doe", define the FIRST_NAME and LAST_NAME columns of the customer schema as search indexes.
To create a search index on a column, do either:
Note that Fabric Studio does not enable defining more than 63 columns in the same LU table as CDC fields, assuming that all columns are positioned according to 1 to 63 in the LU table.
The default built-in types of Search fields are:
Example: