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?

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

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.

Yes, the tables (at the moment) don’t have the FK connection 😞 So you need to see the API and made the connection yourself

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

It depends from each source, unfortunately I don’t have much knowledge in Typeform API

FWIW, the imported data model that Stitch creates is much more workable. Wonder if it’s worth reexamining the Typeform Connector.

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.