Mirror data to Amazon Redshift from Qlik Open Lakehouse

Qlik Open Lakehouse projects now support mirroring data to Amazon Redshift, expanding the data mirror feature to enable multi-platform analytics from a single project. In addition to existing targets such as Snowflake, Redshift is now available as a mirror target, allowing one dataset to be queried from one or more cloud data warehouses.

With mirror tasks, Qlik enables multi-platform data pipelines without data duplication. You can query data stored in Iceberg tables in your lakehouse directly from Redshift, eliminating the need for additional storage while maintaining consistent, up-to-date data access.

This enhancement also supports a Medallion architecture approach:

• Ingest raw data into an Iceberg-based Bronze layer in your lakehouse

• Mirror the data to Redshift for downstream transformations in Silver and Gold layers

• Perform transformations by creating a Redshift project with a transform task, using the Redshift mirror as the source

Redshift users can query lakehouse data as if it were native to the warehouse, while Qlik automatically handles data refresh, performance optimization, and storage management.

The result is greater flexibility, lower storage costs, and unified analytics across multiple cloud data platforms, now including Redshift.

For more information, see Mirroring data to a cloud data warehouse.