Intercom and Looker

We are using Stitch's integration to Intercom noted here: https://www.stitchdata.com/docs/integrations/saas/intercom. The tables are pulling over fine, meaning we are getting data in the tables. What we don't have is how to connect the tables together using standard SQL. Each table has to have a primary key and a foreign key and we found out via Looker support that you don't share your data model. Therefore, we are stuck..The API that is published is not helpful in connecting these tables.  Has anyone been able to put the tables back together in Looker from Intercom?

0 0 291