LU Views
Overview
Starting from Fabric V6.5.8, LU views are introduced to Fabric.
LU views are designed to keep a pre-defined query on LU tables in the Fabric MicroDB, allowing an easy access to a required data collection.
The SQL statement of the LU view can include a SELECT statement from one LU table or several joint LU tables. Additionally, it supports the use of LUDB functions.
LU views are part of the Logical Unit definition; however, they are not part of the LU Schema. LU views are populated with data at the end of the sync process, after all LU tables population has been completed.
LU view's column data type is the same as the respective LU table's column data type. LU views don't have their own properties and can't be indexed.
There are two techniques in which LU view data can be accessed: either via a direct querying of an instance's MicroDB or via the Declarative field level authorization mechanism. When using the latter technique, the query on an LU table is replaced by a query on an LU view. This replacement is based on a security profile of a Fabric user's role.
Click for more information about Declarative field level authorization mechanism.
Note that once an LU view is connected to a security profile, it cannot be accessed directly by a query on MicroDB. This restriction is done in order to prevent unauthorized access to sensitive data.
Click for more information about Security Profiles.
How Do I Create a New LU View?
- Go to Project Tree > Logical Units > [LU Name], right-click Views > New View to display the View window.
- Create an SQL statement that represents the view. You can do it by either clicking on Open Query Builder or by writing the query manually.
- Once the query is ready, click on Validate Query in order to validate the syntax.
- Save the view.
LU Views
Overview
Starting from Fabric V6.5.8, LU views are introduced to Fabric.
LU views are designed to keep a pre-defined query on LU tables in the Fabric MicroDB, allowing an easy access to a required data collection.
The SQL statement of the LU view can include a SELECT statement from one LU table or several joint LU tables. Additionally, it supports the use of LUDB functions.
LU views are part of the Logical Unit definition; however, they are not part of the LU Schema. LU views are populated with data at the end of the sync process, after all LU tables population has been completed.
LU view's column data type is the same as the respective LU table's column data type. LU views don't have their own properties and can't be indexed.
There are two techniques in which LU view data can be accessed: either via a direct querying of an instance's MicroDB or via the Declarative field level authorization mechanism. When using the latter technique, the query on an LU table is replaced by a query on an LU view. This replacement is based on a security profile of a Fabric user's role.
Click for more information about Declarative field level authorization mechanism.
Note that once an LU view is connected to a security profile, it cannot be accessed directly by a query on MicroDB. This restriction is done in order to prevent unauthorized access to sensitive data.
Click for more information about Security Profiles.
How Do I Create a New LU View?
- Go to Project Tree > Logical Units > [LU Name], right-click Views > New View to display the View window.
- Create an SQL statement that represents the view. You can do it by either clicking on Open Query Builder or by writing the query manually.
- Once the query is ready, click on Validate Query in order to validate the syntax.
- Save the view.
