snowflake_databases does not return any databases

[jifeous]

Provider Version

Terraform v1.3.2
on windows_amd64

• provider registry.terraform.io/hashicorp/aws v4.40.0
• provider registry.terraform.io/snowflake-labs/snowflake v0.52.0

Describe the bug

Using the snowflake_databases and snowflake_database data provider returns only nulls and does not return the expected db. If I check the snowflake query history I can see that it has run the correct sql "SHOW DATABASES LIKE "MYDB"".

Expected behavior

Returns the db so that I can use it to create a schema

Code samples and commands

data "snowflake_database" "domain" {
name = "MYDB"
}

output "snowflake_database" {
description = "Where is my db?"
value = data.snowflake_database.domain
}

[bennylu2]

This sounds like a permission issue. Have you confirmed the role you're using has access to list the db?

[jifeous]

yes, it's the same role that created everything including databases so I would expect it to return some in a list. Hmm, but let me turn logging on and double check it's empty.

…

On Mon, 19 Dec 2022 at 12:58, Benny Lu ***@***.***> wrote: This sounds like a permission issue. Have you confirmed the role you're using has access to list the db? — Reply to this email directly, view it on GitHub <#1383 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIK2ZH73HZNAKZBCEWKVK63WN6QJNANCNFSM6AAAAAASIGB6NM> . You are receiving this because you authored the thread.Message ID: ***@***.*** .com>

[jag-super]

I am also facing the same issue, I can confirm the role is correct and can see SHOW DATABASES LIKE "XXX" being executed under the correct role and return data. Other data sources like snowflake_role are working fine.

I'm not sure if this of relevance, but SHOW DATABASES LIKE "XXX" is has an extra column called resource_group being returned, this is not in the database struct.

[bennylu2]

data "snowflake_database" "domain" {
  name = "TEST"
}

output "snowflake_database" {
  value = data.snowflake_database.domain
}

Changes to Outputs:
  + snowflake_database = {
      + comment        = "Snowflake database for TEST"
      + created_on     = "2021-10-21T13:35:25.113-07:00"
      + id             = "TEST"
      + is_current     = false
      + is_default     = false
      + name           = "TEST"
      + options        = ""
      + origin         = ""
      + owner          = "SYSADMIN"
      + retention_time = 30
    }

I'm unable to reproduce this bug. I would confirm that the role is able to list the database

One thing to note is the provider puts double-quotes to qualify everything so it is case sensitive. For example if you created your database as "test" you need to pass "test" and not "TEST" to the data source

[jifeous]

The more general case is that no databases are returned from the snowflake_databases data provider

data "snowflake_databases" "this" {}

output "databases" {
  description = "Current Databases"
  value = data.snowflake_databases.this
}

Outputs:

databases = {
  "databases" = tolist(null) /* of object */
  "id" = tostring(null)
}

I can see the query in Snowflake and it returns the correct list of databases. It doesn't show in the terraform state.

I don't know what the difference could be

[brettwatkins-Built]

@jifeous @jag-super @bennylu2 did you ever figure out what the issue here was? I'm running into the same thing

[jag-super]

@brettwatkins-Built No I didn't, you may want to try the latest provider version, as I was using a very old one and there have been changes.

[jifeous]

no, didn't figure it out and just did something else in the end

…

On Wed, 22 Nov 2023 at 23:43, jag-super ***@***.***> wrote: @brettwatkins-Built <https://github.com/brettwatkins-Built> No I didn't, you may want to try the latest provider version, as I was using a very old one and there have been changes. — Reply to this email directly, view it on GitHub <#1383 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AIK2ZH3EG3T3RFQPUNPXC2TYFXJLXAVCNFSM6AAAAAASIGB6NOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMRSGUZDGMBTHA> . You are receiving this because you were mentioned.Message ID: ***@***.*** .com>