The driver provides read-write access to the Synapse Data Warehouse endpoints of Microsoft Fabric; however, the following limitations to features and functionality apply:
Note: The Microsoft Fabric data source is constantly evolving; therefore, the limitations given in this section may not apply in the future. For the latest information, refer to the Microsoft Fabric documentation.
  • The PRIMARY KEY and UNIQUE constraints are only supported when NONCLUSTERED and NOT ENFORCED are both used, whereas the FOREIGN KEY constraint is only supported when NOT ENFORCED is used. These keys cannot be created while creating a table, but can be added later using ALTER TABLE.
  • No support for distributed transactions and named transactions.
  • No support for unquoted identifiers. The driver always enforces ANSI rules for quotation marks for all Microsoft Fabric connections (EnableQuotedIdentifiers=1); therefore, the Enable Quoted Identifiers option is disabled.
  • No support for CREATE INDEX.
  • getTablePrivileges() and getCoumnPrivileges() return empty result sets.
  • CREATE FUNCTION can create inline table-value functions, but not scalar functions.
  • No support for the following T-SQL commands, queries, and features:
    • ALTER TABLE (ADD, ALTER, and DROP COLUMN): Currently, only the following subsets of ALTER TABLE are supported in Warehouse in Microsoft Fabric:
      • ADD nullable columns of supported column data types.
      • ADD or DROP PRIMARY KEY, UNIQUE, and FOREIGN KEY column constraints, but only if the NOT ENFORCED option has been specified. All other ALTER TABLE operations are blocked.
    • CREATE ROLE
    • CREATE USER
    • Hints
    • IDENTITY columns
    • Manually created multi-column statistics
    • IDENTITY columns
    • Manually created multi-column statistics
    • Materialized views
    • MERGE
    • OPENROWSET
    • PREDICT
    • Queries targeting system and user tables
    • Recursive queries
    • smallint identity
    • Result Set Caching
    • Schema and table names containing / or \
    • SELECT - FOR XML
    • SET ROWCOUNT
    • SET TRANSACTION ISOLATION LEVEL
    • Temporary tables
    • Triggers
  • No support for the following keywords:
    • ALLOW_SNAPSHOT_ISOLATION
    • COLLATE
    • COLUMN ENCRYPTION
    • DECLARE CURSOR
  • No support for the following SQL Server data types:
    • bigint identity
    • money
    • smallmoney
    • binary
    • nchar
    • text
    • datetime
    • ntext
    • timestamp
    • datetimeoffset
    • numeric() identity
    • tinyint
    • decimal() identity
    • nvarchar
    • tinyint identity
    • image
    • nvarchar(max)
    • uniqueidentifier
    • int identity
    • smallint identity
  • Support for scalar string functions is limited to the following functions:
    • ASCII
    • LEFT
    • RTRIM
    • CHAR
    • LTRIM
    • SOUNDEX
    • CONCAT
    • REPLACE
    • SPACE
    • DIFFERENCE
    • RIGHT
    • SUBSTRING

    Refer to String functions in the Progress DataDirect for ODBC Drivers Reference for more information.

  • Support for scalar numeric functions is limited to the following functions:
    • ABS
    • EXP
    • ROUND
    • ACOS
    • FLOOR
    • SIGN
    • ASIN
    • LOG
    • SIN
    • ATAN
    • LOG10
    • SQRT
    • CEILING
    • PI
    • TAN
    • COS
    • POWER
    • TRUNCATE
    • COT (ADW only)
    • RADIANS
    • DEGREES
    • RAND

    Refer to Numeric functions in the Progress DataDirect for ODBC Drivers Reference for more information.

  • Support for scalar date and time functions is limited to the following functions:
    • CURDATE
    • DAYOFWEEK
    • QUARTER
    • CURRENT_DATE
    • DAYOFYEAR
    • SECOND
    • CURRENT_TIME
    • HOUR
    • WEEK
    • CURTIME
    • MINUTE
    • YEAR
    • DAYNAME
    • MONTH
    • DAYOFMONTH
    • MONTHNAME

    Refer to Date and time functions in the Progress DataDirect for ODBC Drivers Reference for more information.