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