Terraform Snowflake Error: Plugin did not respond

[sumitbourne]

trafficstars

Terraform CLI and Provider Versions

Terraform v1.7.3 on windows_386

• provider registry.terraform.io/hashicorp/aws v5.36.0
• provider registry.terraform.io/snowflake-labs/snowflake v0.85.0

Terraform Configuration

snowflake = {

  source  = "Snowflake-Labs/snowflake"

  version = "0.85.0"

}

terraform.lock.hcl file:

provider "registry.terraform.io/hashicorp/aws" {
version = "5.36.0"
hashes = [
"h1:jKuvCOVcdzG3uJusgvYG69A464pa8cPcApfNVJXCgvU=",
"zh:0da8409db879b2c400a7d9ed1311ba6d9eb1374ea08779eaf0c5ad0af00ac558",
"zh:1b7521567e1602bfff029f88ccd2a182cdf97861c9671478660866472c3333fa",
"zh:1cab4e6f3a1d008d01df44a52132a90141389e77dbb4ec4f6ac1119333242ecf",
"zh:1df9f73595594ce8293fb21287bcacf5583ae82b9f3a8e5d704109b8cf691646",
"zh:2b5909268db44b6be95ff6f9dc80d5f87ca8f63ba530fe66723c5fdeb17695fc",
"zh:37dd731eeb0bc1b20e3ec3a0cb5eb7a730edab425058ff40f2243438acc82830",
"zh:3e94c76a2b607a1174d10f5712aed16cb32216ac1c91bd6f21749d61a14045ac",
"zh:40e6ba3184d2d3bf283a07feed8b79c1bbc537a91215cac7b3521b9ccb3e503e",
"zh:67e52353fea47eb97825f6eb6fddd1935e0ff3b53a8861d23a70c2babf83ae51",
"zh:6d2e2f390e0c7b2cd2344b1d5d6eec8a1c11cf35d19f1d6f341286f2449e9e10",
"zh:7005483c43926800fad5bb18e27be883dac4339edb83a8f18ccdc7edf86fafc2",
"zh:7073fa7ccaa9b07c2cf7b24550a90e11f4880afd5c53afd51278eff0154692a0",
"zh:9b12af85486a96aedd8d7984b0ff811a4b42e3d88dad1a3fb4c0b580d04fa425",
"zh:a6d48620e526c766faec9aeb20c40a98c1810c69b6699168d725f721dfe44846",
"zh:e29b651b5f39324656f466cd24a54861795cc423a1b58372f4e1d2d2112d10a0",
]
}

provider "registry.terraform.io/snowflake-labs/snowflake" {
version = "0.84.1"
constraints = "0.84.1"
hashes = [
"h1:KZFt5oc7BZQ2mS1VqZxAUe2oCTHfKTT0SoxuzeekBO4=",
"zh:40eba0404c75c4a27bb8c9e980acd5ff954dc4df0c06984abf17023b818b5ad0",
"zh:538972e6844d7d3641871a02daeaf210693291d0f3c153af584c3238112bc5f8",
"zh:72bc7dde924e96652d1c6878431062e71365de77295124d849c44272cd5f45ed",
"zh:82f1f662f17035f4a8addfe4b166cebc068ebc9316112ccf759a061e506109d3",
"zh:87efd717cffc942708bae9c7e0835e0ce0f48cbe5553f694c06a33351bb907e5",
"zh:9c9e18c60629ba86bc83eeb76b26477677025543d84fa7bd773e2cc893e29b45",
"zh:a4eb876c8bb107fb662c9300233af244101f4ee6e654ea7183b5cd17112430a9",
"zh:c132dda96f91cf892bd52ae2e5f672c3feeeef0c3c4809bf40bb455d335f14d6",
"zh:cf9138b867db313ca58085c96bca83f95cee9f30d7bf7fc1209cb125c1c08e76",
"zh:de393acdf4525744ff5db07e8ff905ea1bbd18ab749b6b9c2977501da4301e76",
"zh:f00ee36e348865f57fe8fe346531e498e16a9aefedf7cef8273f10af4b337699",
"zh:f569b65999264a9416862bca5cd2a6177d94ccb0424f3a4ef424428912b9cb3c",
]
}



I am using Snowflake Lab version 0.85 and latest Terraform version is 1.7.3

Expected Behavior

1. Terraform should be connected to the Snowflake
2. Terraform should be connected to the AWS.

Actual Behavior

Error: Plugin did not respond │ │ The plugin encountered an error, and failed to respond to the plugin6.(*GRPCProvider).ConfigureProvider call. The │ plugin logs may contain more details. ╵

Stack trace from the terraform-provider-snowflake_v0.85.0.exe plugin:

panic: runtime error: invalid memory address or nil pointer dereference [signal 0xc0000005 code=0x0 addr=0x0 pc=0x1a064ce]

goroutine 70 [running]: crypto/rsa.(*PrivateKey).Public(...) crypto/rsa/rsa.go:122 github.com/snowflakedb/gosnowflake.prepareJWTToken(0xcdd0480) github.com/snowflakedb/[email protected]/auth.go:462 +0x2e github.com/snowflakedb/gosnowflake.createRequestBody(0xcbf3080, 0xcd66480, {{0xcf13259, 0x1c}, {0x23c8e4d, 0x7}, {0xcbdab20, 0x6}, {0x23d31f6, 0x9}}, ...) github.com/snowflakedb/[email protected]/auth.go:425 +0x357 github.com/snowflakedb/gosnowflake.authenticate.func1() github.com/snowflakedb/[email protected]/auth.go:336 +0x77 github.com/snowflakedb/gosnowflake.(*retryHTTP).execute(0xcc62d40) github.com/snowflakedb/[email protected]/retry.go:313 +0x23b github.com/snowflakedb/gosnowflake.postAuthRestful({0x2743b28, 0x3579b80}, 0xcd66300, 0xcbe4af0, 0xcd663a0, 0xcbe4aa0, 0x45d964b800, 0x7) github.com/snowflakedb/[email protected]/restful.go:198 +0xde github.com/snowflakedb/gosnowflake.postAuth({0x2743b28, 0x3579b80}, 0xcd8d260, 0xcd66300, 0xcdeeb88, 0xcd663a0, 0xcbe4aa0, 0x45d964b800) github.com/snowflakedb/[email protected]/auth.go:229 +0x365 github.com/snowflakedb/gosnowflake.authenticate({0x2743b28, 0x3579b80}, 0xcbf3080, {0x0, 0x0, 0x0}, {0x0, 0x0, 0x0}) github.com/snowflakedb/[email protected]/auth.go:356 +0xead github.com/snowflakedb/gosnowflake.authenticateWithConfig(0xcbf3080) github.com/snowflakedb/[email protected]/auth.go:547 +0x508 github.com/snowflakedb/gosnowflake.SnowflakeDriver.OpenWithConfig({}, {0x2743b28, 0x3579b80}, {{0xcf13220, 0x7}, {0xcf13200, 0x1e}, {0xcf13200, 0x0}, {0x0, ...}, ...}) github.com/snowflakedb/[email protected]/driver.go:43 +0x121 github.com/snowflakedb/gosnowflake.SnowflakeDriver.Open({}, {0xcf13200, 0xf7}) github.com/snowflakedb/[email protected]/driver.go:26 +0xfb github.com/luna-duclos/instrumentedsql.dsnConnector.Connect(...) github.com/luna-duclos/[email protected]/connector.go:53 github.com/luna-duclos/instrumentedsql.wrappedConnector.Connect({{{0x2735574, 0x24c227c}, {0x27381a4, 0x3579b80}, 0x0, 0x0}, {0x273e5a8, 0xcdb63d0}, 0xcd66080}, {0x2743b28, ...}) github.com/luna-duclos/[email protected]/connector.go:33 +0x1d0 database/sql.(*DB).conn(0xcdb0f30, {0x2743b28, 0x3579b80}, 0x1) database/sql/sql.go:1387 +0x755 database/sql.(*DB).PingContext.func1(0x1) database/sql/sql.go:850 +0x47 database/sql.(*DB).retry(0xcdb0f30, 0xcc63610) database/sql/sql.go:1538 +0x5d database/sql.(*DB).PingContext(0xcdb0f30, {0x2743b28, 0x3579b80}) database/sql/sql.go:849 +0x7c database/sql.(*DB).Ping(...) database/sql/sql.go:867 github.com/jmoiron/sqlx.Connect({0x2403e35, 0x16}, {0xcf13200, 0xf7}) github.com/jmoiron/[email protected]/sqlx.go:642 +0x6d github.com/Snowflake-Labs/terraform-provider-snowflake/pkg/sdk.NewClient(0xcdd0120) github.com/Snowflake-Labs/terraform-provider-snowflake/pkg/sdk/client.go:148 +0x139 github.com/Snowflake-Labs/terraform-provider-snowflake/pkg/provider.ConfigureProvider(0xcbe4820) github.com/Snowflake-Labs/terraform-provider-snowflake/pkg/provider/provider.go:745 +0x1b6f github.com/hashicorp/terraform-plugin-sdk/v2/helper/schema.(*Provider).Configure(0xcee51a0, {0x2743b48, 0xcda3038}, 0xce09380) github.com/hashicorp/terraform-plugin-sdk/[email protected]/helper/schema/provider.go:296 +0x19e github.com/hashicorp/terraform-plugin-sdk/v2/helper/schema.(*GRPCProviderServer).ConfigureProvider(0xcec7970, {0x2743b48, 0xcda2f00}, 0xcdb3d80) github.com/hashicorp/terraform-plugin-sdk/[email protected]/helper/schema/grpc_provider.go:607 +0x404 github.com/hashicorp/terraform-plugin-mux/tf5to6server.v5tov6Server.ConfigureProvider({{0x274d588, 0xcec7970}}, {0x2743b48, 0xcda2f00}, 0xcdb3d50) github.com/hashicorp/[email protected]/tf5to6server/tf5to6server.go:80 +0x109 github.com/hashicorp/terraform-plugin-mux/tf6muxserver.(*muxServer).ConfigureProvider(0xc9df7c0, {0x2743b48, 0xcda2e28}, 0xcdb3d50) github.com/hashicorp/[email protected]/tf6muxserver/mux_server_ConfigureProvider.go:28 +0x15d github.com/hashicorp/terraform-plugin-go/tfprotov6/tf6server.(*server).ConfigureProvider(0xc9de1e0, {0x2743b48, 0xcda2be8}, 0xce14f80) github.com/hashicorp/[email protected]/tfprotov6/tf6server/server.go:568 +0x2e1 github.com/hashicorp/terraform-plugin-go/tfprotov6/internal/tfplugin6._Provider_ConfigureProvider_Handler({0x237b3e0, 0xc github.com/hashicorp/[email protected]/tfprotov6/internal/tfplugin6/tfplugin6_grpc.pb.go:449 +0x176 google.golang.org/grpc.(*Server).processUnaryRPC(0xc94adc0, {0x2743b48, 0xcda2bb8}, {0x274c074, 0xccb9400}, 0xcf595e0, 0xceae1b0, 0x3548f28, 0x0) google.golang.org/[email protected]/server.go:1372 +0xf6a google.golang.org/grpc.(*Server).handleStream(0xc94adc0, {0x274c074, 0xccb9400}, 0xcf595e0) google.golang.org/[email protected]/server.go:1783 +0x10d0 google.golang.org/grpc.(*Server).serveStreams.func2.1() google.golang.org/[email protected]/server.go:1016 +0x6f created by google.golang.org/grpc.(*Server).serveStreams.func2 in goroutine 68 google.golang.org/[email protected]/server.go:1027 +0x123

Error: The terraform-provider-snowflake_v0.85.0.exe plugin crashed!

This is always indicative of a bug within the plugin. It would be immensely helpful if you could report the crash with the plugin's maintainers so that it can be fixed. The output above should help diagnose the issue.

Steps to Reproduce terraform init terraform plan

Steps to Reproduce

Steps to Reproduce terraform init terraform plan

How much impact is this issue causing?

High

Logs

No response

Additional Information

I am using Snowflake Lab version 0.85 and latest Terraform version is 1.7.3

Can you please fix the issue.

[sumitbourne]

When I am using below terraform script then it is throwing an error .

resource "snowflake_role" "testbus_usage_accessRole" { name = "test_BUS_DEV__test_BUS__USAGE" comment = "Defined Usage Role for test" }

[sfc-gh-asawicki]

Hey @sumitbourne. Thanks for reaching out to us.

It seems, that your provider's config is incorrect. Can you share the provider "snowflake" { ... } configuration block? Please DO NOT SHARE any sensitive information.

[sumitbourne]

terraform {

required_providers {

snowflake = {

  source  = "Snowflake-Labs/snowflake"

  version = "0.84.1"

}

}

}

provider "snowflake" {

role = "test_terraform_transform_dev"

account = "******.eu-west-1"

user = "test.terraform.transform.dev"

private_key = data.aws_ssm_parameter.snowflake_private_key.value authenticator = "JWT" private_key_passphrase = data.aws_ssm_parameter.snowflake_private_key.value

}

[sumitbourne]

@sfc-gh-asawicki pls find the provider block

provider "snowflake" {

role = "test_terraform_transform_dev"

account = "******.eu-west-1"

user = "test.terraform.transform.dev"

private_key = data.aws_ssm_parameter.snowflake_private_key.value authenticator = "JWT" private_key_passphrase = data.aws_ssm_parameter.snowflake_private_key.value

}

[sfc-gh-asawicki]

@sumitbourne, this seems to be the same as issue #2317; please check it for details. I suggest doing two things:

1. Try passing the private key from file private_key = file(path/to/private/key) to validate if this works (I can't see what the contents of data.aws_ssm_parameter.snowflake_private_key are, but I think the private key is not correctly referenced here).
2. private_key_passphrase uses the same data.aws_ssm_parameter.snowflake_private_key.value as private_key - this may not matter if the key is not encrypted, but if it is, then this is either not correct passphrase or not the correct key.

[sfc-gh-asawicki]

@sumitbourne were you able to verify the suggestions?

[sumitbourne]

Yes I was able to resolve the issue.

[joestump]

@sumitbourne ran into this issue today - mind sharing how you solved it or what the issue was? 🙏🏼

[sumitbourne]

Share me your provider code, will try to debug it.