07-21-2023 03:21 AM
Hello,
The /meta endpoint returns column-level information, which is useful, however, there does not seem to be a way to derive the source table for any column that is flagged as `is_foreign_key: true`. The fact that you are identifying that key implies you must know the source.
Is there a way to identify the source table FK columns using the API? Is there any chance of an API update to include `fk_parent_id` in the column meta?
Thanks
Solved! Go to Solution.
07-21-2023 10:13 AM
Hey there,
We're actually working on this functionality as we speak - stay tuned!
Can I ask what connector you'd like the source table for and what your use case is for the information?
All the best, Natalie
07-21-2023 10:13 AM
Hey there,
We're actually working on this functionality as we speak - stay tuned!
Can I ask what connector you'd like the source table for and what your use case is for the information?
All the best, Natalie
07-21-2023 01:08 PM
Hello,
Our use case/requirement for understanding the FK constraints is that we have no-code / query wizard and a schema map within our application, knowing the FK relationships is key for us in terms of building meaningful insight from data arriving from Fivetran.
We have attempted to derive FK's in our destination tables, but Fivetran does not consistently create these constraints, meaning we would need to build schema config for all Fivetran connectors (and future connectors) in order to have the required meta for our application.
In terms of connectors we'd hope to see this data for, it would be any of the operation systems. We have a focus currently on e-commerce, CRM and ERP systems (shopify, klaviyo, netsuite, salesforce, hubspot etc). Does this mean adding this additional meta field is going to be on a per-connection basis?
07-24-2023 08:34 AM
Thanks for this background! It is on a per-connector basis, so this is great information for our product team to have. Have a great week!