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.
Page 1 / 1
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?
@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 :(
Reply
Join the Intercom Community 🎉
Already have an account? Login
Login to the community
No account yet? Create an account
Intercom Customers and Employees
Log in with SSOor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.