You can analyze your Insider One data in Domo by making it available in your own data warehouse or cloud storage and connecting Domo to that destination. Insider One shares or delivers your selected events and attributes on a schedule you control, and Domo reads them from your destination like any other data source. This guide helps you choose the right destination and walks you through both sides of the flow.
Insider One does not provide a native Domo connector. Domo reads your Insider One data from a destination you own, such as your Snowflake account or a data warehouse fed by your cloud storage bucket.
Requirements
Before you begin, make sure you meet the following prerequisites:
To set up integrations on the External Platform Integrations screen of the InOne panel, you need an Administrator or an Editor with PII access role (PII: personally identifiable information).
You have a supported destination: a Snowflake account or a cloud storage bucket you own (Amazon S3, Google Cloud Storage, or Azure Blob Storage). You reach Amazon Redshift and Databricks through a bucket export plus your own ingestion pipeline.
Your Domo instance can reach that destination through a Domo data connector.
You have decided which events and attributes to export for analysis.
Choose your destination
Destination | How your data arrives | How Domo reads it |
|---|---|---|
Insider One shares your data through Snowflake Secure Data Sharing. No copy is loaded into your account, and shared data does not add to your storage costs. | Domo connects to your Snowflake account, where the shared data is available. | |
Scheduled exports deliver comma-separated values (CSV) files to a bucket or container you own. | Your data pipeline loads the files into a database or warehouse that Domo reads. | |
Built on a bucket export: Insider One delivers CSV files to your bucket, and your own ingestion pipeline (for example, COPY or Auto Loader) loads them into the warehouse. | Domo connects to the warehouse with its connector for that warehouse. |
Step 1: Make your data available in your destination
Set up the export in Insider One:
In the InOne panel, navigate to Components > Integrations > External Platform Integrations, and create the integration for your destination: Snowflake, Amazon S3, Google Cloud Storage, or Azure Blob Storage.
Complete the destination-specific setup. For bucket destinations, authenticate with your storage credentials and select the events and attributes you want to export. For Snowflake, enter your Snowflake Account ID and use the share details provided by Insider One. The Insider One team approves the data-sharing request.
In the Launch step, set the sync frequency and activate the integration. For Snowflake, the sync frequency is the Sync Period.
To land the data in Amazon Redshift or Databricks, export to a bucket first and load the files with your own ingestion pipeline. The destination guides cover each pattern end to end:
Step 2: Connect Domo to your destination
Once your data is flowing, connect Domo on your side:
In Domo, create a DataSet using the connector for your warehouse (for example, Snowflake).
Enter your warehouse connection details and select the tables that hold your Insider One data. For Snowflake, these tables are in the database shared by Insider One.
Build your cards and dashboards on that DataSet, and schedule the DataSet to update as new scheduled exports arrive.
If you export to cloud storage and do not use a warehouse, load the delivered CSV files into a database first, then connect Domo to it.
Real-time alternative: Stream data with webhooks
The warehouse path above is built for reporting and analysis. If you also need data the moment it changes, Webhook (Data Stream) transmits events and attributes to an endpoint you own in real time.
The Attribute Stream sends a webhook whenever a monitored user attribute changes, and the Event Stream sends a webhook as tracked events occur. You can define custom headers and a custom payload for your endpoint, and your integration can forward the incoming data to the real-time input of your business intelligence (BI) tool.
For the Data Stream overview, see Webhook. For configuration, including payload customization, security, and testing, see Insider One Webhook.
Example analyses
If you use the Snowflake destination, Best Practices for Insider One Engagement Data in Snowflake includes example queries and engagement-analysis techniques. You can adapt them for the cards and dashboards you build in Domo or any other BI tool.
Related resources
Analyze Insider One Data in Power BI. For the same pattern with Power BI.
Integration Hub. Browse the platforms you can connect to Insider One as a source or a destination in the InOne panel.