How ActionIQ built a truly composable customer data platform using Amazon Redshift

This article discusses how ActionIQ, a composable customer data platform, built a connector for Amazon Redshift to securely access customer data in the data warehouse without copying or replicating it.

Specifically, the article covers:

• The challenges of moving or copying data, including heavy logistics, added costs, security risks, and data latency
• The solution architecture involving AWS PrivateLink to securely connect ActionIQ's VPC to the customer's VPC and grant ActionIQ limited access to database views in Amazon Redshift
• Getting started with the ActionIQ connector, including setting up the secure connection, creating a database and service account in Redshift, granting permissions, and defining views to share data
• Testing the connector by validating queries and results
• Key considerations such as data governance, workload spikes with Redshift Serverless, and sharing data back to Redshift for business intelligence
• Conclusion highlighting the benefits of control, performance, and power while ensuring data freshness and enabling real-time customer experiences