https://linen.dev logo
#ask-community-for-troubleshooting
Title
# ask-community-for-troubleshooting
j

Jonathan Crawford

12/28/2021, 11:21 PM
Hi is anyone using Typeform to sync to a data warehouse? The tables are super confusing and don’t seem to have foreign keys to connect the answers/responses with the various forms. Any insights there?
1
👀 1
Oh do you use these AB Hash IDs?
u

[DEPRECATED] Marcos Marx

12/28/2021, 11:28 PM
yes 😅 there is a column called airbyte_hash_id so you can use it to connect a parent table with a child table.
typeform_answers
typeform_answers_child
j

Jonathan Crawford

12/28/2021, 11:30 PM
OK Thanks. I sucked in the whole account (15+ forms). Just trying to figure out which tables to join to go Form -> Responses for a specific form.
In order words, I don’t see a foreign key to connect Form & Field/Answer
u

[DEPRECATED] Marcos Marx

12/29/2021, 12:24 AM
Yes, the tables (at the moment) don’t have the FK connection 😞 So you need to see the API and made the connection yourself
j

Jonathan Crawford

12/29/2021, 4:13 PM
Hmm… would you explain that a little more to me? I’m a power-user of Metabase and help other businesses launch it so, I can see Airbyte becoming part of what I help other companies implement. I’m just not getting the overall strategy yet. 🙂
OK I think it may be the
ref
field that you can use to correlate.
u

[DEPRECATED] Marcos Marx

12/29/2021, 7:07 PM
It depends from each source, unfortunately I don’t have much knowledge in Typeform API
j

Jonathan Crawford

12/30/2021, 3:11 PM
FWIW, the imported data model that Stitch creates is much more workable. Wonder if it’s worth reexamining the Typeform Connector.
u

[DEPRECATED] Marcos Marx

01/03/2022, 7:31 PM
thanks for the feedback @Jonathan Crawford, at the moment Airbyte transfer the API as is from the source; maybe in the future with custom transformation could be possible to generate more workable final schemas.