IBM Cloud Databases BYOK for Backups + SQL Query BYOK instance

[movinglightspeed]

Hi there,

I am using
terraform -v
Terraform v0.12.26

• provider.ibm v1.8.1

There is no support for IBM Cloud Databases BYOK for backups and SQL Query instance creations do not have support for BYOK for "standard" plan. These features are available through console.

Additionally, I want to request ibm provider auto-complete support for intellij IDEA terraform plugin. Some providers like aws have autocomplete support for these plugins and enable easy intelligent completion of terraform commands.

Please note that we try to keep the Terraform issue tracker reserved for bug reports and feature requests. For general usage questions, please see: https://www.terraform.io/community.html.

Terraform Version

Run terraform -v to show the version. If you are not running the latest version of Terraform, please upgrade because your issue may have already been fixed.

Affected Resource(s)

Please list the resources as a list, for example:

• ibm_database
• ibm_resource_instance

Terraform Configuration Files

``
sqlqueryinstance.tf
resource "ibm_resource_instance" "sqlquery_instance" {
name = "sqlqueryinstance"
plan = "standard" #lite is the other plan but standard supports encryption by CSP & BYOK
location = "us-south"
service = "sql-query"
resource_group_id = data.ibm_resource_group.group.id
tags = ["tag1", "tag2"]
}

``
databases.tf
resource "ibm_database" "testdb"  {
  name = "terraformmongodb"
  plan = "standard"
  location = "us-south"
  service = "databases-for-mongodb"
  resource_group_id = data.ibm_resource_group.group.id
  tags = ["tag1", "tag2"]
  adminpassword = "password12"
  members_memory_allocation_mb = 3072
  members_disk_allocation_mb = 61440
  #service_endpoints = "private"
  key_protect_key = "crn:v1:bluemix:public:kms:us-south:a/fullvalue"
  key_protect_instance = "crn:v1:bluemix:public:kms:us-south:a/fullvalue"
  users {
    name = "user123"
    password = "password12"
  }
  whitelist {
    address = "172.168.1.1/32"
    description = "desc"
  }
}

output "ICD_database_connection_string" {
  value = "${"${ibm_database.testdb.connectionstrings.0.composed}"}"
}

Expected Behavior

What should have happened?
For IBM Databases, BYOK for backups should have allowed using Key protect key and instance for backups as well. For SQL Query there should be a setting to allow BYOK for standard plan. For provider auto completion, requesting better integration for HashiCorp Terraform / HCL language support plugins such as for IntelliJ IDEA to allow auto completion.

Steps to Reproduce

Please list the steps required to reproduce the issue, for example:

1. terraform apply