Microsoft Fabric Warehouse

Quest Data Modeler supports Microsoft Fabric Warehouse 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

Numeric

String and Binary

Date and Time

Other

  • float[(n)]

  • real[(n)]

  • decimal[(precision [ , scale])]

  • numeric[(precision [ , scale])]

  • money

  • smallmoney

  • bigint

  • int

  • smallint

  • tinyint

  • bit

  • nvarchar[n]

  • nvarchar[max]

  • nchar[(n)]

  • varchar[n]

  • varchar[max]

  • char[(n)]

  • varbinary[n]

  • varbinary[max]

  • binary[(n)]

  • text
  • ntext

  • datetimeoffset[(n)]

  • datetime2[(n)]

  • datetime

  • smalldatetime

  • date

  • time[(n)]

  • uniqueidentifier

  • cursor
  • geography
  • geometry
  • hierarchyid
  • json
  • vector
  • rowversion
  • sql_variant
  • table
  • xml

Supported Objects

The following list summarizes the objects supported under Microsoft Fabric Warehouse. 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.

Functions

Tab Section Property Description Additional Information
Properties Properties Name Specifies the name of the function  
Schema Specifies the name of the schema  
Use ALTER Syntax Specifies that the function definition can be modified using the ALTER syntax  
Generate Specifies the function should be automatically generated  
Function Type Function Type Specifies the type of function

Scalar: Accepts input parameters and returns a single value, such as a number, string, or date

Inline Table-Valued: Accepts input parameters and returns a table result set generated by a single SELECT statement.
Parameters   Name Specifies the name of the parameter within the function  
Physical Data Type Specifies the physical storage data type of the parameter  
Default Value Specifies the default value of the parameter  
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.  

Schemas

Tab Section Property Description
Properties Properties Name Specifies the name of the schema object
Owner Specifies whether an SQL statement is generated for the schema
Generate Specifies that if the schema already exists, no exception is thrown, and no action happens

Stored Procedures

Tab Section Property Description Additional Information
Properties Properties Name Specifies the name of the stored procedure object  
Schema Specifies the name for the schema  
Use ALTER Syntax Specifies that the view definition can be modified using the ALTER syntax  
Generate Specifies that the stored procedure should be automatically generated in scripts or metadata exports  
Parameters   Name Specifies the name of the parameter within the stored procedure definition  
Physical Data Type Specifies the physical storage data type of the parameter  
Output Parameter Specifies that the parameter is defined as an output parameter  
Stored Procedure Definition   As Stored Procedure Definition Specifies the actual definition or body of the stored procedure Use to open the definition editor.
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.  

Tables

Tab

Section

Property

Description

Additional Information
Properties

 

 Properties Harden Strategy Specifies the name of the hardening strategy for a table  
Physical Name Specifies the physical name of the table  

Warehouse Name

Specifies the name of the warehouse for 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.
Schema Specifies the name of the schema  
Physical Only Specifies whether the table is suppressed from a logical model and appears in a physical model only  
Table As Clone Specifies whether the table can be used as a clone  
Generate Specifies whether an SQL statement is generated during forward engineering  

Columns

  

Name

 Specifies the name of the column

 

Physical Data Type

 Specifies the physical storage data type of the column

 

Type

 Specifies the logical type or role of the column

 

Null Option Type

 Specifies whether the column allows null values or enforces a NOT NULL constraint

 

Select

 

 

 Specifies the select statement in read only format to select tables and columns This tab is available only when the Create Table As option is selected.
SQL     Specifies SQL statement for the table in read only format  

Views

Tab Section Property Description
Properties Properties Name Specifies the name of the view
Generate Specifies that the view should be automatically generated in scripts or metadata exports
Schema Binding Specifies that the view is bound to the underlying schema objects
Use ALTER Syntax Specifies that the view definition can be modified using the ALTER syntax
Schema Specifies the schema in which the view resides
Select Available Tables 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 Tables 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 (e.g., table, 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
Where Where Where Specifies the WHERE clause
  Group By Group By Specifies the Group By clause
  Having Having Specifies the HAVING clause
  Order Order Specifies the ORDER clause
User Defined SQL User Defined SQL   Allows to represent the view as User-defined SQL
User Defined SQL Statement   Specifies the User-defined SQL statement
SQL     Specifies SQL statement for the view in read only format

To view the common object properties that are supported in Fabric Warehouse, refer to the Common Object Properties topic.

RE Parameters

The following sections explain the reverse engineering options for Microsoft Fabric Warehouse.

Overview

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 an 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 the Script File is selected as a Reverse engineer source. Click Browse and select a script file from your directory.

Connection

Parameters

Description

Additional Information
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.

  

Warehouse

Identifies the virtual compute warehouse 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

Parameter Description
Available Schemas Displays the available schemas
Selected Schemas Displays the selected schemas

Tables

Parameter Description
Available Tables Displays the available tables
Selected Tables Displays the selected tables

Views

Parameter Description
Available Views Displays the available views
Selected Views Displays the selected views

Options

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 Warehouse.

Option Selection

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 the 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

Parameter Description Additional Information
Object Name Displays available objects for owner override. Enter an owner name to 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 the assignments of the owner for that object group  

Object Filter

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 of the items in the list Use this option to select all the tables in the list.

 
Unselect all of 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 unselect 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 tablespace, or database.

Applicable to Db2 for LUW and Db2 for z/OS databases.

Preview

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

Parameters

Description

Additional Information
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.

  

Warehouse

Identifies the virtual compute warehouse 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.