Edit

Share via

Limitations in Microsoft Fabric mirrored databases from Azure Database for PostgreSQL flexible server

  • Article

Current limitations in the Microsoft Fabric mirrored databases from Azure Database for PostgreSQL flexible server are listed in this page. This page is subject to change.

For troubleshooting, see:

Server level limitations

  • Servers in the Burstable Compute Tier are currently not supported.
  • Servers with High Availability enabled or with established Read Replicas are currently not supported.

Database level limitations

  • Fabric Mirroring for Azure Database for PostgreSQL flexible server is only supported on a writable primary database.
  • Azure Database for PostgreSQL flexible server database can't be mirrored if it is already mirrored in another Fabric workspace.
  • The maximum number of tables that can be mirrored into Fabric is 500 tables. Any tables above the 500 limit currently cannot be replicated.
    • If you select Mirror all data when configuring Mirroring, the tables to be mirrored over are the first 500 tables when all tables are sorted alphabetically based on the schema name and then the table name. The remaining set of tables at the bottom of the alphabetical list are not mirrored over.
    • If you unselect Mirror all data and select individual tables, you are prevented from selecting more than 500 tables.

Permissions in the source database

  • Permissions defined in Azure Database for PostgreSQL flexible server are not propagated to the replicated data in Fabric OneLake.

  • To successfully configure Mirroring for Azure Database for PostgreSQL flexible server, the database role used to connect to the source server must be granted the azure_cdc_admin role and REPLICATION privilege. Here's an example of how you create a dedicated database role for mirroring:

    CREATE ROLE fabric_user  CREATEDB CREATEROLE LOGIN REPLICATION PASSWORD '<strong password>';
GRANT azure_pg_admin TO fabric_user;

Network and connectivity security

Table level

  • DDL operations on existing mirrored tables are not supported (add/remove column, change data type, etc.). Modify existing tables with require to drop and recreate the mirrored database in Microsoft Fabric.
  • TRUNCATE TABLE commands on mirrored tables are not supported
  • Mirroring is not currently not supported for views, materialized views, foreign tables, toast tables or partitioned tables.

Column level

  • Data in a Numeric/Decimal column exceeding precision of 38 won't be replicated in the mirrored database and will appear as NULL.

  • If the source table contains columns with one of these data types, these columns cannot be mirrored to Fabric OneLake. The following data types are currently unsupported for mirroring:

    • bit
    • bit varying [ (n) ], varbit
    • box
    • cidr
    • circle
    • inet
    • interval [ fields ] [ (p) ]
    • json
    • jsonb
    • line
    • lseg
    • macaddr
    • macaddr8
    • path
    • pg_lsn
    • pg_snapshot
    • point
    • polygon
    • tsquery
    • tsvector
    • txid_snapshot
    • xml

  • Mirroring supports replicating columns containing spaces or special characters in names (such as , ; { } ( ) \n \t =). For tables under replication before this feature enabled, you need to update the mirrored database settings or restart mirroring to include those columns. Learn more from Delta column mapping support.

Warehouse limitations

  • Source schema hierarchy is replicated to the mirrored database. For mirrored databases created before this feature enabled, the source schema is flattened, and schema name is encoded into the table name. If you want to reorganize tables with schemas, recreate your mirrored database. Learn more from Replicate source schema hierarchy.

Mirrored item limitations

  • User needs to be a member of the Admin/Member role for the workspace to create SQL Database mirroring. 
  • Stopping mirroring disables mirroring completely. 
  • Starting mirroring reseeds all the tables, effectively starting from scratch. 

SQL analytics endpoint limitations

Supported regions

The following are the Fabric regions that support Azure Database for PostgreSQL flexible server database mirroring:

Americas:

  • Canada Central
  • West Central US

Asia Pacific:

  • East Asia

Europe, the Middle East, and Africa:

  • North Europe

Next step

Tutorial: Configure Microsoft Fabric mirrored databases from Azure Database for PostgreSQL flexible server

Related content