This guide explains how to export data from Amazon Redshift to Amazon S3 and make it available for import into Insider One. Amazon S3 acts as the intermediary data lake between Redshift and Insider One.
Overview
Amazon Redshift exports table or query results to a customer-owned Amazon S3 bucket.
Insider One reads data from Amazon S3 using customer-configured import settings.
Data is processed, mapped, and used in Insider One according to your needs.
This approach enables scalable, decoupled, and flexible data pipelines without direct system-to-system dependencies.
Prerequisites
Amazon Redshift
Access to an Amazon Redshift cluster
Permissions to export data from Redshift to Amazon S3
Ability to run scheduled or ad-hoc export jobs (for example, using SQL, Airflow, dbt, or AWS services)
Amazon Web Services (AWS)
An AWS account
Permissions to create and manage Amazon S3 buckets
IAM permissions allowing Amazon Redshift to write data to the selected S3 bucket
Insider One
Access to an Insider One account with permissions to configure data ingestion
Ability to configure Amazon S3 as a data source for imports.
Step 1: Export Data from Amazon Redshift to Amazon S3
Amazon Redshift supports exporting data directly to Amazon S3 using the UNLOAD command. You can:
Select the table or write a SQL query to define the export data
Configure the UNLOAD command to write data to your S3 bucket in a supported format
Schedule or automate the UNLOAD operation as needed
For detailed, up-to-date instructions, refer to Amazon’s UNLOAD command guide (Amazon Redshift).
If you cannot use UNLOAD (e.g., due to permissions or specific requirements), you could consider other methods to send data to Amazon S3 Bucket from Amazon Redshift.
Step 2: Import Data from Amazon S3 into Insider One
Once data is available in Amazon S3, it can be imported into Insider One using the S3 import integration. Using the Insider One panel, you can:
Select the S3 bucket and path containing the exported Redshift data
Configure IAM credentials and bucket policies that allow Insider One to read data
Map columns/fields from the exported files to Insider One attributes and events
For detailed instructions, refer to Import data from Amazon S3 (Insider One).
Step 3: Automation and Monitoring
Schedule or automate Redshift UNLOAD operations to match your desired data refresh cadence
Monitor exported files in Amazon S3
Configure Insider One import integration and monitor import status and mapping results