The Table Properties tab appears on the right side of the screen, following a single click on the horizontal label located on the top of the right edge of the screen. The Table Properties can be reached by one of the following two ways:
opening a schema and selecting one of its tables.
double-clicking on an LU from the Project Tree -> double-clicking on Tables -> selecting a table by double-clicking on it.
The Table Properties tab displays a list of properties, by sections, that should be defined for each LU table, as follows:
Section | Property | Description |
---|---|---|
Query Statements Settings |
Columns Collation |
There are 3 options for getting and handling the retrieved data:
|
Full Text Search |
When set to True, it enables the use of MATCH SQLite command as part of the WHERE clause of a Select statement that reads data from a Fabric table. Default = False. Click for more information about the Match command: |
|
Sync |
Sync Method |
There are 4 Sync methods:
|
Delete Mode |
This property defines the delete policy of the previous records in the LU table (populated prior to the current sync). The values are All (default value), Off or NonUpdated: Click here for more information about the Delete Mode. Notes:
|
|
Indexes |
Indexes List |
Sets the table's indexes, as explained here. |
Triggers |
Trigger List | Refers to Trigger functions that are executed when there is a change in LU table's data. To add a Trigger function, click the '+' button and select the function name. Only Trigger functions are displayed. |
Data Change Indexes |
Columns' definitions per CDC Consumer | Refer to the CDC Implementation Steps to learn how to edit this list. |
Description |
Description | The table's description, useful for maintainability and the ongoing project lifecycle, as well as for the GenAI tools that use this information to generate better results. |
The Table Properties tab appears on the right pane of the Table's window.
The Properties tab displays a list of properties that must be defined for each LU table, as follows:
Section | Property | Description |
---|---|---|
Main |
Uneditable fields:
|
|
Instance ID Column |
A unique field used as the LU table Instance ID. |
|
Columns Collation |
There are 3 options:
|
|
Full Text Search |
When set to True, it enables the use of MATCH SQLite command as part of the WHERE clause of a Select statement that reads data from a Fabric table. Default = False. Click for more information about the Match command: |
|
Sync: Delete Mode |
Fabric 6.5.9 adds the Delete Mode property to the LU table. This property replaces the previous Truncate Before Sync LU table's property and defines the delete policy of the previous records in the LU table (populated prior to the current sync). The values are All (default value), Off or NonUpdated: Click here for more information about the Delete Mode. Notes:
|
|
Sync: Sync Method |
There are 4 Sync methods:
|
|
Description |
Description |
The table's description, useful for maintainability and the ongoing project lifecycle, as well as for the GenAI tools that use this information to generate better results. |
Misc |
Enrichment Functions |
Refers to Enrichment Functions that are executed after all LU tables are populated.
To select an Enrichment function, click the 3 dots next to the Enrichment functions property and select the function name. Only functions without input and output parameters are displayed. |
On Change |
Refers to Trigger functions that are executed when there is a change in an LU table's data. To select a Trigger function, click the 3 dots next to the On Change property and select the function name. Only Trigger functions are displayed. |
The Table Properties tab appears on the right side of the screen, following a single click on the horizontal label located on the top of the right edge of the screen. The Table Properties can be reached by one of the following two ways:
opening a schema and selecting one of its tables.
double-clicking on an LU from the Project Tree -> double-clicking on Tables -> selecting a table by double-clicking on it.
The Table Properties tab displays a list of properties, by sections, that should be defined for each LU table, as follows:
Section | Property | Description |
---|---|---|
Query Statements Settings |
Columns Collation |
There are 3 options for getting and handling the retrieved data:
|
Full Text Search |
When set to True, it enables the use of MATCH SQLite command as part of the WHERE clause of a Select statement that reads data from a Fabric table. Default = False. Click for more information about the Match command: |
|
Sync |
Sync Method |
There are 4 Sync methods:
|
Delete Mode |
This property defines the delete policy of the previous records in the LU table (populated prior to the current sync). The values are All (default value), Off or NonUpdated: Click here for more information about the Delete Mode. Notes:
|
|
Indexes |
Indexes List |
Sets the table's indexes, as explained here. |
Triggers |
Trigger List | Refers to Trigger functions that are executed when there is a change in LU table's data. To add a Trigger function, click the '+' button and select the function name. Only Trigger functions are displayed. |
Data Change Indexes |
Columns' definitions per CDC Consumer | Refer to the CDC Implementation Steps to learn how to edit this list. |
Description |
Description | The table's description, useful for maintainability and the ongoing project lifecycle, as well as for the GenAI tools that use this information to generate better results. |
The Table Properties tab appears on the right pane of the Table's window.
The Properties tab displays a list of properties that must be defined for each LU table, as follows:
Section | Property | Description |
---|---|---|
Main |
Uneditable fields:
|
|
Instance ID Column |
A unique field used as the LU table Instance ID. |
|
Columns Collation |
There are 3 options:
|
|
Full Text Search |
When set to True, it enables the use of MATCH SQLite command as part of the WHERE clause of a Select statement that reads data from a Fabric table. Default = False. Click for more information about the Match command: |
|
Sync: Delete Mode |
Fabric 6.5.9 adds the Delete Mode property to the LU table. This property replaces the previous Truncate Before Sync LU table's property and defines the delete policy of the previous records in the LU table (populated prior to the current sync). The values are All (default value), Off or NonUpdated: Click here for more information about the Delete Mode. Notes:
|
|
Sync: Sync Method |
There are 4 Sync methods:
|
|
Description |
Description |
The table's description, useful for maintainability and the ongoing project lifecycle, as well as for the GenAI tools that use this information to generate better results. |
Misc |
Enrichment Functions |
Refers to Enrichment Functions that are executed after all LU tables are populated.
To select an Enrichment function, click the 3 dots next to the Enrichment functions property and select the function name. Only functions without input and output parameters are displayed. |
On Change |
Refers to Trigger functions that are executed when there is a change in an LU table's data. To select a Trigger function, click the 3 dots next to the On Change property and select the function name. Only Trigger functions are displayed. |