Set up your Amazon Redshift connection

You can connect Dataflow Gen2 to Amazon Redshift in Microsoft Fabric using Power Query connectors. Follow these steps to create your connection:

1. Get data from Data Factory in Microsoft Fabric.
2. Connect to Amazon Redshift data.

Supported authentication types

The Amazon Redshift connector supports the following authentication types for copy and Dataflow Gen2 respectively.

Learn more about this connector

• Supported capabilities
• Connect using advanced options
• Enable Microsoft Entra ID single sign-on for Amazon Redshift