Thank you for providing detailed context. Based on the knowledge sources, here are some key points and troubleshooting steps for your scenario: 1.
Intermittent Connection Issues via VPC Endpoint - Even if the initial connection test is successful, repeated failures with "Could not reach URL" can indicate networking or configuration issues with the VPC endpoint or the Redshift security group settings. - Double-check that the VPC endpoint DNS is correct and does not contain any trailing spaces or formatting errors, as this has caused similar issues for other users ([Slack thread: Hostname not valid](
https://gooddataconnect.slack.com/archives/C04S1MSLEAW/p1748679803727319?thread_ts=1748679803.727319&cid=C04S1MSLEAW)). - Ensure that the Redshift security group allows inbound connections from the correct GoodData IP ranges for your region. If you are using PrivateLink, confirm that the endpoint and security group rules are set up as described in the [AWS PrivateLink documentation](
https://www.gooddata.com/docs/cloud/connect-data/use-aws-privatelink/). 2.
VPC Endpoint and Routing - If you have multiple environments (e.g., Prod and Non-Prod), each may require its own VPC endpoint or endpoint service, depending on your network architecture. Simply having VPC peering may not be sufficient for PrivateLink-based connectivity ([Slack thread: VPC endpoint for each environment](
https://gooddataconnect.slack.com/archives/C04S1MSLEAW/p1748679803727319?thread_ts=1748679803.727319&cid=C04S1MSLEAW)). - Confirm that the endpoint service is correctly configured and that GoodData has been granted access via the correct AWS account ID. 3.
Redshift and GoodData Known Issues - There are no known issues on the GoodData side that would cause intermittent failures if the network and endpoint are configured correctly ([Slack thread: No known issues](
https://gooddataconnect.slack.com/archives/C04S1MSLEAW/p1748278507284779?thread_ts=1748278507.284779&cid=C04S1MSLEAW)). - If you continue to see "Could not reach URL," it is often due to network misconfiguration, security group rules, or endpoint DNS issues. 4.
Next Steps - Double-check the VPC endpoint DNS and remove any trailing spaces. - Verify security group rules for both Redshift and the VPC endpoint. - If using PrivateLink, ensure the endpoint is set up for the correct environment and region. - If the issue persists, collect the traceId from the error message and share it with GoodData support for further investigation ([Slack thread: TraceId for troubleshooting](
https://gooddataconnect.slack.com/archives/C04S1MSLEAW/p1748679803727319?thread_ts=1748679803.727319&cid=C04S1MSLEAW)). If you need more specific guidance, please provide the exact error message (with traceId) and confirm your VPC endpoint DNS and security group settings. This will help narrow down the root cause.