# Documentation on raw data extracts

**URL:** <https://community.hubspot.com/t/documentation-on-raw-data-extracts/72645>\
**Category:** APIs & Integrations\
**Created:** [January 11, 2023, 10:51am UTC](https://community.hubspot.com/t/documentation-on-raw-data-extracts/72645 "2023-01-11T10:51:41Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![LMcKenna6](https://avatars.discourse-cdn.com/v4/letter/l/258eb7/32.png) [@LMcKenna6](https://community.hubspot.com/u/LMcKenna6)\
**Post date:** [January 11, 2023, 10:51am UTC](https://community.hubspot.com/t/documentation-on-raw-data-extracts/72645/1 "2023-01-11T10:51:41Z")

</div>

Hi, we have extracted the hubspot data via fivetran and i’m starting to do some modelling on the data but i’m having a few issues confirming i’m joining tables on the correct primary/secondary keys - is there any documentation on this? Also I can’t find a specific field that I need in any of the tables, and i’m hoping that some documentation might help me here too. Let me know if yu need any other info.

Thanks

---

<div class="post-metadata">

**Author:** ![Syeda\_Fatima](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/syeda_fatima/32/36951_2.png) [@Syeda\_Fatima](https://community.hubspot.com/u/Syeda_Fatima)\
**Post date:** [January 11, 2023, 11:46am UTC](https://community.hubspot.com/t/documentation-on-raw-data-extracts/72645/2 "2023-01-11T11:46:34Z")

</div>

Hey @LMcKenna6, Yes, Fivetran provides extensive documentation on joining tables and connecting the correct primary and secondary keys.

You can refer to this documentation: [https://fivetran.com/docs/tables/table-relationships](https://fivetran.com/docs/tables/table-relationships)

Additionally, if you cannot find a specific field in any of the tables, you may need to create a custom field or query to pull the specific data you need.

Hope your query should resolve. 🙂