Has anyone successfully integrated Intercom with Looker?

Question

We have pushed the data from Intercom into Stitch and into Looker. We are running into issues connecting the data together in Looker.   did reach out to Intercom and they do not have a Data Model they can share.  We need to match the primary keys in Looker.  Wondering if anyone has done this.

Eric Fitz · Accepted Answer

Hey @emily h11​, I confess to not being particularly familiar with Looker, but would this Block be of any help to you?Alternatively, can you expand on some of the issues you're experiencing? Are you trying to connect directly with Intercom's API?

Emily H11 · Answer

@eric f11​Thanks for responding. 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 :(

Join the Intercom Community 🎉

Intercom Customers and Employees

Login to the community

Intercom Customers and Employees

Scanning file for viruses.

This file cannot be downloaded