Destination Improvement: Add logical Primary keys/Foreign Key and Constraints in DDL as per Source Database
PlannedWe are doing warehouse migration from Oracle to Snowflake and use Fivetran pipes to move our transactional data from source databases like SQL, Oracle to Snowflake.
Business users used to see primary key and constraints in Oracle, now they have requested that we like to see the keys and constraints in Snowflake as well which has been created by Fivetran Pipe.
We understand that Snowflake doesn't enforce PK/FK and some other constraints but allows to be added in Definition. Can we include this in the Fivetran DDL when those tables being created same as source so logical keys and constraints are there same as Source tables and easier for users to Query it.
Appreciate the attention to this request sooner.
-
Official comment
Hi Nishitkumar,
Thank you for sharing your feedback! We’re actively working on these features and plan to deliver them soon. We’ll keep you updated as soon as they become available.
Best,
Please sign in to leave a comment.
Comments
1 comment