Snowflake-Labs / terraform-provider-snowflake

Terraform provider for managing Snowflake accounts
https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest
MIT License
528 stars 410 forks source link

could not show security integration err = error scanning struct err = sql: no rows in result set #2559

Closed nicolamarangoni closed 6 months ago

nicolamarangoni commented 6 months ago

Terraform CLI and Provider Versions

Snowflake Provider 0.86

Terraform Configuration

resource "snowflake_saml_integration" "saml_integration" {
  name                      = "SAML_INTEGRATION"
  enabled                   = true
  saml2_enable_sp_initiated = true
  saml2_provider            = "ADFS"
  saml2_issuer              = "https://sts.windows.net/UUID/"
  saml2_sso_url             = "https://login.microsoftonline.com/UUID/saml2"
  saml2_x509_cert           = jsondecode(data.aws_secretsmanager_secret_version.azure_app.secret_string)["saml2_x509_cert"]
}

Expected Behavior

terragrunt import snowflake_saml_integration.saml_integration saml_integration successfully import the existing SAML integration

Actual Behavior

% terragrunt import snowflake_saml_integration.saml_integration saml_integration
...
...
snowflake_saml_integration.saml_integration: Importing from ID "saml_integration"...
snowflake_saml_integration.saml_integration: Import prepared!
  Prepared snowflake_saml_integration for import
snowflake_saml_integration.saml_integration: Refreshing state... [id=saml_integration]
...
...
│ Error: could not show security integration err = error scanning struct err = sql: no rows in result set
│

Steps to Reproduce

terragrunt import snowflake_saml_integration.saml_integration saml_integration

How much impact is this issue causing?

Medium

Logs

No response

Additional Information

No response

nicolamarangoni commented 6 months ago

Sorry, there was an error in my configuration. Issue closed.

pauldraper commented 5 months ago

Note: This is the error received when there is no security integration by that name; i.e. it was not found.