Quest Data Modeler supports Microsoft Fabric Lakehouse as a target database. The following sections list all the supported data types and objects along with the Reverse Engineer and Forward Engineer parameters.
Supported Data types
The following table lists the supported data types:
|
Data type |
SQL name |
|---|---|
|
BooleanType |
BOOLEAN |
|
ByteType |
BYTE, TINYINT |
|
ShortType |
SHORT, SMALLINT |
|
IntegerType |
INT, INTEGER |
|
LongType |
LONG, BIGINT |
|
FloatType |
FLOAT, REAL |
|
DoubleType |
DOUBLE |
|
DateType |
DATE |
|
TimestampType |
TIMESTAMP. TIMESTAMP_LTZ |
|
TimestampNTZType |
TIMESTAMP_NTZ |
|
StringType |
STRING |
|
CharType(length) |
CHAR(length) |
|
VarcharType(length) |
VARCHAR(length) |
|
BinaryType |
BINARY |
|
DecimalType |
DECIMAL, DEC, NUMERIC |
|
YearMonthlntervaIType |
INTERVAL YEAR. INTERVAL YEAR TO MONTH. INTERVAL MONTH |
|
DayTimelntervalType |
INTERVAL DAY, INTERVAL DAY TO HOUR, INTERVAL DAY TO MINUTE, INTERVAL DAY TO SECOND, INTERVAL HOUR, INTERVAL HOUR TO MINUTE, INTERVAL HOUR TO SECOND, INTERVAL MINUTE, INTERVAL MINUTE TO SECOND, INTERVAL SECOND |
Supported Objects
The following list summarizes the objects supported under Microsoft Fabric Lakehouse. You can use the Quick Editor to edit any of these object properties. For more information on using the Quick Editor, refer to the Model Properties topic.
Note: You can use the Ctrl+Z and Ctrl+Y keyboard shortcuts to undo and redo changes in any property field.
Annotations
The following table lists the supported annotation object properties:
| Tab | Section | Property | Description | Additional Information |
|---|---|---|---|---|
| Properties | Name | Specifies the name of the annotation | ||
| Type | Specifies the type of the annotation | Available types include Cross, Diamond, Ellipse, Hexagon, and others. | ||
| Physical Only | Indicates whether the annotation applies only to the physical model | |||
| Text Editor | Specifies the text in an annotation | Use this to add or edit text in an annotation. | ||
| Definition | Specifies annotation description or business meaning | Use  to open the Definition Editor to edit annotation descriptions. Select Save to apply changes or Cancel to discard them. |
Databases
The following table lists the supported database object properties:
|
Tab |
Property |
Description |
|---|---|---|
| Properties | Name | Specifies the name of the database |
| Generate | Specifies whether a DDL statement is generated for the database during forward engineering | |
| If Not Exists | Specifies that if the database already exists, no exception is thrown, and no action happens |
Datatype Standards
The following table lists the supported Datatype Standards object properties:
| Tab | Section | Property | Description | Additional Information |
|---|---|---|---|---|
| Properties | Name | Specifies the name of the datatype standard | ||
| Is Active | Indicates whether the datatype standard is enabled for use | |||
| Logical Definition | Datatype | Specifies the logical datatype definition | ||
| Domain | Specifies the domain associated with the datatype | |||
| Length | Specifies the length of the datatype | |||
| Precision | Specifies the precision of numeric datatypes | |||
| Default Length | Specifies the default length of the datatype | |||
| Mapping | Name | Specifies the name of the datatype mapping | ||
| From | Specifies the source datatype | |||
| To | Specifies the target datatype | |||
| Definition | Specifies the detailed description or business meaning of the datatype standard | Use  to open the definition editor. |
Default Values
The following table lists the supported Default Values object properties:
| Tab | Property | Description |
|---|---|---|
| Properties | Physical Name | Specifies the physical name used in the database |
| Value | Specifies the value assigned to the object | |
| Physical Only | Indicates whether the default value applies only to the physical model |
Domains
The following table lists the supported Domains object properties:
| Tab | Section | Property | Description | Additional Information |
|---|---|---|---|---|
| Properties | Name | Specifies the name of the domain | ||
| Physical Name | Specifies the physical name of the domain | |||
| Harden Strategy | Specifies several parameters and practices aimed at enhancing security and reliability | Inherit: Specifies to inherit the domain physical name Override: Specifies to override inheritance for the domain physical name Harden: Specifies to harden the domain physical name |
||
| Domain Parent | Lets you select a domain from the list and attach it to the selected domain as a parent | |||
| Physical Data Type | Lets you select a data type from the drop-down list to apply to the selected domain | If the selected data type requires a value for precision, scale, or both, enter the value inside the data type parentheses. | ||
| Null Option | Specifies the usage of the NULL clause for the selected domain | Null: Indicates that null values are allowed Not Null: Indicates that null values are not allowed |
||
| Physical Only | Specifies that the selected domain is only available in the physical model | |||
| Constraint | Check Constraints | Use Inherited Constraint | Specifies whether the validation rule is inherited from the parent domain | |
| Name | Specifies the name of the inherited validation rule to be attached to the selected domain | |||
| Validation | Specifies the validation rule to attach to the selected domain | Available when Use Inherited Constraint is not selected. | ||
| Default | Use Inherited Default Value | Specifies whether the property is inherited from the parent domain | ||
| Name | Specifies the name of the default value to be attached to the selected domain | |||
| Default | Specifies the default value to attach to the selected domain | Available when Use Inherited Default Value is not selected. | ||
| Definition | Specifies the detailed description or business meaning of the domain |
ER Diagrams
The following table lists the supported properties for the ER Diagrams object:
| Tab | Section | Property | Description | Additional Information |
|---|---|---|---|---|
| Properties | Name | Specifies the name of the ER diagram | ||
| Logical Physical View Mode | Specifies whether the diagram is displayed in logical or physical view | Logical: Specifies display of logical model elements Physical: Specifies display of physical database elements |
||
| Auto-populate | Indicates whether objects are automatically added to the diagram | |||
| General Options | Author | Specifies the author of the diagram | ||
| Optional Theme | Theme | Specifies the theme applied to the diagram | Classic Theme: Specifies standard visual styling DARK Theme: Specifies dark theme styling Default Theme: Specifies system default theme |
|
| Optional override to theme background fill | Fill Options | |||
| Members | Available Objects | Name | Specifies the name of the available object | |
| Type | Specifies the type of the available object | |||
| Included Objects | Name | Specifies the name of the included object in the diagram | ||
| Type | Specifies the type of the included object | |||
| Relationships | Available Relationships | Name | Specifies the name of the available relationship | |
| Type | Specifies the type of the available relationship | |||
| Parent | Specifies the parent in the available relationship | |||
| Child | Specifies the child in the available relationship | |||
| Included Relationships | Name | Specifies the name of the included relationship | ||
| Type | Specifies the type of the included relationship | |||
| Parent | Specifies the parent in the included relationship | |||
| Child | Specifies the child in the included relationship | |||
| Layout | Manual Layout | Allow Manual Relationship Layout | Indicates whether relationship lines can be manually arranged | |
| Allow Manual Entity Resizing | Indicates whether entity can be manually resized | |||
| Grid Alignment | Align Objects to Grid | Aligns entities, tables, or views to the nearest vertical and horizontal gridlines | ||
| Alignment Grid Spacing | Defines the distance in pixels between the gridlines | |||
| Align Grid Color | Defines the grid color. | |||
| Visual Cues | Show Page Grid | Displays a grid for the diagram | ||
| Show Background | Displays a background for the diagram | |||
| Show Callout | Displays callouts for the relationship texts in the diagram | |||
| Selection Grips Color | Defines the color of the grip that surrounds a selected object |
Functions
The following table lists the supported function object properties:
|
Tab |
Section |
Property |
Description |
Additional |
|---|---|---|---|---|
| Properties |
Properties | Name | Specifies the name of the function object | |
| Generate | Specifies whether an SQL statement is generated during forward engineering | |||
| If Not Exists | Specifies that if the function already exists, no exception is thrown, and no action happens | |||
| Is Temporary | Specifies whether the scope of the function is temporary | |||
| Schema | Specifies the schema for the function | |||
| General |
Class Name |
Specifies the name of the class for function's implementation | ||
|
Resource Locations |
Specifies the list of resources containing the function implementation and its associated dependencies | |||
| Code | Specifies the SQL statement used to create the function | Use to open the definition editor. |
||
| Expanded | Displays the expanded code for the function in read-only format. |
Naming Standards
The following table lists the supported Naming Standards object properties:
| Tab | Section | Property | Description | Additional Information |
|---|---|---|---|---|
| Logical | Entity | Specifies the naming standard format for logical entity names |
Specifies how name components are constructed using predefined parts. Prime – Specifies the core noun or primary business term Modifier 1 (M1) – Specifies the first qualifier describing the prime Modifier 2 (M2) – Specifies the second qualifier providing additional context Class (C) – Specifies the type or classification of the object
|
|
| Attribute | Specifies the naming standard format for logical attribute names | |||
| Domain | Specifies the naming standard format for logical domainSpecifies the naming standard format for physical column names | |||
| Physical | Table | Specifies the naming standard format for physical table names | ||
| Column | Specifies the naming standard format for physical column names | |||
| Domain | Specifies the naming standard format for logical domain names | |||
| Glossary | Word/Words | Specifies the business terms used to define naming standards | ||
| Abbreviation | Specifies the standardized abbreviation for a word | |||
| Alt Abbreviation | Specifies an alternate abbreviation for the word | |||
| P, M, M1, M2, C | Indicates the role of the word in the naming structure |
|
||
| Definition | Specifies the description or meaning of the glossary word | |||
| Definition | Specifies the detailed description or purpose of the naming standard | Use to open the Definition Editor to edit naming standard descriptions. Select Save to apply changes or Cancel to discard them. |
Relationships
The following table lists the supported Relationships object properties:
| Tab | Section | Property | Description | Additional Information |
|---|---|---|---|---|
| Properties | Name | Specifies the name of the relationship | ||
| Physical Name | Specifies the physical name used in the database | |||
| Parent Entity | Specifies the name of the parent entity | This field is read-only. | ||
| Child Entity | Specifies the name of the child entity | This field is read-only. | ||
| Harden Strategy | Specifies how inherited relationship properties are applied |
Inherit: Specifies that properties are inherited from the parent Override: Specifies that inherited properties can be modified Harden: Specifies that inherited properties are fixed |
||
| Generate | Specifies whether a SQL statement for the relationship is generated | |||
| Type Properties | Types | Specifies the type of relationship | Identifying : Specifies that the child entity is dependent on the parent entity for its identity Non-Identifying: Specifies that the child entity is not dependent on the parent entity for its identity |
|
| Relationship Properties | Parent-to-Child Phrase | Specifies the verb phrase describing the relationship from parent to child | ||
| Child-To-Parent Phrase | Specifies the verb phrase describing the relationship from child to parent | |||
| Cardinality Properties | Cardinality | Specifies the relationship cardinality between parent and child entities |
Zero, One, or More: Specifies optional many relationship One or More (P): Specifies mandatory many relationship Zero or One (Z): Specifies optional one relationship |
|
| Cardinality Value | Specifies the numeric representation of the cardinality | |||
| Role Name | Migrated Key/Index | Key Group | Specifies the key group that is migrated through the relationship | |
| Role Name Info | Migrated Attribute | Indicates whether the attribute is migrated through the relationship | ||
| Logical Roles Name | Specifies the logical role name used to identify the relationship | |||
| Physical Role Name | Specifies the physical role name used to identify the relationship | |||
| RI Actions | RI Actions | Child Delete Rule | Specifies the action applied to child records when the parent is deleted |
Restrict: Prevents deletion if dependent records exist Cascade: Deletes dependent child records automatically Set Null: Sets foreign key values to null Set Default: Sets foreign key values to default No Action: Defers constraint handling |
| Child Insert Rule | Specifies the action applied when inserting child records | |||
| Child Update Rule | Specifies the action applied when updating child records | |||
| Parent Delete Rule | Specifies the action applied when deleting parent records | |||
| Parent Insert Rule | Specifies the action applied when inserting parent records | |||
| Parent Update Rule | Specifies the action applied when updating parent records | |||
| Match Option | Specifies the matching behavior for referential integrity |
Match Simple: Specifies simple matching of columns Match Full: Specifies full matching across all columns Match Partial: Specifies partial matching |
||
| Trigger Template | Trigger Template | Child Delete Trigger Template | Specifies the trigger template for child delete operations | |
| Child Insert Trigger Template | Specifies the trigger template for child insert operations | |||
| Child Update Trigger Template | Specifies the trigger template for child update operations | |||
| Parent Delete Trigger Template | Specifies the trigger template for parent delete operations | |||
| Parent Insert Trigger Template | Specifies the trigger template for parent insert operations | |||
| Parent Update Trigger Template | Specifies the trigger template for parent update operations |
Schemas
The following table lists the supported schema object properties:
|
Tab |
Property |
Description |
|---|---|---|
| Properties | Name | Specifies the name of the schema object |
| Generate | Specifies whether an SQL statement is generated for the schema | |
| If Not Exists | Specifies that if the schema already exists, no exception is thrown, and no action occurs |
Subject Areas
The following table lists the supported Subject Areas object properties:
| Tab | Section | Property | Description | Additional Information |
|---|---|---|---|---|
| Properties | Properties | Name | Specifies the name of the subject area | |
| Auto Populate | Indicates whether objects are automatically added to the subject area | |||
| General | Common Properties | Author | Specifies the email id of the author of subject area | |
| Exclude Dangling Relationships From Schema generation | Indicates whether incomplete relationships are excluded from schema generation | |||
| Optional Theme | Theme | Specifies the theme applied to the subject area. |
Classic Theme: Specifies standard visual styling DARK Theme: Specifies a dark visual theme Default Theme: Specifies the system default theme |
|
| Members | Available Objects | Name | Specifies the name of the available object | |
| Type | Indicates the type of object | |||
| Physical Only | Specifies whether the object is included in the physical model only | |||
| Included Objects | Name | Specifies the name of the object included in the subject area | ||
| Type | Indicates the type of the included object | |||
| Physical Only | Specifies whether the object is included in the physical model only | |||
| Definition | Specifies the detailed description or purpose of the subject area | Use to open the Definition Editor to edit subject area descriptions. Select Save to apply changes or Cancel to discard them. |
Tables
The following table lists the supported Table object properties:
|
Tab |
Section |
Property |
Description |
Additional Information |
|---|---|---|---|---|
| Properties
|
Table Properties | Harden Strategy | Specifies the name of the hardening strategy for a table | |
| Schema | Specifies the schema for the table | |||
|
External |
Specifies whether the table is an external table |
|
||
| Physical Name | Specifies the physical name of the table | |||
|
Create Table As |
Specifies whether the table should be created based on the results of a SELECT statement |
This enables the fields on the Select tab of the Table editor. Specify the SQL SELECT statement to be used. |
||
| If Not Exists | Specifies that if the table already exists, no exception is thrown, and no action happens | |||
| Physical Only | Specifies whether the table is suppressed from a logical model and appears in a physical model only | |||
| Generate | Specifies whether an SQL statement is generated during forward engineering | |||
| General Options |
Data Source |
Specifies the data source that contains the location of data |
|
|
|
Location |
Specifies the folder or the file path where the table is stored |
Available only when the table is an External table |
||
|
Stored As |
Specifies the file format for table storage |
|
||
|
Like Table |
Specifies a table from which the new table automatically copies all column names, their data types, and their not-null constraints |
|
||
| Table Properties |
Value |
Specifies the table value property |
||
| Columns | Name | Specifies the column name | ||
| Physical Data Type | Specifies the datatype of the column | |||
| Type | Indicates the column type classification. | |||
| Null Option Type | Indicates whether null values are allowed for the column | |||
|
Select |
|
Specifies the select statement in read-only format to select tables and columns | ||
| Bucketing and Partition | Partition By | Selected | Specifies the selected column(s) | |
| Column | Specifies the column(s) used to divide the table into partitions | |||
| Clustered By | Selected | Specifies the selected column(s) | ||
| Column | Specifies the column(s) used to physically cluster or group data within partitions | |||
| Sorted By | Selected | Specifies the selected column(s) | ||
| Column | Specifies the column(s) used to order rows within partitions or buckets | |||
| Sort Order | Specifies the order of sorting of columns | |||
| Options | Key | Specifies the key of the option | ||
| Value | Specifies the value of the option | |||
| Bucket Option | Number of Buckets | Specifies the number of buckets into which data is distributed when bucketing is applied | ||
| Row Format Properties | Row Format | Serde Handler Class | Specifies the serialization/deserialization (SerDe) handler class used to interpret how table data is read and written | |
| Fields Terminated By | Specifies the character used to separate individual fields in each row of the table | |||
| Fields Escaped By | Specifies the character used to escape special characters within field values | |||
| Collection Items Terminated By | Specifies the character used to terminate items within a collection-type field | |||
| Map Keys Terminated By | Specifies the character used to separate keys from values in a map-type field | |||
| Lines Terminated By | Specifies the character used to mark the end of each row or line in the table data | |||
| Null Defined As | Specifies the representation used to denote null values in the table data | |||
| Serde Properties | Specifies the properties passed to the SerDe handler to control its behavior and configuration | Use to open the definition editor |
Table Columns
The following table lists the supported Table Column object properties:
|
Tab |
Section |
Property |
Description |
Additional Information |
|---|---|---|---|---|
| Properties | Properties | Primary Key | Specifies whether the column is set as a primary key for the table | |
| Foreign Key | Specifies whether the column is set as a foreign key for the table | |||
| Physical Only | Specifies whether the column is included in the physical model only | |||
| SDI | Specifies whether the column contains sensitive data | |||
| Generate | Specifies whether an SQL statement is generated during forward engineering | |||
| General Options | Name | Specifies the name of the column | ||
| Physical Name | Specifies the physical name of the column | |||
| Harden Strategy |
Specifies the name of the hardening strategy for a column |
|||
| Physical Data Type | Specifies the physical data type of the column | |||
| Collation | Specifies the collation for the column | |||
| Null Option | Specifies the null option for the selected column |
Null: Indicates that null values are allowed Not Null: Indicates that null values are not allowed |
||
| Domain | Specifies the domain of the column |
Table Indexes
The following table lists the supported Table Index object properties:
|
Tab |
Property |
Description |
Additional Information |
|---|---|---|---|
| General | Name | Specifies the name of the table index | |
| Definition | Specifies the definition of the table index | ||
| Do Not Generate | Specifies that the table indexes should not be automatically generated | ||
| Constraint Option | Specifies the type of constraint enforced by the index | ||
| Properties | Physical Only | Specifies that the index applies strictly to the physical storage structure | |
| Members | Key Group Members | Specifies the key group members included in the index definition | |
| General |
Not Enforced | Specifies whether validation is enforced on the index | |
|
Clustered |
Specifies whether the index is clustered or non-clustered |
||
|
Drop Existing |
Indicates that the existing index must be dropped and a new index should be created | ||
|
Partition Modification Type |
Specifies the action type to be performed in case of a partitioned index |
Rebuild: Indicates that the index will be rebuilt using the same columns, index type, uniqueness attribute, and sort order Disable: Marks the index as disabled and unavailable for use by the Database Engine Reorganize: For columnstore indexes, REORGANIZE compresses each CLOSED delta rowgroup into the columnstore as a compressed rowgroup |
|
| Rebuild Partition Type | Specifies whether all or specific partitioned indexes are rebuilt | Available only when the Partition Modification Type is set to Rebuild |
Themes
The following table lists the supported Themes object properties:
Note: These properties are applicable to the Classic, Dark, and Default themes. All themes provide the same configuration options for customizing fonts, colors, fill, and lines.
| Tab | Section | Property | Description |
|---|---|---|---|
| Properties | Name | Specifies the name of the theme | |
| Diagram Fill | Specifies the background color of the diagram canvas | ||
| Entity Fill | Specifies the background color of entities in the diagram | ||
| FK Attribute Font | Specifies the font style applied to foreign key attribute | ||
| FK Attribute Fill | Specifies the fill color for foreign key attributes | ||
| Default Font | Specifies the default font used across the theme | ||
| Entity Font | Specifies the font used for entity names | ||
| Attribute Font | Specifies the font used for attribute names | ||
| Defaults | Font Settings | Font Options | Specifies the default font configuration for diagram elements |
| Fill Settings | Fill Options | Specifies the default fill color settings | |
| Line Settings | Line Options | Specifies the line style for relationships and connectors | |
| Outline Settings | Outline Options | Specifies the border style for diagram objects | |
| Diagram Fill | Fill Options | Specifies the default background color of the diagram | |
| Entity | Name Display | Font Options | Specifies the font used to display entity names |
| Fill Options | Specifies the background color for entity names | ||
| Outline Options | Specifies the border styling for entity name display | ||
| Definition Display | Font Options | Specifies the font used for displaying entity definitions | |
| Fill Options | Specifies the background color for definitions | ||
| Outline Options | Specifies the border styling for definition sections | ||
| Attribute | Owned Attribute Font | Font Options | Specifies the font applied to owned (non-key) attributes |
| Foreign Key Style Inheritance | Font Inheritance Type | Specifies whether foreign key attributes inherit font settings | |
| Color Inheritance Type | Specifies whether foreign key attributes inherit color settings | ||
| Foreign Key Attribute Font | Font Options | Specifies the font used for foreign key attributes | |
| Foreign Key Attribute Color | Color | Specifies the color applied to foreign key attributes | |
| Key | Key Display Preference | Style Preference | Specifies how key styles are displayed when multiple key types apply |
| Alternate Key (AK) Attribute Font | Font Options | Specifies the font used for alternate key attributes | |
| Inversion Entry (IE) Attribute Font | Font Options | Specifies the font used for inversion entry attributes | |
| View | Name Display | Font Options | Specifies the font used to display view names |
| Fill Options | Specifies the background color for view names | ||
| Outline Options | Specifies the border styling for view name display | ||
| Definition Display | Font Options | Specifies the font used for view definitions | |
| Fill Options | Specifies the background color of the definition section | ||
| Outline Options | Specifies the border styling for the definition section | ||
| Attribute Display Fonts | Font Options (Left / Right panels) | Specifies the font used for displaying attributes within views | |
| Relationship | Style Inheritance | Relationship Font Inherited From Parent | Indicates whether the relationship text font is inherited from the parent object |
| Relationship Line Color Inherited From Parent | Indicates whether the relationship line color is inherited from the parent element | ||
| Relationship Text Color Inherited From Line | Indicates whether the relationship text color follows the line color | ||
| Relationship Text Font | Font Options | Specifies the font used for relationship labels | |
| Relationship Text Color | Color | Specifies the color used for relationship text | |
| Relationship Line Style | Line Width | Specifies the thickness of relationship lines | |
| Color | Specifies the color of relationship lines | ||
| Subtype Symbol | Style Inheritance | Subtype Symbol Font Inherited From Parent | Indicates whether subtype symbol font is inherited from the parent |
| Subtype Symbol Line Color Inherited From Parent | Indicates whether the subtype symbol line color is inherited | ||
| Subtype Symbol Text Color Inherited From Line | Indicates whether subtype symbol text color follows the line color | ||
| Subtype Symbol Text Font | Font Options | Specifies the font used for subtype symbols | |
| Subtype Symbol Text Color | Color | Specifies the color of subtype symbol text | |
| Subtype Symbol Style | Line Width | Specifies the thickness of subtype symbol lines | |
| Color | Specifies the color used for subtype symbol lines | ||
| Fill Options | Specifies the fill color for subtype symbols | ||
| Annotation/Shape | Annotation/Shape Text Font | Font Options | Specifies the font used for annotation and shape text |
| Annotation/Shape Text Handling | Annotation Text Vertical Alignment | Specifies the vertical alignment of annotation text | |
| Annotation Text Horizontal Alignment | Specifies the horizontal alignment of annotation text | ||
| Annotation Text Handling Style | Specifies how text is displayed within shapes | ||
| Annotation/Shape Fill | Fill Options | Specifies the background color of annotation or shape objects | |
| Annotation/Shape Line | Line Options | Specifies the line style used for annotation borders | |
| Specifies the line style used for annotation borders. | Outline Options | Specifies the outline style for annotation shapes | |
| Definition | Specifies the detailed description or purpose of the theme |
Views
The following table lists the supported View object properties:
| Tab | Section | Property | Description | Additional Information |
|---|---|---|---|---|
| Properties | Properties | Name | Specifies the name of the view | |
| Generate | Specifies whether an SQL statement is generated for the view | |||
| Schema | Specifies the schema in which the view resides | |||
| If Not Exists | Specifies that if the view already exists, no exception is thrown, and no action happens | |||
| View Type | Specifies the type of view |
|
||
| General Options | Schema Binding | Specifies that the view is bound to the underlying schema objects | ||
| TBL Properties | Key | Specifies the key of the table property | ||
| Value | Specifies the value of the table property | |||
| Select | Available Table and Views | Name | Specifies the names of tables and views that can be selected as sources for the view definition | |
| Type | Specifies the types (e.g., table, view) of objects that can be selected as sources for the view definition | |||
| Columns | Name | Specifies the column names included in the view’s select statement | ||
| Alias/Column | Specifies the alias names assigned to columns in the view’s select statement | |||
| Expression/Value | Specifies the values or expressions defined for columns in the view’s select statement | |||
| Type | Specifies the type of view column | |||
| Select Options | Select Type | Select the view type: All or Distinct | ||
| From | Available Table and Views | Name | Specifies the names of tables and views that can be referenced in the FROM clause of the view definition | |
| Type | Specifies the types (for example, table and view) of objects that can be referenced in the FROM clause of the view definition | |||
| FROM | Name | Specifies the table or view name used in the FROM clause of the view definition | ||
| Alias | Specifies the alias assigned to a table or view in the FROM clause for simplified reference | |||
| Type | Specifies the view type associated with the FROM clause |
To view the common object properties that are supported in Fabric Lakehouse, refer to the Common Object Properties topic.
RE Parameters
The following sections explain the reverse engineering options for Microsoft Fabric Lakehouse.
Overview
The following table lists the overview parameters:
|
Parameter |
Description |
Additional Information |
|---|---|---|
| Reverse Engineer Source | Specifies whether you want to reverse engineer from a script or database |
Database: Indicates that the model is reverse engineered from a database Script File: Indicates that the model is reverse engineered from a script |
| Type | Specifies the model type for selection | Provides option to choose the type of model between Physical or Logical/Physical |
| Database | Specifies a list of supported databases | |
| Version | Specifies the version of the selected database | |
| Script File | Specifies the script file location |
This option is available only when Script File is selected as a Reverse engineer source. Click Browse and select a script file from your directory. |
Connection
The following table lists the connection parameters:
|
Parameters |
Description |
|---|---|
| Authentication | Specifies the database connection authentication type. |
|
Connection Type |
Specifies the type of connection required to connect to the database. Select the type of connection as JDBC to connect to the database. Currently, only JDBC is supported. |
|
Client ID |
Specifies the unique identifier of the OAuth application used to connect to the cloud database required for databases that use OAuth authentication. |
|
Client Secret |
Accepts a confidential key associated with the Client ID used to securely obtain an access token from the OAuth provider during database connection. |
|
Lakehouse |
Identifies the virtual compute lakehouse that the database uses to execute queries. |
|
Server Name |
Specifies the host name or endpoint of the database server for reverse engineering. |
|
Port |
Defines the network port used by the database server to accept incoming connections. |
Schemas
The following table lists the schema parameters:
| Parameter | Description |
|---|---|
| Available Schemas | Displays the available schemas |
| Selected Schemas | Displays the selected schemas |
Tables
The following table lists the table parameters:
| Parameter | Description |
|---|---|
| Available Tables | Displays the available tables |
| Selected Tables | Displays the selected tables |
Views
The following table lists the view parameters:
| Parameter | Description |
|---|---|
| Available Views | Displays the available views |
| Selected Views | Displays the selected views |
Options
The following table lists the schema parameters:
| Parameter | Description | Additional Information |
|---|---|---|
| Option Set | Specifies the option set template for reverse engineering |
Open: Use this option to open a saved XML option set file. Save: Use this option to save the configured option set. Save As: Use this option to save an option set either in the model or in the XML format at some external location. Delete: Use this option to delete an option set. |
| <Option Set Name> | Specifies the objects to be reverse engineered according to the selected option set. You can edit this list. |
FE Parameters
The following sections explain the forward engineering options for Microsoft Fabric Lakehouse.
Option Selection
The following table lists the option selection parameters:
| Parameter | Description | Additional Information |
|---|---|---|
| Option Set | Specifies options to manage Option Sets for forward engineering an alter script |
Open: Use this option to open a saved XML option set file. Save: Use this option to save a configured option set. Save As: Use this option to save an option set in the XML format. Delete: Use this option to delete an option set. |
| Azure Synapse Schema Generation |
Displays available schema generation groups for the database objects from which you can select schema generation options. Based on the database object selection, the right-side pane displays available schema generation options for the selected object in schema generation group. |
|
| Database Template | Displays the default database template for the selected target server, or the name of the customized template currently in use. You can browse to change the template, edit, or reset it. |
Owner Override
The following table lists the owner override parameters:
| Parameter | Description | Additional Information |
|---|---|---|
| Object Name | Displays available objects for owner override. Enter an owner name in the Global Override object to override all assignments for the listed object groups | The list of available objects is based on the current target server and may include the following object groups: Table, Index, View, Materialized View, Trigger, Sequence, Synonym, Cluster, Cluster Index, and Library |
| Owner Override | Specifies the owner name to override assignments of the owner for that object group |
Object Filter
The following table lists the object filter parameters:
| Parameter | Description | Additional Information |
|---|---|---|
| Object | Specifies the selected objects such as tables, collections, records, nodes, documents, user types, and views for the schema generation. |
The object differs based on your database. |
| Display either Logical Names or Physical Names | Specifies a list of name types for the tables |
Logical Names: Indicates that only logical names of the tables are included in the generated schema. Physical Names: Indicates that only physical names of the tables are included in the generated schema. Physical Names, show owner: Indicates that physical names and owners of the tables are included in the generated schema. Physical Names, show owner using User: Indicates that the physical names and owners of the tables are included in the generated schema. Owners of the tables are displayed using User. |
| Select all the items in the list | Use this option to select all the tables in the list. |
|
| Unselect all the items in the list | Use this option to unselect all the tables. | |
| Select all unselected items, and unselect all selected items | Use this option to select all the unselected tables and deselect all the previously selected tables. | |
|
Search Object |
Use this option to search objects such as tables, collections, and views based on your database. |
|
| Tables Filtered By | Specifies whether to filter table objects based on table, tablespace, or database. | Applicable to AlloyDB, Db2 for z/OS, Db2 for LUW, Oracle, Redshift, Snowflake, and SQL Server databases. |
|
Apply selection of Tables to Tablespaces and Databases |
Specifies whether to apply the table selection to the tablespace or the database. |
Applicable to Db2 for LUW and Db2 for z/OS databases. |
Preview
The following table lists the preview parameters:
| Parameter | Description | Additional Information |
|---|---|---|
| Text | Displays the schema in the text editor |
Commit to Git: Use this option to commit the FE script to a Git repository. Save: Use this option to save the generated schema. Find: Use this option to search through the generated schema. Print: Use this option to print the generated schema. Copy: Use this option to copy the selected text in the schema. Replace: Use this option to find and replace text in the generated schema. Fullscreen : Use this option for full screen mode. |
Connection
The following table lists the connection parameters:
|
Parameters |
Description |
|---|---|
| Authentication | Specifies the database connection authentication type. |
|
Connection Type |
Specifies the type of connection required to connect to the database. Select the type of connection as JDBC to connect to the database. Currently, only JDBC is supported. |
|
Client ID |
Specifies the unique identifier of the OAuth application used to connect to the cloud database required for databases that use OAuth authentication. |
|
Client Secret |
Accepts a confidential key associated with the Client ID used to securely obtain an access token from the OAuth provider during database connection. |
|
Lakehouse |
Identifies the virtual compute lakehouse that the database uses to execute queries. |
|
Server Name |
Specifies the host name or endpoint of the database server for reverse engineering. |
|
Port |
Defines the network port used by the database server to accept incoming connections. |