Jul 10 • General
Fabric pipeline copy data from PostgreSQL to warehouse doesn’t preserve relationships (PKs/FKs)
Hello everyone,
I'm new to Microsoft Fabric and currently working on data pipelines that copy data from a PostgreSQL database to a Fabric warehouse.
The data copies successfully, but I noticed that primary keys and foreign key relationships are not transferred to the warehouse tables. All the tables are created, but the relationships between them are missing. (over 550 tables)
Is this the expected behavior? Is there a way to preserve or automatically recreate the primary/foreign keys during or after the pipeline execution?
Any advice or best practices would be appreciated.
Thanks!
4
1 comment
Fabric pipeline copy data from PostgreSQL to warehouse doesn’t preserve relationships (PKs/FKs)
skool.com/microsoft-fabric
Helping passionate analysts, data engineers, data scientists (& more) to advance their careers on the Microsoft Fabric platform.
Leaderboard (30-day)
1
+26
2
+23
3
+23
4
+17
5
+16
Powered by