search

mmichaelb / terraform-provider-redshift

Terraform Redshift provider
https://registry.terraform.io/providers/mmichaelb/redshift/latest/docs
MIT License
1 stars 1 forks source link

redshift-data connection request #126

Open carlosperello opened 6 months ago

carlosperello commented 6 months ago

There are some use cases for this provider where for security reasons, you cannot have direct connectivity with the RedShift cluster, specially when there is an isolation between your ci/cd pipelines and your production redshift cluster.

How complex would be to implement a way to allow to choose between direct TCP/IP connection or via AWS redshift-data when you want to manage a Redshift cluster?

Thanks.

mmichaelb commented 6 months ago

Hi Carlos, thank you for your issue. I do agree that in many protected environments it would be great to interact with the redshift using the native aws redshift-data cli.

However, the TCP/IP connection based *sql.DB Golang struct type is deeply integrated into the provider (see https://github.com/mmichaelb/terraform-provider-redshift/blob/main/redshift/config.go#L42). Therefore, in my opinion this addition would be an enormous refactoring and would require heavy work. At the moment, sadly, I do not have the time to implement this feature.

I am leaving this issue open so that someone (or a future me) can start such implementation. Feel free to share your thoughts :)