Connect Insider One and Amazon Redshift through an Amazon S3 bucket you own. To export Insider One data, Insider One writes user and event files to S3, and your Redshift pipeline loads them using methods such as the COPY command. To import Redshift data, export your selected Redshift records to S3 using methods such as the UNLOAD command, then configure Insider One to read and map those files.
Export Data from Insider One to Amazon Redshift
You can export user and event data from Insider One to Amazon Redshift by using Amazon S3 as an intermediary data lake.
In this setup, Insider One exports data to a customer-owned Amazon S3 bucket, and Amazon Redshift ingests that data using customer-configured loading mechanisms. This approach enables scalable, decoupled data pipelines without direct system-to-system dependencies.
Get started with Export Data from Insider One to Amazon Redshift.
Import Data from Amazon Redshift to Insider One
You can also make data stored in Amazon Redshift available in Insider One by exporting it to Amazon S3 and configuring Insider One to ingest it from there.
With this integration, you can periodically sync user attributes or other batch data from Redshift into Insider One. Once configured, Insider One processes the exported files and updates user profiles or segmentation data.
Get started with Import Data from Amazon Redshift to Insider One.