Thank you for your question. Currently, Amazon Redshift linked service v2.0 in Azure Data Factory is supported only with Self-hosted Integration Runtime (IR). When using Azure Integration Runtime (IR), the upgrade prompt appears, but v2.0 is not available.
Recommended actions:
To use Redshift v2.0 features, configure and use a Self-hosted IR.
If you need to stick with Azure IR, continue using the existing v1.0 connector until support for v2.0 is added.
For more details, please see the official documentation:
- Connector release stages and timelines
- Copy data from Amazon Redshift using Azure Data Factory or Synapse Analytics
Hope this helps. Do let us know if you any further queries.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.