Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create new warehouse is failing on v>77 #2272

Closed
bob-zarkoob opened this issue Dec 14, 2023 · 7 comments
Closed

Create new warehouse is failing on v>77 #2272

bob-zarkoob opened this issue Dec 14, 2023 · 7 comments
Labels
bug Used to mark issues with provider's incorrect behavior category:resource resource:warehouse Issue connected to the snowflake_warehouse resource

Comments

@bob-zarkoob
Copy link

bob-zarkoob commented Dec 14, 2023

Terraform CLI and Provider Versions

v78, v79 and v80
Terraform CLI: 1.6.5

Terraform Configuration

resource "snowflake_warehouse" "WH_TABLEAU_DEVELOPMENT" {
  auto_resume                         = true
  auto_suspend                        = 120
  comment                             = null
  enable_query_acceleration           = true
  initially_suspended                 = true
  max_cluster_count                   = 8
  max_concurrency_level               = 8
  min_cluster_count                   = 1
  name                                = "WH_TABLEAU_DEVELOPMENT"
  query_acceleration_max_scale_factor = 8
  resource_monitor                    = "null"
  scaling_policy                      = "STANDARD"
  statement_queued_timeout_in_seconds = 0
  statement_timeout_in_seconds        = 172800
  warehouse_size                      = "XLARGE"
  warehouse_type                      = "STANDARD"
}

Expected Behavior

Create a warehouse

Actual Behavior

Error: [errors.go:17] object does not exist or not authorized
with module.snowflake_warehouses.snowflake_warehouse.WH_TABLEAU_DEVELOPMENT
on warehouses/warehouses.tf line 43, in resource "snowflake_warehouse" "WH_TABLEAU_DEVELOPMENT":
resource "snowflake_warehouse" "WH_TABLEAU_DEVELOPMENT" {

On Snowflake I see this error:
SQL compilation error: Object 'null' does not exist or not authorized.

Steps to Reproduce

  1. terraform apply

How much impact is this issue causing?

Medium

Logs

No response

Additional Information

No response

@bob-zarkoob bob-zarkoob added the bug Used to mark issues with provider's incorrect behavior label Dec 14, 2023
@bob-zarkoob
Copy link
Author

When I switched to V0.77 it starter working

@bob-zarkoob bob-zarkoob changed the title Create new warehouse is failing on v>78 Create new warehouse is failing on v>77 Dec 14, 2023
@sfc-gh-asawicki
Copy link
Collaborator

Hey @baabaakz. THanks for reporting the issue.

Can you share the debug logs?

@bob-zarkoob
Copy link
Author

@sfc-gh-asawicki
Copy link
Collaborator

Hey @baabaakz. Unfortunately, the logs you gave me do not have the described error.

Can you share the logs with the error?

@bob-zarkoob
Copy link
Author

That error is resolved.
I had to remove resource monitor = null to make it work

@sfc-gh-asawicki
Copy link
Collaborator

It's great to hear that! Can we close it then?

@bob-zarkoob
Copy link
Author

Yes please

@sfc-gh-jcieslak sfc-gh-jcieslak added category:resource resource:warehouse Issue connected to the snowflake_warehouse resource labels May 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Used to mark issues with provider's incorrect behavior category:resource resource:warehouse Issue connected to the snowflake_warehouse resource
Projects
None yet
Development

No branches or pull requests

3 participants