Documentation on raw data extracts

Develop, Build & Integrate APIs & Integrations
1

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

2

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

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. :slightly_smiling_face: